Reported as spam (again).

Do not use messagebox in server-side jobs. There is no one there to click OK.

Try this for starters.

Then please post back with any specific questions.

That's a neat technique, thanks for posting.

Quite a common requirement seems to be reading the first n characters, or the first row, of a text file to determine its type/layout...

I've just checked your solution - the data flow starts by using a Script Component to check the file type - and every single row of every file will go...

Yes it's...

Not easily.

You could try...

It was the use of the word 'rendering' that puzzled me - I think that 'generating' is...

dawnbrown243 (5/7/2013)

---

OCR means Optical character recognition, it is the mechanical or electronic conversion of scanned images of handwritten, typewritten or printed text into machine-encoded text. Some PDFs are scans, so...

visu.cts2012 (5/8/2013)

---

I'm working on some real time project. There is an already existing DataBase. In that DB, i need to change particular column DataType. Can we change datatype of column...

dg227 (5/7/2013)

---

Without PS or a script component, you can treat the data records in the given file as a single column text field. In the data flow, start with...

This is probably what you meant by "I can program the loading process in another way, I know." but to remove most of the doubt I like to code extracts...

SteveEClarke (5/7/2013)

---

Totally amazing when you read a piece of code so many times and blind by your own perfections.

Have a sandwich .... have a drink .... come back ....

Only to...

OK - forgot about that. But at least you can change the date bit. The error message suggests that that is where your problem is occurring.

That's what my code does.