No, unfortunately I never found a solution. I've tried most of the solutions that have been mentioned but none were successful.

Hi, I have a very similar set up to send files using SFTP. In the SQL Server Agent job I use operating system command as the job type and copied...

You're not alone. I'm having the same issue. My SSIS package runs fine in Visual Studio but when I schedule the package as a SQL Server Agent job it hangs...

Hey James, thanks for the suggestion it was very helpful. I discovered that the expression I was using the determine the flat file name (StrFlatFileName) was being evaluated everytime it...

Hi, I found your posts to be very helpful. Based your posts I've been successful at setting the value of my user variable with an expression that creates the file...