Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 488
  • Last Modified:

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

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now