Who is Participating?

If you use the import option in enterprise manger, it creates a DTS package behind the scenes. You should be able to go to Enterprise mangaer, data transformation services, local packages, and choose your package....You should see a line between your source and target...

I would definately watch the log file growth (depending on how you're loading the data) and make sure you logs/data files are on different drives/raid groups. Also, data this size, you wanna drop all indexes (unless they need to be used for the load--primary keys, lookups, etc) and add them after the data loads.....

0

robrodpAuthor Commented: 2004-09-02

It is DTS. I dit not know there was a Bulk Insert. How do you do that.
I have a raid group. 3 drives, it starts up from drive c whichis independent.

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

"And yes the data and logs arein the same raid group. Is that terrible?"

Not a good idea--not only from performance (I bet you will see a LOT of IO waits), but from a recoverability standpoint....I suppose it's also RAID5???

If you double click on the line between your source and target in the DTS designer, you have the options tab--down at the bottom in the SQL Server options frame, there is an option for TABLE LOCK and USE FAST LOAD.....

0

robrodpAuthor Commented: 2004-09-03

Sorry I cannot find the "line between your source and target in the DTS designer".

I am using the import option in the enterprise manager. Is this correct?