Re: Editing an SSIS package created by Import/Export Wizard

On Aug 8, 8:54 pm, Jared <goo...@xxxxxxxxxxxxxxxxxxxxxx> wrote:
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

So am I understanding you correctly that you took a DTS package from
SQL 2000 and migrated to a SSIS object in SQL 2005 or did you simply
migrate it to a legacy DTS package within SQL 2005? If you utilized
the SSIS method, I believe you need to utilize the Business
Intelligence Designer that came packaged with your SQL 2005
installation. Looks like a Visual Studio icon.

Otherwise, if you simply utilized the legacy situation, you will
simply need to download the DTS Designer components for SQL 2005 and
you can continue your design steps in that aspect.

I'm rather new to SSIS personally, but I believe these are the steps I
took when doing some of my migrations.

.

Relevant Pages

  • Re: SqlServer 2005: Want to set up SSIS job to import flat file data into 18 tables on a nightly bas
    ... > Package Execution and Checkpoints. ... I'd like to use SSIS ... >>and successfully imported the flat file into the database table. ... >>using the BI Designer debugger ... ...
    (microsoft.public.sqlserver.dts)
  • Re: more detail on issue
    ... I went to SSIS ... package, on the package properties i selected 'EncryptallwithPassword', gave ... strings not being visible to the SQL Agent user. ...
    (microsoft.public.sqlserver.dts)
  • Re: Cannot Schedule a SSIS Job
    ... Try also to add a job with SSIS step through script. ... it loads package from the file system, ... Dejan Sarka, SQL Server MVP ... This message does not imply endorsement from Solid Quality Learning, ...
    (microsoft.public.sqlserver.setup)
  • RE: SSIS 2005 package developed with VS 2008
    ... Using Integration Services 10.0.1600 (Is this SQL 2008 Integration Services?) ... You create an SSIS package using Visual Studio 2008, ...
    (microsoft.public.sqlserver.dts)
  • Re: DTS to SSIS lost functionality
    ... Try this with both a wizard in DTS and a wizard in SSIS: ... Crate a package that exports data from a SQL table and dumps into an Excel ...
    (microsoft.public.sqlserver.dts)
Quantcast