asked on

SSIS adding a record during the process

Dear Experts,

I have SSIS implemented where I am taking 150 mdb’s with 17 tables per mdb and all these are importing into one SQL DB but I am wondering how I can insert a record in those 17 tables that are coming across into the 17 SQL DB tables. What process would you suggest in SSIS to do this so I won’t have confusion of data?

ASKER CERTIFIED SOLUTION

Jim Horn

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

Isaiah Melendez

ASKER

Jim -

For clarification purposes I will explain below with a simplified example:

1 MDB named Store1 In it 17 tables. One of the tables is Customers, and customers contains three columns: FName, LName, Phone.

I want to add in to the customers table (and the other 16 tables) a column named ssn and include a record in it.

Let me know if you need further clarification.

Vikas Garg

Hi,

You can add a derived column transformation during the Data Flow Task.
The value of that derived column will be expression in which you can pass a variable which will be having value of that MDB.
for example the value of variable will be MDB1 for first package and MDB2 for 2nd and so on.

This extra column will tell you the data is coming from which souce.

Isaiah Melendez

ASKER

Do you have a screen shot of how you would insert from data flow task into the MDB2?

Isaiah Melendez

ASKER

I've requested that this question be closed as follows:

Accepted answer: 0 points for sj77's comment #a41030753

for the following reason:

This was the answer!

Isaiah Melendez

ASKER

Great answer!