Viewing 15 posts - 12,151 through 12,165 (of 13,874 total)
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
ct_man12 (4/17/2010)
April 19, 2010 at 2:53 am
There is a better way of doing this which does not require a lookup table.
Add a derived column which converts NULLs to "No_Product_Line" and leaves non-NULL data as is, something...
April 17, 2010 at 3:23 am
Maybe this link will help you.
April 17, 2010 at 3:07 am
da-zero (4/16/2010)
I divised my suggestion from the template that I always use. This template has a conditional split to sort out the insert and the updates....
April 16, 2010 at 2:28 am
da-zero (4/16/2010)
zuma01 (4/15/2010)
If a record is found I want to ignore. Records wont change once entered.Cheers
I think you can just use an OLE DB Source to read the data....
April 16, 2010 at 1:55 am
Viewing 15 posts - 12,151 through 12,165 (of 13,874 total)