August 6, 2012 at 12:23 pm
I needed to use the Import Wizard to setup a load replace of a table daily from a flat file. I went through the wizard and set it all up and saved it as an SSIS package in MSDB so I can schedule it to run. (SQL Server 200R2). My question is, now that I have saved it how do I open it up to see what it does in the future? Say, I leave the company and someone has no idea what it does? I don't see a way in Business Intelegence studio to open this up? Any thoughts?
August 6, 2012 at 12:56 pm
In SSMS Object Explorer window, Connect>Integration Services. Choose the server where saved the package. Expand out Integration Services until you see your package, right-click and choose Export package. This will allow you to save it in the file system.
Now in BIDS or Visual Studio, create a new Project/Solution. In the Solution Explorer, right-click the SSIS Packages node and choose Add Existing Package. Browse to where you saved the dtsx file in the step above and select it. Now double-click the package in the Solution Explorer. You can now manipulate the various tasks (control flow, data flow, etc).
August 6, 2012 at 1:17 pm
OK, thanks. Seems odd to me that they will allow you to save it in MSDB but never open it or alter it ever again.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply