Hi there,

I want to know if this is possible in a SSIS Package. I am importing some
Flat Text File to a table, but I would like to add a column to the package,
and I am able to do this, but I would like to have some specific data in the
new column added for each row in the flat file. is this possible? Or I was
thinking once the data from the flat file gets imported to the table in SQL
server, I could add a column to that table with some specifc data for each
row with another SSIS package?

Some ideas on how to accomplish this?

Help would so much appriaciated.

Thanks very much in advance,

Manny

I think what you are looking for is the Derived Column Transformation
Located in the Data Flow Task.

Here is the best article to understand the transformation...
http://msdn2.microsoft.com/en-us/library/ms141069.aspx


--
/*
Warren Brunk - MCITP - SQL 2005, MCDBA
www.techintsolutions.com
*/


"Midway" <Midway (AT) discussions (DOT) microsoft.com> wrote

Thanks very much Warren!!!! GREAT HELP

Manny

"Warren Brunk" wrote: