Editing an SSIS package created by Import/Export Wizard

I'm migrating a database from SQL Server 2000 to SQL Server 2005. I
can create an SSIS package using the Import/Export Wizard, but the
details of that package appear to be uneditable in the designer.

For instance, I'd like to modify some of the column mappings. The
designer shows me a Foreach Loop Container that wraps a Transfer Task
object and an Execute Inner Package object. Attempting to figure out
how this works, I managed to dig up the TableSchema.xml object that
was saved as a *.tmp file.

I came across another post saying that "modifying the XML file in
Notepad is trivial". I'm very familiar with both Notepad and XML,
but, c'mon... this seems like a ridiculous solution. I've got to be
missing something obvious here.

What is the recommend method of modifying a package created by the
Import/Export Wizard?

TIA
Jared

.

Relevant Pages

  • Re: Can you use osql in DTS?
    ... This sounds simple enough to do in a single package. ... ActiveX Script task to build the date and time strings to populate the ... Data Pump task that executes a proc that populates a table and then ... Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.dts)
  • Re: Can you use osql in DTS?
    ... This sounds simple enough to do in a single package. ... ActiveX Script task to build the date and time strings to populate the ... Data Pump task that executes a proc that populates a table and then ... Columnist, SQL Server Professional ...
    (microsoft.public.sqlserver.programming)
  • Re: Migrating DTS Local Package from test to production environments v7.0
    ... The version of SQL Server on which the package was create is SQL Server ... DTS runs at the client so manually will be on the invoker's PC which in this ...
    (microsoft.public.sqlserver.dts)
  • RE: Migrating DTS to Integration Services
    ... let me answer your Encryption issue when you expand your MSDB ... used to connect to your SQL Server, ... Open services.msc and restart your SQL Server Integration Service. ... Migrate DTS 2000 packages or Add Existing package (since you have migrated ...
    (microsoft.public.sqlserver.dts)
  • Re: SQL Table export to Excel
    ... Import/Export wizard. ... This will invoke the DTS ... For the source, select the SQL Server OLE DB provider, the ... allows you to schedule the package. ...
    (microsoft.public.sqlserver.tools)
Loading