SQL Server change temp file location

Hi there,

I’m attempting to import a table from a database for Microsoft SQL Server 2005. I’m using the Import & Export Wizard which is just fine. However the database table that I’m attempting to import is about 12 gig in size so the temporary files it creates in C:\DOCUME~1\ADMINI~1\LOCALS~1\Temp\2 are rather large, in fact larger than the amount of space that I have available on my C drive (my database is stored on the D drive where I have tons of space). Does anyone know how I change this location? I can’t seem to find it anywhere in the application.

Thanks!

i would just change the location of the temporary folder in your system settings to point to your D: drive.

^^^What he said. SQL doesn’t have a temp file location, rather it looks for the temp file location for that account. If you can login with another account and move the user profile to the D drive that should help.

If you can’t do that, you could try setting it up to run as a separate SSIS package and keep all the data on the D drive.

Another option is to install the client tools on another box and do this manipulation from there.