Hi,

Thank u so much. I can upload now.

The problem is that "I shouldn't specify the remote file name. only "/" in remote file succeeds sending file to ftp server"

Thanks again.

Priya

Thanks again. If the firewalls are enabled, does it allow me to manually Copy & paste the same file?

I can Copy/Paste the same file to the FTP Server manually.

Can you...

The same error occurs for the FTP task also

[Connection manager "FTP Connection Manager"] Error: An error occurred in the requested FTP operation. Detailed error description: 200 Switching to Binary mode....

Nothing specific. When Replaced Script task with the FTP Task

I get the following error

[FTP Task] Error: Unable to connect to FTP server using "FTP Connection Manager".

But the FTP test...

Thanks a lot. I resolved this issue.

Just pointed the config file to the package in Agent configurations file.

Priya.

Thanks again. But the deployment folder of the package consists of the config file called databasename.dtsConfig.

Agian the common folder also has the same config file.

For Example,

If we...

Hi,

Thanks for your reply.

I have a common configuration file in C:\DBConfig\Databasename.dbConfig

I have pointed this config file for all the related packages using the same connection string.

But The Production server...

Thanks again. Is there any way by which the file names can be delimited and specified in a single variable, & that can be looped out for the list.... ?

I...

Thanks for your response. It doesn't have any specified name format. All the 3 files have diff excel names.

Priya

Sorry.... These are my values stored into SQL Server tables

Configuration Filter: MyDBSrcConn

ConfiguredValue : Data Source=ARC_NITHYA;Initial Catalog=MyDB;Provider=SQLOLEDB.1;Integrated Security=SSPI;Auto Translate=False;

Package Path : \Package.Connections[OLEDBProviderSQLServerMyDB].Properties[ConnectionString]

Configured Value Type: String

Hi,

Thanks for ur reply again...

My values are as follows

Configuration Filter: MyDBSrcConn

ConfiguredValue : Data Source=LocalServer;Initial Catalog=MyDB;Provider=SQLOLEDB.1;Integrated Security=SSPI;Auto Translate=False;

Package Path : \Package.Connections[OLEDBProviderSQLServerMyDB].Properties[ConnectionString]

Configured Value Type: String

Nithya

Hi,

Thanks for ur reply. The problem exists still. I changed a package configuration for SSIS to XML file. it worked fine for the first time. I closed and reopen in...

Hi,

Let me give a brief description of my error. The scenario in ur post explained the package error when deployed from SQL Server agent. My scenario is that

The package...

Hi,

Thank u very much for ur faster response.

Combined both 1 & 2 pack into one.

Changed the property (delayValidation = true) for Data flow task

Now executed successfully..

Thanks

nithya

Hi,

Thanks for ur reply.

Let's say "pack1.dtsx" and "pack2.dtsx" are my 2 packages.

I had setup "pack1.dtsx" as my startup package.

This gets executed successfully. it stops after executing the...