I have made some progress (rightly or wrongly).
Steps:
1) I created Integration Services Catalog
2) I imported my package
3) I configured my package (Connection Managers > FTP Connection Manager > Added server password
4) Created a job then ran the package.
This worked (rightly or wrongly).
I could not work out how to use a variable to pass FTP credentials.
I now have another issue in that the format output is incorrect.....
My SSIS Flat File Connection Manager is configured as follows:
Format = Fixed Width
Header Row Delimiter = {LF}
Header Rows to Skip = 0
I have attached the output format + added the required format.
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