Error Importing Access Database

Hello,
I'm trying to import a 420MB access database into sql server 2005.
To do this, I create a new blank database and right-click and go to
Import Data. I choose the necessary options and start the process.
Ultimately the process fails. When I click on the details for the error
message, this is what I get in a popup window. Does ANYBODY know whats
going on? thanks :
- Executing (Error)
Messages
Error 0x80070050: Data Flow Task: The file exists.
(SQL Server Import and Export Wizard)
Error 0xc0048019: Data Flow Task: The buffer manager could not get a
temporary file name. The call to GetTempFileName failed.
(SQL Server Import and Export Wizard)
Error 0xc0048013: Data Flow Task: The buffer manager could not create a
temporary file on the path "C:\DOCUME~1\DEVELOPER~1.PST\LOCALS~1\Temp".
The path will not be considered for temporary storage again.
(SQL Server Import and Export Wizard)
Error 0x80070050: Data Flow Task: The file exists.
(SQL Server Import and Export Wizard)
Error 0xc0048019: Data Flow Task: The buffer manager could not get a
temporary file name. The call to GetTempFileName failed.
(SQL Server Import and Export Wizard)
Error 0xc0048013: Data Flow Task: The buffer manager could not create a
temporary file on the path "C:\DOCUME~1\DEVELOPER~1.PST\LOCALS~1\Temp".
The path will not be considered for temporary storage again.
(SQL Server Import and Export Wizard)
Error 0xc0047070: Data Flow Task: The buffer manager cannot create a
file to spool a long object on the directories named in the
BLOBTempStoragePath property. Either an incorrect file name was
provided, or there are no permissions.
(SQL Server Import and Export Wizard)
Error 0x80004005: Data Flow Task: Unspecified error
(SQL Server Import and Export Wizard)
Error 0xc0208266: Data Flow Task: Long data was retrieved for a column
but cannot be added to the Data Flow task buffer.
(SQL Server Import and Export Wizard)
Error 0xc0208265: Data Flow Task: Failed to retrieve long data for
column "subject_description".
(SQL Server Import and Export Wizard)
Error 0xc020901c: Data Flow Task: There was an error with output "OLE
DB Source Output" (11) on component "Source - tmpRC20042005Part1" (1).
The column status returned was: "DBSTATUS_UNAVAILABLE".
(SQL Server Import and Export Wizard)
Error 0xc0209029: Data Flow Task: The "output "OLE DB Source Output"
(11)" failed because error code 0xC0209071 occurred, and the error row
disposition on "component "Source - tmpRC20042005Part1" (1)" specifies
failure on error. An error occurred on the specified object of the
specified component.
(SQL Server Import and Export Wizard)
Error 0xc0047038: Data Flow Task: The PrimeOutput method on component
"Source - tmpRC20042005Part1" (1) returned error code 0xC0209029. The
component returned a failure code when the pipeline engine called
PrimeOutput(). The meaning of the failure code is defined by the
component, but the error is fatal and the pipeline stopped executing.
(SQL Server Import and Export Wizard)
Error 0xc0047021: Data Flow Task: Thread "SourceThread0" has exited
with error code 0xC0047038.
(SQL Server Import and Export Wizard)
Error 0xc0047039: Data Flow Task: Thread "WorkThread0" received a
shutdown signal and is terminating. The user requested a shutdown, or
an error in another thread is causing the pipeline to shutdown.
(SQL Server Import and Export Wizard)
Error 0xc0047021: Data Flow Task: Thread "WorkThread0" has exited with
error code 0xC0047039.
(SQL Server Import and Export Wizard)
Please advise, thanks!Try checking your temp folder -
C:\Documents and Settings\WindowsLoginName\Local
Settings\Temp
If you have a ton of files in there, delete them - or move
them if you need to keep them for whatever reason. Make sure
you have enough space for the temp files the process will
create.
-Sue
On 17 May 2006 08:54:54 -0700, soniic2003@.hotmail.com wrote:

