July 12, 2010 at 12:59 pm
Help needed!!
I have a problem.. I'm sending a file by using Bluezone Secure FTP. I used the following SSIS Script task to do that.. Send my login information thru config file
Public Sub Main()
Dim ExecuteResult As Integer
ExecuteResult = getConcurFiles()
'MsgBox("test", MsgBoxStyle.Critical, ExecuteResult)
End Sub
Function getConcurFiles() As Integer
Dim dnlProcess As System.Diagnostics.Process
Dim strUF_App As String = Chr(34) & "C:\Program Files (x86)\BlueZone FTP\Bzftpf.exe" & Chr(34)
Dim strUP_Args As String = "/FAssureNet.zft /Z0 /L""ls "" & /L""PUT DataExtract.txt" & Chr(34) & " /L" & Chr(34) & "Exit" & Chr(34) & Chr(34)
dnlProcess = System.Diagnostics.Process.Start(strUF_App, strUP_Args)
dnlProcess.WaitForExit()
getConcurFiles = dnlProcess.ExitCode
End Function
It is successful if I execute this script task manually. It is also successful if I execute thru file system.. But the very same job just sits when I schedule it. Nothing happens. just stays in "Executing" status with out doing anything.. If I leave the job like that..then it will time out... I know it is related to some proxy issue. but unable to find that..
Thank you and appreciate your help..
July 12, 2010 at 2:08 pm
For troubleshooting this, I would suggest logging onto the server console with the same account that the SQL Agent uses. Then execute the script in the context of that user account. You may then be able to see the condition that is causing your issue.
July 14, 2010 at 9:59 am
Thank you.. I realized it is proxy issue.. Created new account and worked without having any issue..
August 3, 2010 at 8:30 pm
Hi sree1119;
I have the same issue and I try to fix that , can you please let me know how you fixed this issue
Thank's
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply