June 15, 2012 at 8:01 am
I think, you should create a sql agent job, in first step, run the ssis package, and the second step, based on the condition you can do the next task/package, since, you can put your conditions in sql server agent.
June 21, 2012 at 12:35 pm
I would love more info on how to add conditional logic to a SQL Agent job as I have not found that functionality and could certainly put it to use.
June 21, 2012 at 12:41 pm
herladygeekedness (6/21/2012)
I would love more info on how to add conditional logic to a SQL Agent job as I have not found that functionality and could certainly put it to use.
In a job you do it via step control on pass/fail of other components and control step-order. It's not pretty but it works.
Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.
For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA
June 25, 2012 at 6:05 am
Jan.Sundbye (6/8/2012)
I have similarly need but in my case I just want to build and maintain one package and use a parameter as a variable in the package. Can someone please tell me how to pass parameters to a package?
Elliott Whitlow (6/14/2012)
It depends on how you are calling it.Please explain how you call the package and we'll see what we can do..
CEWII
My scenario
Import five textfiles into three different environments:
Development
Test
Production
The package that imports the textfiles is already built. I want to use a parameter for the Target Database in the Connection String in Connection Manager.
June 25, 2012 at 6:20 am
Jan.Sundbye (6/25/2012)
Jan.Sundbye (6/8/2012)
I have similarly need but in my case I just want to build and maintain one package and use a parameter as a variable in the package. Can someone please tell me how to pass parameters to a package?Elliott Whitlow (6/14/2012)
It depends on how you are calling it.Please explain how you call the package and we'll see what we can do..
CEWII
My scenario
Import five textfiles into three different environments:
Development
Test
Production
The package that imports the textfiles is already built. I want to use a parameter for the Target Database in the Connection String in Connection Manager.
Sounds like standard configuration files would work for you. But as you did not answer Elliott's question (even though you quoted it!) I can't be certain.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
June 26, 2012 at 12:49 am
Phil Parkin (6/25/2012)
Sounds like standard configuration files would work for you. But as you did not answer Elliott's question (even though you quoted it!) I can't be certain.
Oops. Never rush things :hehe:
The three jobs will be scheduled. Either as jobs executed by SQL Server Agent (preferred) or by Windows Scheduler.
June 27, 2012 at 2:23 pm
Evil Kraig F (6/21/2012)
herladygeekedness (6/21/2012)
I would love more info on how to add conditional logic to a SQL Agent job as I have not found that functionality and could certainly put it to use.In a job you do it via step control on pass/fail of other components and control step-order. It's not pretty but it works.
Oh, not really adding custom conditions. crap, I had my hopes up ...
Viewing 7 posts - 31 through 36 (of 36 total)
You must be logged in to reply to this topic. Login to reply