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...