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 |
|
pravin14u
Posting Yak Master
246 Posts |
 Posted - 2004-07-01 : 00:59:01
|
| How to implement the incremental update (using the package wizard) from a text file into the sql server database.Normally it lawys copies the whole data into the database.thank you |
|
|
timmy
Master Smack Fu Yak Hacker
1242 Posts |
Posted - 2004-07-01 : 01:33:37
|
| By incremental update do you mean allowing the package to UPDATE records instead of INSERTing them?Can you give an example of what you're trying to do?Tim |
 |
|
|
pravin14u
Posting Yak Master
246 Posts |
Posted - 2004-07-02 : 02:03:19
|
| I am sorry i am trying to do a incremental insert that is i have to automate the inserton of records incrementallythank you |
|
|
|
derrickleggett
Pointy Haired Yak DBA
4184 Posts |
Posted - 2004-07-02 : 18:56:58
|
| Can you give us the INSERT statement you have now and a couple rows of sample data. There are several ways to do this. You could use an identity field and increment the where. You could use a LEFT OUTER JOIN with TOP until @@ROWCOUNT = 0. You could use SET ROWCOUNT. blah,blah,blahMeanOldDBAderrickleggett@hotmail.comWhen life gives you a lemon, fire the DBA. |
|
|
|
|
|
|
Incremental update