Re: Editing an SSIS package created by Import/Export Wizard
- From: Jared <google@xxxxxxxxxxxxxxxxxxxxxx>
- Date: Fri, 10 Aug 2007 14:31:52 -0700
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.
Sorry if I was unclear. I created the SSIS package using the BIDS
Import/Export wizard. SQL Server 2000 is only mentioned because it is
the source database, but I am not using any pre-existing DTS packages.
I can open the package in BIDS, and I can see the for...each loop and
other Control Flow objects that it creates. However, there is no way
to modify the tables involved, or any other options such as truncate
first, identity insert, etc. I can dig to find that this information
is stored in TableSchema.xml, but that file is tucked away as a *.tmp
file, clearly not intended to be user-editable.
I managed to get it working by unchecking the "Optimize for many
tables" option in the Import/Export Wizard so that there's no
for...each loop in the Control Flow. However, it runs the Control
Flow objects in the wrong sequence when I execute the package. The
only way I've been able to make this work is to manually run each step.
.
- References:
- Editing an SSIS package created by Import/Export Wizard
- From: Jared
- Re: Editing an SSIS package created by Import/Export Wizard
- From: acorcoran
- Editing an SSIS package created by Import/Export Wizard
- Prev by Date: Saving data to SQL Data Base
- Next by Date: Help with queries - Top N by Group, and Query using 'IN'
- Previous by thread: Re: Editing an SSIS package created by Import/Export Wizard
- Next by thread: readonly database
- Index(es):
Relevant Pages
|
