Share via

SSIS Script task - FTP password not allowed

Pan Jim 1 Reputation point
2022-08-15T15:59:51.78+00:00

I have a SQL agent jobs that got error on FTP Password not allowed. This job has 13 steps and they are all have the same script for FTP. DTSX package does not have any FTP connection defined. It is all dynamically build using the C# Scripts. I am not sure why certain DTSX package failed, 10 dtsx ran good. I am out of idea what to check. Please help,

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
13,363 questions
C#
C#
An object-oriented and type-safe programming language that has its roots in the C family of languages and includes support for component-oriented programming.
10,649 questions

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Tom Phillips 17,721 Reputation points
    2022-08-15T16:36:12.433+00:00

    That doesn't sound like an SSIS error, but an error in your script or possibly from one of your FTP servers. You would have to debug your script to see why you are getting that message.

    0 comments