Viewing 15 posts - 11,596 through 11,610 (of 13,876 total)
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
Guys, I was looking for an old post of mine and came across this one, only to see that I never said thank you :blush:
So let me remedy that: thank...
February 17, 2011 at 12:28 pm
Randheer (2/17/2011)
This is the questions which other than the general indexes questions.
--
This index question does not scan.
February 17, 2011 at 11:00 am
Looks to me like your derived column expression would work for dates formatted as YYYYMMDD, whereas your dates are in MMDDYYYY format - so you just need to change the...
February 17, 2011 at 1:37 am
You have merely repeated your first question. Saying that you want something 'as output' does not mean anything to me. Are you trying to populate a lookup table with missing...
February 16, 2011 at 2:33 am
You have given your suggested input data, but the desired output is unclear to me.
Are you saying that you want table A to contain all of the values in table...
February 16, 2011 at 2:25 am
Viewing 15 posts - 11,596 through 11,610 (of 13,876 total)