Viewing 15 posts - 12,121 through 12,135 (of 13,849 total)
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
da-zero (4/21/2010)
Paul_Harvey (4/21/2010)
I guess this is what makes forums like this, and forum members like these invaluable to someone just starting out.Oh, you're making me blush 😀
Many people take a...
April 22, 2010 at 2:57 pm
From Wikipedia:
Staging areas are used in databases as a place to store temporary data for import. By filling this staging tables with import data you can check and alter this...
April 21, 2010 at 1:21 am
Paul_Harvey (4/20/2010)
Can I just ask....
If I set this constraint, does it potentially prevent the entire package from running, or will components AFTER the one I wish to...
April 20, 2010 at 6:54 am
Expanding on that a little ... You could use an Execute SQL task to run something like
Select Count(PK) from table where ...
and map the result directly to a variable, which...
April 20, 2010 at 6:38 am
da-zero (4/20/2010)
Phil Parkin (4/20/2010)
See here.And the award for the Shortest answer ever that was also actually helpful goes to...
😀
... and there was me thinking that I never won anything 🙂
April 20, 2010 at 2:56 am
Viewing 15 posts - 12,121 through 12,135 (of 13,849 total)