File Protocol: SFTP
Host Name: ftp.test.com
Port Number: 22
Username: Test1
Password: XXXX

let
Source = Csv.Document(File.Contents("C:UsersDocumentsWinscpacct_dept.dat"),[Delimiter="|", Columns=7, Encoding=1252, QuoteStyle=QuoteStyle.None]),
#"Changed Type" = Table.TransformColumnTypes(Source,{{"Column1", type text}, {"Column2", type text}})
in
    #"Changed Type"