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.