This seems to delete files, not folders ...

Please post the code fragment which is causing the error and the text of the error message.

I was obviously in a 'read English, not code' mood when I responded, because I didn't even look at your DDL. Now that I have, I see that we were...

Thanks for the feedback, glad to have helped.

--deleted

Expanding on this idea,...

I just tried it and it worked as I suggested.

Against the properties for your flat file source, have you got 'retain nulls' set to true?

Something else is happening here.

If I import the record

Affinity,,CT

into a database, I can guarantee that field number 2 would not somehow become a space in my database table. Do you...

Sounds like a good solution to me.

dndaughtery (2/4/2010)

---

Yeah its in a script transform in a data flow component. I basically need a way to add a unique record id for each record. I'm open to any...

You use the word 'retain' in your original post. If a value is null in a database column and you export it to a text file, the way of retaining...

,, in a text file is the equivalent of NULL in a database table.

PATINDEX is not a valid function in SSIS expressions.

Maybe adding an additional condition would help:

&& FINDSTRING(Email,"@",1) < (LEN(Email)) - FINDSTRING(REVERSE(Email),".",1))

Wouldn't this fail at the import stage, because SSIS would validate the number of fields...

Please show an actual example of the data in your flat file which shows how 'blank' and 'null' differ.