Not sure. I'll test and post back in a few days.

Cheers,

Z

Matija, thanks for the response. No, the entire expression was not posted just this snippet. I was looking for a way to convert this to a CASE statement....

bitbucket, that works beautifully. Thanks all for the input.

Close. The import is going to a table in the db. These records are being added. This field needs to be incremented by for each row processed....

Okay sounds good. How might I go about taking the staging table route? Never had this many flat files to import and to multiple tables.

Thanks for all the...

10004 |Howard |Leah |DC |Washington D.C. |2806 |GS |lmhoward |leah.howard@bakerd.com |lmhoward |\\Dcfsps1\Vol3\Home\lmhoward\myscans

Here is one row from the flat file source. This entire row has information that goes to different...

Gotcha, well I have a flat file that has ten columns in it when connected by a connection manager. Let's say columns 0, 1, 2, 5, and 8 are...

Just food for though. Once you run through the DB setup if you get the error where the connection string isn't saved try changing the Credentials Type to something...

Thanks Jeff, appreciate the help.

Sincerely,

Z