Solved

SQL 2005 Modify SSIS created in Import Export Wizard

Posted on 2010-08-27
2
448 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
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

Use Case: Protecting a Hybrid Cloud Infrastructure

Microsoft Azure is rapidly becoming the norm in dynamic IT environments. This document describes the challenges that organizations face when protecting data in a hybrid cloud IT environment and presents a use case to demonstrate how Acronis Backup protects all data.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
sql calculate reminders 11 73
INSERT DATE FROM STRING COLUMN 18 56
SQL Server: SNAPSHOT replication to include a newly added table. 2 29
Help Required 2 32
INTRODUCTION: While tying your database objects into builds and your enterprise source control system takes a third-party product (like Visual Studio Database Edition or Red-Gate's SQL Source Control), you can achieve some protection using a sing…
In this article we will get to know that how can we recover deleted data if it happens accidently. We really can recover deleted rows if we know the time when data is deleted by using the transaction log.
This Micro Tutorial will teach you how to censor certain areas of your screen. The example in this video will show a little boy's face being blurred. This will be demonstrated using Adobe Premiere Pro CS6.
Finds all prime numbers in a range requested and places them in a public primes() array. I've demostrated a template size of 30 (2 * 3 * 5) but larger templates can be built such 210  (2 * 3 * 5 * 7) or 2310  (2 * 3 * 5 * 7 * 11). The larger templa…

777 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