Avatar of Isaiah Melendez
Isaiah Melendez

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?
Microsoft SQL ServerMicrosoft DevelopmentMicrosoft SQL Server 2008SSRSSSIS

Avatar of undefined
Last Comment
Isaiah Melendez
ASKER CERTIFIED SOLUTION
Avatar of Jim Horn
Jim Horn
Flag of United States of America image

Blurred text
THIS SOLUTION IS ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
Avatar of Isaiah Melendez
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.
Avatar of Vikas Garg
Vikas Garg
Flag of India image

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.
Avatar of Isaiah Melendez
Isaiah Melendez

ASKER

Do you have a screen shot of how you would insert from data flow task into the MDB2?
Avatar of 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!
Avatar of Isaiah Melendez

ASKER

Great answer!
Microsoft SQL Server
Microsoft SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.

171K
Questions
--
Followers
--
Top Experts
Get a personalized solution from industry experts
Ask the experts
Read over 600 more reviews

TRUSTED BY

IBM logoIntel logoMicrosoft logoUbisoft logoSAP logo
Qualcomm logoCitrix Systems logoWorkday logoErnst & Young logo
High performer badgeUsers love us badge
LinkedIn logoFacebook logoX logoInstagram logoTikTok logoYouTube logo