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 |
|
bfreeman
Starting Member
1 Post |
 Posted - 2007-04-30 : 15:18:37
|
| Hello,I am trying to create a DTS package that will load the changes from a text file while leaving some fields in my DB table intact. I have a general idea of how the SQL will look, but what is the best structure for executing the SQL. I am brand new to DTS and I am having trouble figuring out where to put the SQL and how to connect the tasks and objects.Any help would be appreciated.Thanks! |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-04-30 : 16:26:39
|
| You can load data into staging table then use your sql to move whatever you need to target table. |
 |
|
|
|
|
|
Delta update from text file