Using SQL 2008 & a dtsconfig file, and FTP information in it. The dtsconfig file has the FTP server name, the username & the password in it. I cannot get this to run to save my life. The error message I am getting is: "Connection manager "FTPServer" Description: An error occurred in the requested FTP operation. Detailed error description: The password was not allowed . End Error Error: 2011-01-21 11:17:24.39 Code: 0xC002918F" There's a password in the config file, so I'd have to assume that it is just not reading it (maybe sending a blank password or something). The job was coded using one ID, and then edited using another ID, albeit with the same exact permissions. The above comes from when I am running it under SQL Agent. It's under a service account, which I think has permissions all over the box it's on. If I run this package from BIDS, everything runs fine & the file gets FTP'd. Any ideas?

This is because it reads the design-time values for the FTP setting. To fix you may manually edit the command line that starts the SSIS package to include the /Conf setting pointing to where to take the values from. Please read how the configuration is applied http://dougbert.com/blogs/dougbert/archive/2009/04/07/understand-how-ssis-package-configurations-are-applied.aspx and how to use it http://msdn.microsoft.com/en-us/library/ms162810.aspx Arthur My Blog

I read thru those articles, and I've added it to the job in SQL Agent, but get the same message: "Description: An error occurred in the requested FTP operation. Detailed error description: The password was not allowed " The full message is: "Message Executed as user: MyDomain\myadmin. Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:27:36 AM Error: 2011-01-28 10:27:51.50 Code: 0xC001602A Source: MyJobFTP Connection manager "FTPServer" Description: An error occurred in the requested FTP operation. Detailed error description: The password was not allowed . End Error Error: 2011-01-28 10:27:51.50 Code: 0xC002918F Source: MyJobFTP FTP Task Description: Unable to connect to FTP server using "FTPServer". End Error DTExec: The package execution returned DTSER_SUCCESS (0). Started: 10:27:36 AM Finished: 10:27:51 AM Elapsed: 15.422 seconds. The package executed successfully. The step succeeded." I've looked in the XML file, the FTP name, username & password are all in there. In the job step, I am running it as Type: SQL Server Integration Services Package Run As: SQL Server Agent Service Account (FYI, I know this is a different user account than the one under which it will run from BIDS). Package Source: SSIS Package Store Server: Local Application Server (The DB server is a different one) Using Windows Authentication Package: \File System\MyJobFTP The Configurations tab has 1 row in it: D:\ABC\Data\Folders\FG\IT_Jobs\MyJobFTP\MyJobFTP\MyJobFTP\MyJobFTPConfig.dtsConfig It's set to use 32 bit runtime. The Command Line tab has: /DTS "\File System\MyJobFTP" /SERVER (Local App Server Name) /CONFIGFILE "D:\ABC\Data\Folders\FG\IT_Jobs\MyJobFTP\MyJobFTP\MyJobFTP\MyJobFTPConfig.dtsConfig" /X86 /CHECKPOINTING OFF /REPORTING E The owner of the job is the username of the account the package was edited under, and the one under which the package will run fine if run from BIDS. In BIDS, if I go to the FTP Connection Manager Editor, the FTP name is listed, port, the Username is shown (it's the same thing as in the .dtsConfig file), password is blank, Time out = 60, passive mode, 5 retries, chunk size 1KB. If I click on Test Connection, it will fail, but if I paste in the password shown in the .dtsConfig file, the test succeeds. SQL Agent was started using the username MyDomain\myadmin. The package is being edited under another account MyDomain\SSISUser that's on the same domain & supposedly has the same rights on this app server & the database server. I'm pretty much lost as to why it'll run in BIDS just fine, but absolutely will not run as a scheduled job in Agent. Any ideas?

did you deployed package correctly? I think problem is in Protection Level, I suggest you to deploy your package as this picture tutorial link shows: http://www.protalk.in/sql-server/steps-to-create-and-deploy-ssis-package-as-a-sqlagent-job/http://www.rad.pasfu.com

The current protection level is DontSaveSensitive. I changed it to match the EncryptSensitiveWithPassword & created the job & then edited the job in Agent. It ran, but I got another error message. The file was not sent. Message Executed as user: MyDomain\myadmin. Microsoft (R) SQL Server Execute Package Utility Version 10.0.2531.0 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 2:08:16 PM Error: 2011-01-28 14:08:31.38 Code: 0xC002917C Source: FTP To ABC FTP Task Description: The variable "User::varRemotePath" doesn't contain file path(s). End Error DTExec: The package execution returned DTSER_SUCCESS (0). Started: 2:08:16 PM Finished: 2:08:31 PM Elapsed: 15.5 seconds. The package executed successfully. The step succeeded. The user variable it names above DOES have something in it. It has: "D:\Myfolder\Myfiles\MyFTP\abc123.txt" Any ideas?

where this variable value comes from? is it default value?http://www.rad.pasfu.com

That variable is one of about 10 that I created for this package. Among them are an integer, that I use in the job as a count, several string variables that I use to pass in different values for email address, a MailSubject that gets set to a number of different values, and one called varRemotePath - it points to the remote path (and filename of the file I am trying to FTP).

that wasn't the information I meant exactly. I mean that where you filled value in this variable? is it default value ? or you fetch it from a loop structure or config file or somewhere else? another though is that , does the use who runs sql server agent service has permission to the path provided in this variable?http://www.rad.pasfu.com

The value in it is the default value. I don't set the variable programatically in the process. The user who runs Agent should have sufficient permissions. I used that username & password when I originally did the SSIS package, and have changed to another username & password to continue development of it. Since I had used that old (Agent) username to develop it, it should be able to see anywhere the new one does.

When you run this in BIDS, are you on your desktop? Is the D:\ stuff also on the server? Randy in Marin