July 25, 2007 at 1:03 pm
I have recently started to delve into Integration Services, having upgraded all our stuff to 2005 early this year. I have to say I'm not seeing the benefits of SSIS over DTS.
Let me give you a quick overview of my scenario before delving into my question. I use the Import/Export wizard in SQL Server Management Studio to move data in and out of my tables. I select the option to save the SSIS Package in SQL Server. Now, if I want to edit this package, I need to open up Visual Studio 2005 and "Add an existing package" to an Integration Services project. At this point I believe I'm working on a copy of the package. If I want to then schedule this package I need to switch back to SQL Server Management Studio, add existing package, and schedule the package.
My question is: Is there a better way? Is there a way to synchronize my SSIS packages so that I can edit them in Visual Studio without having to re-add them in Management Studio?
Please advise. I would prefer to do things the proper way and am not seeing a lot of info about this on the web.
Paul Liadis
July 26, 2007 at 2:04 am
There are many advantages to SSIS over DTS and even more articles on google about it so I won't bother mentioning them here. Except the pipe line...
On to your second question: Don't save packages to SQL. There are not advantages and I suspect that functionality was done by a techie who had nothing better to do (Could have given us some more features though)
Save your package to the FS and schedule them from there. It allows for much more flexibility and use. Also easier to deploy. Setup the agent job to run the package from the file system instead of SQL.
Don't forget to use config files, also FS based..
HTH
Cheers,CrispinI can't die, there are too many people who still have to meet me!It's not a bug, SQL just misunderstood me!
July 26, 2007 at 7:30 am
Thanks Crispin. I'll go with the File System and see how it flies with my users. At least it eliminates the duplication of work.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply