SQL 2008 SSIS - Import Export Wizard

Import Export Wizard - I want to use the Imiport/Export Wizard to send data from a SQL database (same server) to an excel spread sheet. I want the wizard to create a SSIS package and to do that you basically need to just follow the steps of the wizard. So I do that and in the page that says "You can save the SSIS package for reuse, you must save the package to schedule it for later execution" I name it and then the final page comes up that details all the steps of the wizard. I cleck finish and everything works.
MY QUESTION IS: so where do I find the saved package. It says that package will be saved to the server. I can not find the saved package to schedule it.
SeTechAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

ValentinoVBI ConsultantCommented:
It depends on what you selected in the "Save and run package" screen.  You can select either SQL Server or File System.  In the case of SQL Server, the package is saved to the MSDB. In case of file system, I believe you're asked where to save the package.

Have a look here for an article on how to use the wizard to import data from Excel, the other way around of what you want to do but the steps are similar: http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SSIS/A_3248-Importing-Excel-Data-Using-Integration-Services.html

The article also explains how to retrieve the package from SQL Server into the BIDS.
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Microsoft SQL Server 2008

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.