SSIS SQL Task Executing on first day of Every Quarter

Question

0.00/5 (No votes)

See more:

Creating with SSIS Package in SQL2008.

Used Two SQL Script Tasks "Initiation Job" and "Update Table" .

I have few Update queries in "Update Table" and I have to update these queries on first day of Every Quarter.

So pls help me what to write in the "Initiation Job"???

Posted 18-Mar-13 4:36am

Biodude Basava

Add a Solution

Comments

ZurdoDev 18-Mar-13 10:45am

Quarter is relative. Do you mean quarter of each year with Q1 being Jan 1? Or is this fiscal quarters for the company? Also, where exactly are you stuck?

[no name] 18-Mar-13 11:16am

You want an SQL Job Agent.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Kuthuparakkal · Accepted Answer · 2013-03-18T18:32:00

Solution 1

The best way is to use SQL Server Job Agent, you get flexibility of scheduling job at any time.
But if you are particular about SSIS and Execute SQL Task, then you may use this:

SQL

DECLARE @CanExecute INT

SET @CanExecute = CASE WHEN
                      CONVERT(VARCHAR(10),GETDATE(),112) =CONVERT(VARCHAR(10),DATEADD(qq,DATEDIFF(qq,0,GETDATE()),0),112)
                      THEN 1
                      ELSE 0
                  END

IF( @CanExecute = 1)
BEGIN
--Your Update SQL Goes here
END

Posted 18-Mar-13 18:32pm

Kuthuparakkal

Comments

Biodude Basava 20-Mar-13 1:30am

Hi @Kuthuparakkal....Thanks for the solution.
I added this code with the update queries in SQL task and i set the connection. when i execute this its got failed.
Please tell me the correct procedure to create the ssis package for above?

Kuthuparakkal 20-Mar-13 2:12am

Check your update statement.
Check connection used in Execute SQL Task
Check your permissions against the DB connection used.
Post error message.

Biodude Basava 20-Mar-13 3:03am

If i execute the whole query in sql query window its working so there is no problem with update statement.
Connection i checked it.
I have an access.
After running the package sqlTask will appear in red color.

Kuthuparakkal 20-Mar-13 3:58am

Post the error message

Biodude Basava 20-Mar-13 4:34am

Package Execution Completed.Click to switch designer mode,or select Stop debugging from debug menu.
but SQL Task is shown in RED Color.

Kuthuparakkal 20-Mar-13 5:24am

Go to package execution summary right after executing package, scroll down till you see errors. Post those errors

Kuthuparakkal 20-Mar-13 5:51am

You see Tabs on Visual Studio like "Control Flow", "Data Flow", ... "Progress", go to the "Progress" tab right after package execution. You will come to know what's the error, post it.

Biodude Basava 20-Mar-13 8:02am

Hi@Kuthuparakka... thanks for the suggestion..there was a connection problem and its executing perfectly :):)

Biodude Basava 22-Mar-13 2:28am

Hey @Kuthuparakkal..when i run the above query in query window its shows the command executed successfully..But it is not updating the record...
and tell me how to check for other quarters? pls revert asap :(:(

Kuthuparakkal 22-Mar-13 4:42am

It work only when you execute the first day of any quarter...