Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
spinningtop
Starting Member
29 Posts |
 Posted - 2012-04-13 : 07:24:53
|
| Hi I import a number of text files to one sql server table with the filename added to a derived column. I would then like to add a column from a different sql server table by joining on my derived column from the first table and the column in the other sql server table. Do you know if and how this is possible in SSIS?Thanks |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-13 : 12:27:29
|
| you can use merge join if you want to do it in dataflow task itselfIf you want a set based technique you can do this in control flow after data flow task by using execute sql task------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
spinningtop
Starting Member
29 Posts |
Posted - 2012-04-16 : 05:25:48
|
| thanks for the options. I will look into these. regards |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-04-16 : 11:42:26
|
| welcomelemme knw if you need more help------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
import text file with derived column from sql tabl