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.

 All Forums
 SQL Server 2000 Forums
 Import/Export (DTS) and Replication (2000)
 DTS insert key

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-10-25 : 10:57:38
Tiago writes "1 - I have a sometable.CSV file with some records with a PK. the records that exist in table SQLSomeTable should be updated and the ones that dont should be inserted. The only way i can do this is using a temp table or can I do a query with the CSV table? It would be nice to join outside tables with linked tables in DTS but I don't find a way to do this.

2 - It would be nice to feature an article explaining how to turn a view into an automatic updating table using triggers. Performance wise it's a great solution.

Thanks in advance
Tiago"
   

- Advertisement -