December 26, 2016 at 3:04 am
Hi,
Need a help on one SSIS package.
Wanted to move master and child two tables data from source to destination by coping the new Identity column value from master destination table to child destination table in single package, without using update command since the current package is having UPdate command and taking much time to execute the package.
January 2, 2017 at 1:01 pm
farooq.hbs (12/26/2016)
Hi,Need a help on one SSIS package.
Wanted to move master and child two tables data from source to destination by coping the new Identity column value from master destination table to child destination table in single package, without using update command since the current package is having UPdate command and taking much time to execute the package.
Without any detail on the tables involved and any indexes that exist on each, or the number of records involved, we don't have much to go on. If data volume is the cause, you may be able to do the work in small batches, but again, without any details, there's no way to do anything but make wild guesses.
Steve (aka sgmunson) 🙂 🙂 🙂
Rent Servers for Income (picks and shovels strategy)
January 3, 2017 at 7:22 am
Sounds like a package with two data flows. In your first data flow, load the master table. In the second data flow, load the child data, but look up the new key in the master table using the natural/business key in the child table.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply