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.

Why not avoid the datatype conversions completely?

declare @Today date

declare @NowTime time

select @Today = getdate()

,@NowTime = getdate()

select @Today

...

manibad (5/6/2013)

---

sgmunson (5/6/2013)

---

I'm at the point of making an assumption about what the poster meant by their most recent post. Given the technique of concatenating a series of...

pmcquirk 96901 (5/6/2013)

---

Basically I am recieveing multiple flat files of two different file layouts, the file names do not give a clue to the layout, howevet the files (pipe delimited...