Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
DTSX package
Message
From
02/06/2011 09:23:40
Mike Cole
Yellow Lab Technologies
Stanley, Iowa, United States
 
 
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:
01512539
Views:
54
Your parents must not have liked you... they named you Sql.

>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,
Very fitting: http://xkcd.com/386/
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform