Viewing 15 posts - 12,106 through 12,120 (of 13,849 total)
Or derive a string in the universal format YYYY-MM-DD hh:mm:ss and just pump that straight into your SQL date field.
April 29, 2010 at 9:34 am
When you double-click on a dataflow transformation, a new window opens. In this window, you will see boxes representing your source and target.
Drag a Derived Column transformation on to this...
April 29, 2010 at 9:21 am
🙂 no problem. Put this between your source and destination, as part of the dataflow.
April 29, 2010 at 8:53 am
Here's your Derived Column formula:
SUBSTRING([Column 1],7,4) + "-" + SUBSTRING([Column 1],1,2) + "-" + SUBSTRING([Column 1],4,2) + SUBSTRING([Column 1],11,13)
This will create a new column with data type Unicode String. You...
April 29, 2010 at 8:40 am
Yes there is. You can fire the date into a derived column transformation where you can add a new column which 'derives' a proper date from your date text.
What format...
April 29, 2010 at 12:51 am
What is the source of your data?
April 29, 2010 at 12:46 am
We need to understand a bit more about the logical flow of your package, I think.
You can easily check out your Script Main suspicion - just try changing it to...
April 29, 2010 at 12:43 am
There was a suggestion earlier in the thread that you just run the job frequently - every 5 minutes maybe - and process a file if it exists, otherwise exit....
April 29, 2010 at 12:33 am
Welsh Corgi (4/28/2010)
I did not believe that what I wanted to do could be accomplished.
Thank very much for you replies.
But did you have so say the period comment?
"This means that...
April 28, 2010 at 3:30 pm
rajiv.varma (4/28/2010)
April 28, 2010 at 9:57 am
Elliott W (4/28/2010)
".. smart enough to run its guts ..."CEWII
Wow, I just learnt a new technical term 😛
April 28, 2010 at 9:48 am
Use a query as your source and do the CASTs in the query?
April 28, 2010 at 6:58 am
No need to apologise and the question was not stupid.
Feel free to post more questions as you work through.
April 28, 2010 at 2:24 am
You may be able to use a MULTICAST to achieve this.
April 28, 2010 at 1:50 am
Mh-397891 (4/27/2010)
There is no difference in the data. I am very frustrated with this error.
Understandably. Does it always process exactly 44 rows? If so, can you try reading in the...
April 27, 2010 at 11:46 am
Viewing 15 posts - 12,106 through 12,120 (of 13,849 total)