>Hello,
>I'm trying to import a 420MB access database into sql server 2005.
>
>To do this, I create a new blank database and right-click and go to
>Import Data. I choose the necessary options and start the process.
>
>Ultimately the process fails. When I click on the details for the error
>message, this is what I get in a popup window. Does ANYBODY know whats
>going on? thanks :
>
>- Executing (Error)
>Messages
>Error 0x80070050: Data Flow Task: The file exists.
> (SQL Server Import and Export Wizard)
>
>Error 0xc0048019: Data Flow Task: The buffer manager could not get a
>temporary file name. The call to GetTempFileName failed.
> (SQL Server Import and Export Wizard)
>
>Error 0xc0048013: Data Flow Task: The buffer manager could not create a
>temporary file on the path "C:\DOCUME~1\DEVELOPER~1.PST\LOCALS~1\Temp".
>The path will not be considered for temporary storage again.
> (SQL Server Import and Export Wizard)
>
>Error 0x80070050: Data Flow Task: The file exists.
> (SQL Server Import and Export Wizard)
>
>Error 0xc0048019: Data Flow Task: The buffer manager could not get a
>temporary file name. The call to GetTempFileName failed.
> (SQL Server Import and Export Wizard)
>
>Error 0xc0048013: Data Flow Task: The buffer manager could not create a
>temporary file on the path "C:\DOCUME~1\DEVELOPER~1.PST\LOCALS~1\Temp".
>The path will not be considered for temporary storage again.
> (SQL Server Import and Export Wizard)
>
>Error 0xc0047070: Data Flow Task: The buffer manager cannot create a
>file to spool a long object on the directories named in the
>BLOBTempStoragePath property. Either an incorrect file name was
>provided, or there are no permissions.
> (SQL Server Import and Export Wizard)
>
>Error 0x80004005: Data Flow Task: Unspecified error
> (SQL Server Import and Export Wizard)
>
>Error 0xc0208266: Data Flow Task: Long data was retrieved for a column
>but cannot be added to the Data Flow task buffer.
> (SQL Server Import and Export Wizard)
>
>Error 0xc0208265: Data Flow Task: Failed to retrieve long data for
>column "subject_description".
> (SQL Server Import and Export Wizard)
>
>Error 0xc020901c: Data Flow Task: There was an error with output "OLE
>DB Source Output" (11) on component "Source - tmpRC20042005Part1" (1).
>The column status returned was: "DBSTATUS_UNAVAILABLE".
> (SQL Server Import and Export Wizard)
>
>Error 0xc0209029: Data Flow Task: The "output "OLE DB Source Output"
>(11)" failed because error code 0xC0209071 occurred, and the error row
>disposition on "component "Source - tmpRC20042005Part1" (1)" specifies
>failure on error. An error occurred on the specified object of the
>specified component.
> (SQL Server Import and Export Wizard)
>
>Error 0xc0047038: Data Flow Task: The PrimeOutput method on component
>"Source - tmpRC20042005Part1" (1) returned error code 0xC0209029. The
>component returned a failure code when the pipeline engine called
>PrimeOutput(). The meaning of the failure code is defined by the
>component, but the error is fatal and the pipeline stopped executing.
> (SQL Server Import and Export Wizard)
>
>Error 0xc0047021: Data Flow Task: Thread "SourceThread0" has exited
>with error code 0xC0047038.
> (SQL Server Import and Export Wizard)
>
>Error 0xc0047039: Data Flow Task: Thread "WorkThread0" received a
>shutdown signal and is terminating. The user requested a shutdown, or
>an error in another thread is causing the pipeline to shutdown.
> (SQL Server Import and Export Wizard)
>
>Error 0xc0047021: Data Flow Task: Thread "WorkThread0" has exited with
>error code 0xC0047039.
> (SQL Server Import and Export Wizard)
>
>Please advise, thanks!