Viewing 15 posts - 196 through 210 (of 497 total)
Have you tried showing your client this Forum thread?!
Regards
Lempster
April 8, 2014 at 3:03 am
Koen Verbeeck (4/4/2014)
Lempster (4/4/2014)
....but...the OP specifically stated that they didn't want to go down the scripting route. 😉Yeah, but c'mon, all the c# code is already in the article 🙂
:-D...
April 4, 2014 at 7:50 am
Phil Parkin (4/4/2014)
Lempster (4/4/2014)
April 4, 2014 at 6:19 am
Koen Verbeeck (4/4/2014)
You can also implement a hash yourself using a script component:Using hash values in SSIS to determine when to insert or update rows[/url]
Yes and that would be my...
April 4, 2014 at 6:12 am
You could also use a 3rd party custom component such as the Checksum component from Konesans to calculate and store a checksum for the five address columns you are interested...
April 4, 2014 at 3:03 am
To add something on a more positive note, I once turned up for an exam only to find that they had a problem with their servers and that the exam...
April 2, 2014 at 4:12 am
TheComedian (3/31/2014)
April 1, 2014 at 7:28 am
raj.prabhu001 (3/25/2014)
Yes all the 3 files are identical means they have same columns and same data type.
Good, that makes things a lot easier! Basically you are going to need a...
March 26, 2014 at 2:48 am
What research have you done so far?
Unless your source Excel files are structured identically, you are going to find it difficult to import the contents of those files into a...
March 24, 2014 at 11:06 am
PragmaticWorks have a SCD component that is a big improvement on the out-of-the-box SCD transformation...but of course you'll have to pay for it!
You could also use a T-SQL MERGE statement.
Regards
Lempster
March 21, 2014 at 4:54 am
How do you know when a CrewID value has been 'used'?
Regards
Lempster
March 21, 2014 at 4:05 am
I trust you don't want those DBCC commands to be executed on a Production instance?!
March 21, 2014 at 3:39 am
messages4kanthi (3/20/2014)
Did you set the DelayValidation property of the Excel connection manager to true?
Yes, I clearly stated that in my original post. This is an old thread and I can't...
March 21, 2014 at 2:34 am
I already posted the link to the article about Max Server Memory........
March 11, 2014 at 5:12 am
Viewing 15 posts - 196 through 210 (of 497 total)