September 16, 2010 at 7:46 pm
I have a package in which a bulk import is done through a proc which is embedded inside an SSIS. Package runs fine on the database server. The file is read from an FTP server and my account has access to the ftp server. PAckage fails when ran locally. Package is looped with a VBscript, but i am still not clear why does it work on server and no on local.
ErrorNumber=4861 ErrorSeverity =16 ErrorState=1 ErrorProcedure= ErrorLine=1 ErrorMessage=Cannot bulk load because the file "\\Mycomputer\Folder_name\ABC.txt" could not be opened. Operating system error code 5(Access is denied.).". Possible failure reasons: Problems with the query, "ResultSet" property not set correctly, parameters not set correctly, or connection not established correctly.
Task failed: Exec load_MYPROC
SSIS package "Test_Package.dtsx" finished: Failure.
The program '[3740] Test_Package.dtsx: DTS' has exited with code 0 (0x0).
I can access the share through my local account on my local machine and server. Same accounts are used on both the server and local.
thanks
September 17, 2010 at 2:18 am
The user running the VB script starting the package is the same as the user having access to the ftp (same domain)?
Do you start it with dtsexec or do you somehow have the sql agent start it for you?
You could try to print out the current user in the ssis package (to make sure it's the correct one) and try to access the ftp from the vb script.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply