Post reply

Integration service required

  • December 8, 2009 at 6:02 am

    #228402

    Dear All

    I have one doubt

    Is it necessary to install SSIS Service to run SSIS Package as sql agent job

    Thanks

    Ghanshyam

  • December 8, 2009 at 7:04 am

    #1089192

    gupta1282 (12/8/2009)

    Dear All

    I have one doubt

    Is it necessary to install SSIS Service to run SSIS Package as sql agent job

    Thanks

    Ghanshyam

    The short answer is yes the long answer is you can develop with BIDS but at deployment your code blows if you are running the wrong SSIS version for the code you have written. You need at least standard edition for base ETL tasks and Enterprise for complex ETL tasks.

    Kind regards,
    Gift Peddie

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply