• 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