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 |
|
www051906
Starting Member
7 Posts |
 Posted - 2005-10-20 : 10:39:26
|
| Hello all. I'm new to SQL server and DTS. I have this need. I need to import several text files into a schema I've built in SQL Server 2000. Records being imported include flat fields as well as connection fields with ID's of linked records. These linked records, at the time of import, may or may not already exist in SQL. So, I need to keep a translation table (SQL uniqueidentifier mapped to the incoming records original ID) to be able to make the connection after/during import. Is DTS built for this? If so, can anyone point me in a direction to get this accomplished? For example, how would I get the uniqueidentifier of a record during import after insert and write it to a translation table? Can this be done in a transformation script? Or do you think I'm better off writing some external import app in VB?Thoughts greatly appreciated... |
|
|
Seventhnight
Master Smack Fu Yak Hacker
2878 Posts |
Posted - 2005-10-21 : 08:33:40
|
I would say that you can probably do it in DTS, but its hard to tell with out samples or similar examples of tables and files... We import many variations of file types and formats through DTS all the time... so I'm sure it can be done.Corey Co-worker on children "...when I have children, I'm going to beat them. Not because their bad, but becuase I think it would be fun ..."  |
 |
|
|
|
|
|
Is DTS right for me?