Part of my DTS Package needs to take a flat file and transform 40 of the
columns to 1 staging table, and 10 columns to another staging table.

How do I do this so that I can see if BOTH transactions were Successul?

I have this now

TXT------(40cols)------SQL Table:StagingAsset

I'm sure I'm not doing this right (using a best practice).

-Erik

The way I would do this is to have the text file imported to a working table
"AS IS" and then use TSQL to do the moving of the relevant columns

Whilst you can do it in one hit, this involves using Lookups and these
operate Row * Row

--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.Konesans.com


"Erik Grob (MCP)" <erikg (AT) pcslink (DOT) com> wrote