Viewing 15 posts - 12,676 through 12,690 (of 13,849 total)
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...
June 25, 2009 at 5:44 am
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...
June 25, 2009 at 4:53 am
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...
June 25, 2009 at 1:52 am
What's the datatype of CREATEDTS - is it datetime or string?
June 25, 2009 at 12:28 am
Can you explain what you are trying to do? Based on your code, I am not sure ...
June 24, 2009 at 10:11 pm
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...
June 24, 2009 at 1:04 am
Eric Klovning (6/23/2009)
June 23, 2009 at 11:15 pm
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...
June 23, 2009 at 11:13 pm
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...
June 23, 2009 at 7:44 am
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...
June 23, 2009 at 4:49 am
Please paste the full text of the error message and describe the point at which the error is displayed.
June 23, 2009 at 4:21 am
jreece (6/22/2009)
John,--
I am now going to add a few derived columns - I thought "Create_Date" and "Change_Date" might be very useful for tracking updates.
You might also consider doing these at...
June 22, 2009 at 6:27 pm
Try this:
Dim FlatCon As ConnectionManager = Dts.Connections("MyFlatFileConnection")
MsgBox(FlatCon.ConnectionString)
June 22, 2009 at 6:10 pm
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...
June 22, 2009 at 5:55 pm
Nothing tidy. Use another character as your field delimiter, or replace/delete the commas before you export the BLOB.
June 22, 2009 at 11:32 am
Viewing 15 posts - 12,676 through 12,690 (of 13,849 total)