interactive package in SSIS?

  • 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.

  • 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.

  • 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.


    - Craig Farrell

    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

  • 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.

  • 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.


  • 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.

  • 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