Hello there.
I have a ssis package in sql server 2012 that downloads a few txt files into a local folder
To download the file i use a script tool which is in VB
When i run manually it works fine, but when i run via agent fails with the error.
Exception has been thrown by the target of an invocation.
The package was developed on a networked pc then deployed to the sql server. I then run via an agent job but it fails.
please see a copy of my code below.
#Region "Help: Introduction to the script task"
'The Script Task allows you to perform virtually any operation that can be accomplished in
'a .Net application within the context of an Integration Services control flow.
'Expand the other regions which have "Help" prefixes for examples of specific ways to use
'Integration Services features within this script task.
#End Region
#Region & ...
Go to the complete details ...