Viewing 15 posts - 12,541 through 12,555 (of 13,849 total)
The Input0_ProcessInputRow sub is called for every row in the input data.
As long as the input data is in the required order, this allows the LastColA variable to be populated...
August 31, 2009 at 9:35 am
What is "@SSIS" supposed to represent in this expression?
August 31, 2009 at 7:44 am
John Rowan's first response gives you a solution to this, it would seem.
August 31, 2009 at 3:58 am
SQL Learner (8/28/2009)
Thanks a lot GSquared....From what I got is
I will have to add checksum column for each column that may change ...
Source as well as Target...
--edit
You need only a...
August 31, 2009 at 3:48 am
Do all of your flat files have the same schema?
What is in column 35? This is a tough one to answer without knowing a bit more about your data ...
August 31, 2009 at 3:33 am
OK, now that I have spent a bit more time on your solution, I can see what it's doing. Apologies for my previous post, but I haven't seen a solution...
August 30, 2009 at 12:14 am
benyos (8/29/2009)
download microsoft logparser and run it on your data.
if, for example, your data is in CSV file, you can run...
August 29, 2009 at 1:26 pm
Maybe the initial fetch is causing problems.
Can you loop/batch the whole thing to SELECT and process x thousand rows at a time?
August 29, 2009 at 8:22 am
Alvin Ramard (8/27/2009)
You'll need to provide much more information about what you're trying to do before anyone can answer your question.
Actually, this is not quite true. The answer to the...
August 27, 2009 at 11:40 am
🙂 exactly where I was going - hence my question about schemas ...
August 25, 2009 at 6:20 am
Does each of the text files have the same schema, but just differ by name?
August 25, 2009 at 3:21 am
Do you know in advance how many records will be written? If so, maybe a For loop could do it.
But 1,000 lines is nothing. How many rows (approximately) are you...
August 25, 2009 at 2:45 am
Assuming that all of the XML files are of the same format, a Foreach container is the way to go.
As an overview, you'll need to configure the Foreach container to...
August 22, 2009 at 6:31 am
Or if your flat file already contains a PK, you could multicast to all the tables and then run UPDATE queries at the end to set the FKs, using the...
August 22, 2009 at 4:59 am
Viewing 15 posts - 12,541 through 12,555 (of 13,849 total)