Solved

SQL 2005 Modify SSIS created in Import Export Wizard

Posted on 2010-08-27
2
476 Views
Last Modified: 2012-05-10
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
Comment
Question by:ckucia
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
2 Comments
 
LVL 16

Accepted Solution

by:
vdr1620 earned 250 total points
ID: 33543524
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
 

Author Closing Comment

by:ckucia
ID: 33543665
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.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction: When running hybrid database environments, you often need to query some data from a remote db of any type, while being connected to your MS SQL Server database. Problems start when you try to combine that with some "user input" pass…
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
There's a multitude of different network monitoring solutions out there, and you're probably wondering what makes NetCrunch so special. It's completely agentless, but does let you create an agent, if you desire. It offers powerful scalability …
Monitoring a network: how to monitor network services and why? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the philosophy behind service monitoring and why a handshake validation is critical in network monitoring. Software utilized …

623 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question