TEMPDB

[sujosh]

I have a DTS task that creates tables/loads data from Oracle to SQLServer/create indexes/foreign keys and triggers as individual tasks.

When the ORacle to SQLServer import task happens I can see my tempdb getting full very quick. In ~ 45 mins it grew to 1 GB. The options that I have set on the Trasnform data tasks are

Options set are Use fast load, always commit final batch, table lock and insert batch size = 100000

Is there anyway I can avoid the tempdb from growing?

Thanks

 

[sujosh]

Will there be any performance problems due to tempdb growth? And how can I minimize its growth on big data loads?

Thanks