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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-07-25 : 01:14:50
|
| Jose DELCOUR writes "I need to import data coming from different sources ( mainly ASCII but can be Excel, Access, ORACLE, SAS,...). I intend to use DTS for that job but the only drawback is that the structure of the source data is unknown at process time ( the data share some common fields however ). The data transform task obliges me to define the table to be created, with defined fields. Is it possible to use DTS that automatically creates a table in SQL Server 2000, depending on the dynamic structure of source information ? and if yes, how should I do it ?Thanks for your answer and regards,Jose" |
|
|
|
|
|
DTS