Popular Posts

SQLblog.com - The SQL Server blog spot on the web

Thursday, October 12, 2017

Script Task to check file existance is OK in Visual Studio but fails when Deployed

SQLServerCentral » Latest topics
Script Task to check file existance is OK in Visual Studio but fails when Deployed
Hi,

Within a Foreach loop, I have a simple Script Task to check if a file exists. If it exists, then FTP the file. If does not exist, then add the full file path to a error log table.

The script -

No comments: