I was not really any help at all, to be honest - I just asked a lot of (probably) annoying questions 🙂

Here's my point: if a date from another system...

But when I asked you what the datatype of CREATEDTS was, in SSIS, you said Date.

How can it ever work? It will fail before you even get a chance to...

I do not think that 1/1/0001 is a valid date in SSIS and that may be causing some issues for you.

I just tried to create a derived column as follows:

(DT_DATE)"0001/01/01"

but...

What's the datatype of CREATEDTS - is it datetime or string?

Can you explain what you are trying to do? Based on your code, I am not sure ...

I am confident that I could do it all in a script task, yes.

But I do not have anything written to help you out ... maybe someone else has done...

Eric Klovning (6/23/2009)

---

Right click on the connection manager and select Edit. The Flat File Connection Manager Editor will open, then select Advanced in the left hand pane. This will list...

That's not easy at all. Somehow you are going to have to determine the underlying datatype of all the random columns, plus max string length etc.

Excel itself tries to do...

Ahhh, the dreaded silence after posting which leaves you with that sinking feeling that maybe you are the only one experiencing this particular errant behaviour 🙂

It would be useful background...

OK, I understand. So I'm guessing that the error only appears during execution of the Foreach loop?

Can you post the text of the full error message - as reported by...

Please paste the full text of the error message and describe the point at which the error is displayed.

You might also consider doing these at...

Try this:

Dim FlatCon As ConnectionManager = Dts.Connections("MyFlatFileConnection")

MsgBox(FlatCon.ConnectionString)

Have you tried putting a msgbox in the code to verify 100% that it is not running?

You could also check that the EntryPoint property for your script matches the class...

Nothing tidy. Use another character as your field delimiter, or replace/delete the commas before you export the BLOB.