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,993 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.
11,010 questions
{count} votes

1 answer

Sort by: Most helpful
  1. Tom Phillips 17,741 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 No comments

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.