Viewing 15 posts - 11,596 through 11,610 (of 13,879 total)
rashmiptl22 (2/24/2011)
Hi--
Don't u think the package should be scheduled to run every 5 or 10 minutes to meet the requirement.
No.
The requirement: ".. very next minute..."
Your solution misses that by up...
February 24, 2011 at 4:25 am
The File Watcher Task may be of interest.
February 24, 2011 at 2:41 am
Where is this 'equivalent table'?
February 23, 2011 at 5:36 am
It certainly looks like a data issue - are you sure that you have tested the package successfully in BIDS with the same data?
February 23, 2011 at 3:16 am
No doubt there is some underlying operation on the table which causes the condition to be true (insert, update etc). Have you thought about creating one or more triggers on...
February 23, 2011 at 12:11 am
Have a look in sysssispackages.
February 22, 2011 at 10:02 am
Add a Conditional Split after the MERGE JOIN to break your pipeline into two outputs: updates (Output1) and inserts (Output2).
Send Output1 to the OLEDB Command - as currently.
Output2 can map...
February 22, 2011 at 6:12 am
There's always a reason, though with that amount of information it's not easy to say more.
That sounds like a very slow way to insert records - can you describe the...
February 22, 2011 at 12:37 am
That's a good article, thanks! It's always good to have read about this stuff - one day, an ideal scenario will present itself and I'll be able to suggest a...
February 22, 2011 at 12:29 am
Koen Verbeeck (2/21/2011)
Phil Parkin (2/21/2011)
Not sure about that trigger idea - nice thought, but won't it just end up doing the same RBAR updates, albeit on the server?
If you implement...
February 21, 2011 at 1:54 pm
anjanwahwar (2/21/2011)
February 21, 2011 at 1:40 pm
Koen Verbeeck (2/21/2011)
To find the real issue here, you'll have the post the error messages, as they are currently missing.
So you're not happy with the "just set the maximum error...
February 21, 2011 at 7:50 am
Not sure about that trigger idea - nice thought, but won't it just end up doing the same RBAR updates, albeit on the server?
February 21, 2011 at 7:48 am
Send all of the rows you will be updating to a staging area (as INSERTs), then perform a single T-SQL update at the end.
February 21, 2011 at 6:28 am
You could try playing around with custom date formats where you specify the format in code, eg
Now.Date.ToString("yyyyMMdd")
February 21, 2011 at 4:16 am
Viewing 15 posts - 11,596 through 11,610 (of 13,879 total)