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 |
|
Trudye
Posting Yak Master
169 Posts |
 Posted - 2008-08-08 : 08:20:43
|
| Hi Guys, I have a question about mapping files that have few if any fields in common. I have 7 tables I am extracting from a database outside of SQL Server. I am using a DTF to extract the data because it is much, much quicker than SQL Server. Once I have the data I have to map it into SQL Tables. As stated earlier they have few if any columns in common. Is there a way to import them collectively? Or do I have to do 7 imports?I know a solution doesn't sound promising but I figure it didn't hurt to ask the Experts. Thanx,Trudye |
|
|
dexter.knudson
Constraint Violating Yak Guru
260 Posts |
Posted - 2008-08-11 : 07:54:40
|
| The SSIS Import wizard is pretty quick & it creates packages you can re-use |
 |
|
|
Trudye
Posting Yak Master
169 Posts |
Posted - 2008-08-12 : 10:43:12
|
| Thanks Dexter for respondiing we decided to take the long way around. |
|
|
|
|
|
|
Mapping 7 tables collectively