OK, I was able to successfully migrate all of my DTS packages to SSIS, for SQL 2005. I can log into intergration services and see my packages listed under:
servername --> stored packages --> msdb. Now my question is, how can I open these packages, not run them open them in a design mode like you can in SQL 2000, you can double click on the package name and view the design of the package. how can i do that now that I have them in SQL 2005?
Right click on the package and select "Export..."
Chose File System as the destination and once done filling in the fields, you'll be able to open that package up in Business Intelligence Developer Studio.|||
Thanks, I tell ya, I should have walked away from this project when it was brought to me.
Coming from coding .NET apps for the pass 6 years, this SQL style work is a whole new world to me.
ok, thanks
No comments:
Post a Comment