Viewing 15 posts - 12,661 through 12,675 (of 13,838 total)
Log in to the server using Terminal Services and run it there ...
June 25, 2009 at 8:35 pm
In the editor for the flat file connection, what are the datatypes for the input columns?
June 25, 2009 at 6:30 pm
Your original post did not suggest any reason why you would need to use a conditional split - can you describe why you are doing this?
You talk about 'dragging' from...
June 25, 2009 at 6:26 pm
Here is one way.
1) Create a package variable - UserID
2) Modify your ExecuteSQL task so that the result of the query is mapped to UserID.
3) Add a Derived Column transformation...
June 25, 2009 at 5:51 am
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
Viewing 15 posts - 12,661 through 12,675 (of 13,838 total)