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 |
|
ricky252525
Starting Member
1 Post |
 Posted - 2012-09-04 : 14:51:57
|
| I'm using SSIS to import data from one DB to another existing DB. Some columns in the destination tables do not exist in the source tables. Seems the Import & Export Wizard only allows me to select unmapped columns from the source and match them with these new columns in the destination. I'd like to be able to just provide one piece of data to import into all rows of these new columns. Would like to use the GUI if possible because I'm not skilled at writing scripts. Thanks! |
|
|
yosiasz
Master Smack Fu Yak Hacker
1635 Posts |
Posted - 2012-09-04 : 16:00:10
|
| you might need to dump the source the data to a temporary holding table that does have the destination columns<><><><><><><><><><><><><><><><><>If you don't have the passion to help people, you have no passion |
 |
|
|
|
|
|
Import SQL DB: How populate non-existent columns?