Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
DTSX package
Message
Information générale
Forum:
Microsoft SQL Server
Catégorie:
Import/Export
Titre:
Versions des environnements
SQL Server:
SQL Server 2008
Application:
Desktop
Divers
Thread ID:
01512497
Message ID:
01512511
Vues:
82
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/
Précédent
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform