Viewing 15 posts - 12,136 through 12,150 (of 13,870 total)
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
Mh-397891 (4/11/2010)
How to trouble shoot where the problem is? Any ideas. Thanks.
Check the source data in row 45. There must be something 'different' in it which is causing the error...
April 27, 2010 at 9:56 am
To have figured all of that out based on the hint is impressive, as is posting back your solution so thoroughly. Good stuff.
Now I shall go and read about the...
April 27, 2010 at 9:09 am
Maybe you could just create a VIEW and use that as your source?
April 27, 2010 at 8:39 am
This forum is for questions about SSIS - you should probably post this question here.
April 27, 2010 at 12:02 am
SSIS is not good at dynamic columns - you are going to struggle.
In principle, it would be better to marshal all your data together in the SSIS pipeline and then...
April 26, 2010 at 5:20 am
Elliott W (4/22/2010)
starterm (4/21/2010)
-- If a file is copied or moved it retains its date, therefore I don't view this as a reliable method.--
CEWII
If a file is copied, its Date...
April 26, 2010 at 1:11 am
That's strange.
Something must have changed - you just have to find out what. Source? Target? Windows update? Something else in the package?
April 24, 2010 at 3:48 am
Elliott W (4/22/2010)
That is typically how I set it up so that a dataflow is all good or nothing goes in..CEWII
I knew I could rely on you ...
April 23, 2010 at 12:59 am
Elliott W (4/21/2010)
-- and it also handles failed runs automatically.CEWII
As long as they are complete failures and not partial failures ... though I'm quite sure you've got it all handled.
April 22, 2010 at 3:31 pm
Viewing 15 posts - 12,136 through 12,150 (of 13,870 total)