FTP Task – FTP Import: Error: Directory is not specified in the file connection manager $Package-variableName

Possibly save 4 hours of your time: I notice some of my SSIS jobs are no longer working and the errors are different for each of them. But one error gave clue about the package variable issue.

When I run the package directly using environment variables, it works fine. But when I use a job with proxy/credential identity, it failed. So there is another hint this is related to permission issue.

What caught me off guard was these jobs used to work.

The jobs ftp files from/to the ftp server to a network location.

The variable in this case was a network path.

Solution:

We change the environment variable to point to a local path and it works. This identifies that the issue has to do with the identity used to run the job does not have access to the network location defined by the variable.

Professional Microsoft SQL Server 2014 Integration Services (Wrox Programmer to Programmer)

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

w

Connecting to %s