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?