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-02 : 08:28:10
|
| hi - I am totally new to SSIS etc and SQL 2005.I have a dts task to recreate in SSIS. I have done most of them and muddled my way through, but this basic problem has got me stuck.When mapping columns from my file to my ole db output table, I want to map one input column onto two output columns, but it will only seem to let me select one destination column for each input?I have tried shift/alt/ctrl etc to try to get it to map to both columns but it wont have it.How do I do it?Also, somehow my Dataflow Sources tab has gone from the toolbox, and I can't seem to get it back any way - I switched on everything I could see and all components etc, but it is not in there as an option. How do I get it back in the toolbox? |
|
|
mwjdavidson
Aged Yak Warrior
735 Posts |
Posted - 2007-10-05 : 12:20:26
|
| The mappings are one-to-one. You need to create a copy of the column using a copy column transformation in between your source and destination adapters. Give the new column a suitable alias so it's clear.Mark |
 |
|
|
|
|
|
SSIS Flat file to DB column mappings