Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DTSX package
Message
General information
Forum:
Microsoft SQL Server
Category:
Import/Export
Title:
Environment versions
SQL Server:
SQL Server 2008
Application:
Desktop
Miscellaneous
Thread ID:
01512497
Message ID:
01512511
Views:
81
This message has been marked as the solution to the initial question of the thread.
Hello Bob,

>I have imported data into my SQL 2008 database using the Import Wizard. When running the package I had the option to save the SSIS package into a .dtsx file.
>
>How do I access this file for future imports?

If you have already created an SSIS packages, it is best to save it for further use.
You can save it on file system on a SQL Server or on an SSIS server.

In both options, you can easily re-run the saved ssis package.
In order to run it later, open SSMS. Connect to the SSIS server where you saved or deployed your package.
Then the package will be listed in the corresponding sub folders below the SSIS server

Please check the export to excel sample at http://www.kodyaz.com/articles/export-data-to-excel-sql-server-integration-services-ssis-package.aspx

There in that tutorial, you will find how to create an package using wizard, save it on SSIS and use it later.

I hope that helps,
Share to grow knowledge and experience on SQL Server
http://www.kodyaz.com
http://www.ms-sql-server.com/
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform