I now have it working. The resolution.
Flat File Destination > Flat File Connection Manager >
ConnectionString = C:\pathFormat = Ragged right
Expressions = System Variables 'MyVariableName' (for path location)
To run as a scheduled job.
1) I imported the package into SSISDB. I then selected 'Configure'.
2) On 'Connection Managers' I selected my FTP Connection Manager then manually entered the server password
3) I configured a job.
Within SSISDB I also configured an Environment (under Environments) > variables. I configured this to be my FTP Connection. I thought I might be bale to reference it instead of performing step 2 above but could not see away.
Thanks,
Phil.
-------------------------------------------------------------------------------------
A neutron walks into a bar. "I'd like a beer" he says. The bartender promptly serves up a beer. "How much will that be?" asks the neutron. "For you?" replies the bartender, "no charge."
Two hydrogen atoms walk into a bar. One says, 'I think I've lost an electron.' The other says 'Are you sure?' The first says, 'Yes, I'm positive... '
Tommy Cooper