Hello,

I have 2 questions regarding SSIS Packages
1. When I design a SSIS package through right click Databases - Tasks - Import Data - SQL Server Import and Export Wizzard and save this package (using: Save SSIS Package / SQL Server) I can't find it anywhere. So my question is where can I find my just saved SSIS Package?

2. I would like to run this SSIS Package in the following ways
a. bij manual start
b. as part of a job
c. as part of a stored procedure (if possible)

How can I do this?

Many thanks in advance,

John

When you run the 2008 SQL Server Import and Export Wizard from SQL Server Management Studio, you have the option of saving the package to the SQL Server msdb database or to the File System.

To access a package saved to the msdb database or to the File System, open SQL Server Management Studio and connect to Integration Services. Then, expand the Stored Packages node. For more information, see Managing Packages at http://msdn.microsoft.com/en-us/library/ms137916.aspx .

For information on how to run a package as a job:
"Scheduling Package Execution in SQL Server Agent" at http://msdn.microsoft.com/en-us/library/ms141701.aspx

"How to: Automate SSIS Package Execution by Using the SQL Server Agent (SQL Server Video)" at http://msdn.microsoft.com/en-us/library/dd440761.aspx

"Troubleshooting: SSIS Package Execution Using SQL Server Agent (SQL Server Video)" at http://msdn.microsoft.com/en-us/library/dd440760.aspx

Thank you very much!