Post reply

SSIS new version process

  • April 29, 2009 at 10:49 am

    #131051

    I am working on a SSIS package that download data. The package works fine in BIDS and when I import it into SSIS. However I created a Sql Server agent job and I am getting an error. Now I have to change the package in DIBS. Will SSIS and Sql Server agent jobs recognize the changes made in BIDS or do I need to delete the SSIS package and Job and recreate them?

    It is easy to see I haven't bought The SSIS book that I was looking at.

    Thanks

    Quinn

  • April 29, 2009 at 11:55 am

    #986166

    You don't have to recreate the job. You will have to deploy the new version of the package to the expected storage location, though. Just repeat what you did to move the original package to SSIS.

    Greg

  • April 29, 2009 at 12:36 pm

    #986195

    Thanks Greg!

    Quinn

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

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