July 13, 2011 at 9:18 am
I have a package where the first task is an Execute Process Task that runs a .BAT file to download files from a sftp site. If I execute the package manually under Stored Packages\File System, it runs fine. However, when i add it as a Job and manually run it, it uses the SQL Agent Service Account and gets stuck at that task. In the log file there is no error, just the last line saying...
User:ExecuteProcessExecutingProcess,DALWSQL500,NA\SQLAdminAcct,Download files,{7de540c3-3d99-48ef-8622-2865386b3ac9},{F7376FF6-21C7-4A29-BF53-77EA81E50C43},7/13/2011 9:45:31 AM,7/13/2011 9:45:31 AM,0,(null),Executing the process "e:\V5PROD\ADPR_People_Import.bat".
July 13, 2011 at 9:52 am
Grant same permissions to your SQL Agent Account as the SSIS package for that .bat file.
July 13, 2011 at 10:12 am
If its a permission issue why doesnt the package error out?
btw, which type of permission?
July 13, 2011 at 10:36 am
July 13, 2011 at 4:58 pm
AlexSQLForums (7/13/2011)
Read This:http://support.microsoft.com/kb/918760http://support.microsoft.com/kb/918760
This article refers to packages that will not run at all.
is250sp (7/13/2011)
I have a package where the first task is an Execute Process Task that runs a .BAT file to download files from a sftp site. If I execute the package manually under Stored Packages\File System, it runs fine. However, when i add it as a Job and manually run it, it uses the SQL Agent Service Account and gets stuck at that task. In the log file there is no error, just the last line saying...User:ExecuteProcessExecutingProcess,DALWSQL500,NA\SQLAdminAcct,Download files,{7de540c3-3d99-48ef-8622-2865386b3ac9},{F7376FF6-21C7-4A29-BF53-77EA81E50C43},7/13/2011 9:45:31 AM,7/13/2011 9:45:31 AM,0,(null),Executing the process "e:\V5PROD\ADPR_People_Import.bat".
Chances are the login running the SSIS package is not setup to use the necessary SFTP key(s) and the batch file is being asked a question about a key that is never being answered because it's an unattended process. Try logging into the server as the user that runs the SSIS package, run the batch file manually and see if you are asked any questions.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
July 15, 2011 at 1:49 pm
Thanks opc.three! I had our dba log in with the sql account and run the batch file to accept the keys and now it works 😀
July 15, 2011 at 1:51 pm
Sweetness...happy to assist 🙂
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply