SQL 2005 Modify SSIS created in Import Export Wizard

I'm trying to do a simple text import into a table.  This took about 15 minutes to build in the SQL 2000 DTS system.

I tried using Visual Sduio and had so many problems that I decided to start from scratch using the import export wizard.  This really isn't a complicated operation - most of the fields are text with about 5 exceptions that are int or date.  

So, I built a nice little package in the Import Export wizard and after sorting all the data types out and running it, it finally works.  I saved it as an SSIS package on the SQL server.

Only problem is, I mapped one of the destination fields to the wrong source.

There doesn't seem to be a way to access my package from inside Management Studio where I built it.

If I go into Visual Studio, there doesn't seem to be a place to open packages saved on the SQL server.

I guess I'm missing something that will be obvious in retrospect, but I can't figure out how to get back into that package and make the minor change without starting from scratch?
ckuciaAsked:
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.

 
vdr1620Commented:
This is what you can do. Connect to Integration services using Managemnet studio..
Stored Packages -->MSDB-->Rt click on the package and select Export and In the Window select file system and Select the path(where you want to save your package) below and Click Ok

Browse to the Path and Rt click on the package and open with Visual studio Where you can edit your package and save it
0

Experts Exchange Solution brought to you by ConnectWise

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
 
ckuciaAuthor Commented:
Thank you.  That was exactly what I needed.
0
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.

All Courses

From novice to tech pro — start learning today.