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-10-03 : 10:03:19
|
| harraz writes "Hello friends,How can I import a data set into SQL Server 2000, while maintaining referential integrity, key and data constraints. For example if I have a data set in this format: (StationID, TimeID, Value) which is a replica of the destination table format. The first two ID columns are foreign keys from other tables (tblStations and tblTime respectively) in the same database, of course there is a Primary Key column but it is set as [ID] to automatically generate a new value.What I want to do is allow the client to import big data sets into there database using DTS, in fact I'm still investigating if DTS is suitableor writing a small import tool is the only way to do that.If DTS can do this, the question is, if the user wants to import adata-set, how will he/she use the DTS to import data with new stations(i.e. StationIDs) or new time (i.e. TimeIDs) as well as importing data for existing stations and times.let me know if I'm not clear.thanks for your help and/od adviseharraz" |
|
|
|
|
|
DTS Question