Viewing 15 posts - 12,706 through 12,720 (of 13,874 total)
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
Great! For added transportability, I would suggest that you consider using a UNC path rather than a network drive path ...
Phil
June 22, 2009 at 12:10 am
OK, I'm running out of ideas, I'm afraid. If you edit the connection and save it again (after verifying the destination), does the error go away?
June 21, 2009 at 3:23 am
If you hover your mouse over the red cross on the Excel destination, it should give you a tool-tip popup describing what the problem is - what does that say?
June 20, 2009 at 11:57 pm
Apologies if this is an obvious question, but is there a chance that you had the file open in Excel when you ran the package?
June 20, 2009 at 11:34 pm
eseosaoregie (6/20/2009)
Thank you very much. That worked really well. With this knowledge I can expand my package.
Wow, really????? :w00t: You should start spamming all men in the world.:hehe:
June 20, 2009 at 8:35 pm
Viewing 15 posts - 12,706 through 12,720 (of 13,874 total)