I have successfully created several SSIS packages in the Development Studio. I want to schedule those packages to run with SQL Agent. The only way I could schedule them was to go to File>Save copy as...(not save as) which would give me a choice of either to save it to SQL Server or SSIS Package Store. Using this method allowed me to schedule the package but then I couldn't figure out how to edit the package without going back into the Development Studio, right-clicking on SSIS packages and selecting "Add Existing Package" and selecting that package from the SSIS Package store then opening it to edit.
That seems like a lot of work to edit a package. Is that the desired way to create, save, schedule and edit a SSIS package?
Thanks for any help.
This is the correct way. The idea is that you have a development version of your package and what is what you edit in BIDS. When you are happy with the package then you deploy it to your production environment. If you want to make changes then make changes to the package in BIDS and redeploy.
-Jamie
|||Thanks so much! That makes me feel better.
No comments:
Post a Comment