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 |
|
DaveKeep
Starting Member
3 Posts |
 Posted - 2007-10-03 : 09:32:54
|
| hi,on an oledb destination, I want to map one column from a flat file source object to two different columns on the database table.I only seem to be able to map one to one.How do I get the pointer to attach to two destination columns? |
|
|
igorblackbelt
Constraint Violating Yak Guru
407 Posts |
Posted - 2007-10-03 : 14:31:59
|
I haven't ran across with this yet, however, you might want to load the file to a staging table first, than again from the staging table to your destination, you'll have a lot more flexibility to load data from one table to another.Please ignore this previous post, see link below, there's a component that will do that for you.http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=90324 |
 |
|
|
|
|
|
want to map one flat file column to two db columns