<div>
Thank you. &nbsp;That was exactly what I needed.
</div>


Thank you.  That was exactly what I needed.

<div>
<div class="content wysiwyg-content">
I'm trying to do a simple text import into a table. &nbsp;This took about 15 minutes to build in the SQL 2000 DTS system.<br />
<br />
I tried using Visual Sduio and had so many problems that I decided to start from scratch using the import export wizard. &nbsp;This really isn't a complicated operation - most of the fields are text with about 5 exceptions that are int or date. &nbsp;<br />
<br />
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. &nbsp;I saved it as an SSIS package on the SQL server.<br />
<br />
Only problem is, I mapped one of the destination fields to the wrong source.<br />
<br />
There doesn't seem to be a way to access my package from inside Management Studio where I built it.<br />
<br />
If I go into Visual Studio, there doesn't seem to be a place to open packages saved on the SQL server.<br />
<br />
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?
</div>
</div>


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?

SQL 2005 Modify SSIS created in Import Export Wizard

Microsoft SQL Server 2005 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. It includes support for managing XML data and allows a database server to be exposed over web services using Tabular Data Stream (TDS) packets encapsulated within SOAP (protocol) requests.