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 |
|
batcater98
Starting Member
22 Posts |
 Posted - 2009-07-06 : 10:17:15
|
| I have two tables one coming from SQL and the other from Teradata. I am wanting to use the SQL table as the source/update table - do a lookup somehow into the Teradata table if I find a match based on a key field in both tables I want to pull back some information from the Teradata table and update the SQL table on the fly.I have stuggled with this for some time - can someone give me some ideas/steps to do something like this in SSIS? I am using Visual Studio 2008 against SQL 2008 & Teradata.Thanks,Ad.Regards,The Dark Knight-Give What is Right, Not What is Left- |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2009-07-15 : 14:08:31
|
| you need a data flow task in ssis with oledb source to connect sql table, then use teradata connector to comnnect to teradata table,lookup task to perform lookup and finally a oledb command to do the update of sql table |
 |
|
|
|
|
|
SSIS Update Table in Data Flow Task