June 30, 2010 at 3:02 pm
I used the Export Data Wizard within SSIS to export data. Instead of actually running the export, I chose "Save SSIS Package" to "SQL Server" (not File System).
I then create a new Connection to Integration Services, and under MSDB, I can see the package, but there's no "edit" option. There's "Import" and "Export", but how do I open it to make changes ?
As you can tell, I have not used SSIS before.
June 30, 2010 at 3:16 pm
while connected to Integration services under msdb you can right click on the SSIS and export it to a file. you can then right click on the file once it is saved locally and click edit. Enjoy!
Dan
If only I could snap my figures and have all the correct indexes apear and the buffer clean and.... Start day dream here.
July 2, 2010 at 10:12 am
You can also use BIDS-Business Intelligence Development Studio a custom version of Visual Studio that is shipped with SQL Server 2005.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply