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?
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
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply