I have a package that extracts data and sends those files to a remote server with the FTP task. The FTP task isn't working. When I created the ftp task manager and test the connection, it connects successfully. when I run the ftp task it fails and I get this message:
SSIS package "GasMeterLease.dtsx" starting. Error: 0xC002918B at FTP Task, FTP Task: Unable to send files using "FTP Connection Manager". Warning: 0x80020918 at FTP Task, FTP Task: Operation "" failed. SSIS package "GasMeterLease.dtsx" finished: Success.
I've been struggling with this for days.
Doesn anyone know what the problem is and how I can fix it?