June 28, 2009 at 8:25 pm
i have a two tables
first table
employeeid, name, city, salary
second table
employeeid, hiredate,Designation,title,hirecode
i have a third table employeeid,name,city,salary,hiredate, designation
i wont get the only the selected columns from both tables.
how do i achieve in SSIS
June 28, 2009 at 8:30 pm
What do you mean by 'selected'?
Are the tables in SQL Server?
How does this question relate to SSIS - what are you going to do with the data?
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
June 28, 2009 at 9:16 pm
i am getting the first table from a flat file using fTP of ssis
second table from webservice using webservice task
finally i need to retrieve certain columns only from both table to third table
June 28, 2009 at 9:46 pm
OK, great. You need two datasources (your two files) going into a MERGE JOIN transformation within a dataflow task.
From your MERGE JOIN, output to your SQL Server destination (third table, I presume). Are you updating or inserting to table number 3?
Phil
The absence of evidence is not evidence of absence
- Martin Rees
The absence of consumable DDL, sample data and desired results is, however, evidence of the absence of my response
- Phil Parkin
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply