The following seemed to have worked...

(LEN(TRIM((SUBSTRING([Column 0],247,8)))) < 1 ? "" : (SUBSTRING([Column 0],247,2) + "/" + SUBSTRING([Column 0],249,2) + "/" + SUBSTRING([Column 0],251,4)))

by reformatting the string to the dd/mm/yyyy...

It was the substring length that was the problem. I had the wrong lengths and it was masked by the fact these are fixed length rows with a lot...

I tried putting two Derived Column objects in line with the substring function in the first and the cast in the second and it works fine without any errors. ...

I finally had some one point out what the problem was on another board. I was using a SQL Server Destination which will only work for the server the...

Whats really baffling about this is I have a Execute SQL Task on the front end of this package that flushes the tables prior to populating them and it works...

Good call! Thanks for the help!!! 😀

The Conditional Split seem to work pretty good 🙂 . My only issue now is I can't seem to get it to write to the same textfile during the...