January 21, 2008 at 2:45 pm
I've designed a package using 'SSIS import/export wizard'. This package just copy some tables from one server to another. First time the package executed successfully but next day it fails. I am not sure what am I doing wrong. Both server using same account as local admin. Any ideas?
Thanks in avdance.
Error:
====
SSIS package "Refresh_Tables.dtsx" starting.
Error: 0xC002F304 at NonTransactableSql, Execute SQL Task: An error occurred with the following error message: "Could not find a part of the path 'C:\Documents and Settings\admin_dba\Local Settings\Temp\2\tmp42.tmp'.".
Task failed: NonTransactableSql
SSIS package "Refresh_Tables.dtsx" finished: Failure.
The program '[4196] Refresh_Tables.dtsx: DTS' has exited with code 0 (0x0).
January 22, 2008 at 8:06 pm
Take a look at your error message. It indicates that the problem is in the filesystem, perhaps a missing or inaccessible output file.
Tim Mitchell
TimMitchell.net | @tmitch.net | Tyleris.com
ETL Best Practices
January 22, 2008 at 8:13 pm
When package executed second time, somehow the temp directory disappear.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply