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 |
|
Tim
Starting Member
392 Posts |
 Posted - 2002-08-15 : 02:49:49
|
I want to bring data from a SQL 7 database to a SQL 2000 database. There are many records, so I don't want the inserts logged, or triggers to fire etc. Just dump it in - wham bam thank you maam.  So I am looking for a BULK INSERT type operation, but without having to create an intermediate data file like BULK INSERT and bcp require.I don't know DTS very well... is there a way to do what I want in DTS ?thx for any help.----Nancy Davolio: Best looking chick at Northwind 1992-2000 |
|
|
robvolk
Most Valuable Yak
15732 Posts |
Posted - 2002-08-15 : 08:18:15
|
| There is a fast load option on the Options tab of the DTS transform properties page. In conjunction with the batch size setting, you can control how many rows are inserted as a batch (and committed or rolled back). This doesn't prevent logging but it helps manage it better. If you build a DTS package and open the properties page, you can click the Help button and get all the info on each option. There's also one for disabling check constraints (if you have them)You can always disable the trigger on the table before you import the data, and then enable it afterwards. Look at the ALTER TABLE command in Books Online. |
 |
|
|
|
|
|
non-logged insert