sql server job fails to run the package -FTP

Question

sql server job fails to run the package -FTP

jprabha.d

Ten Centuries

Points: 1086
More actions
September 26, 2010 at 10:08 am

#227077

Hi All,
I am using the FTP task to copy the xls file from my local machine to the another system(server) of different domain.
i have setup the package ,when this package run through BIDS it works out to be Fine.
But ,if i try to run through the sql server agent job,the package fails.
is it permission issue?
Thanks & Regards
JP

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Possibly, but it would help if you would post the error message you are receiving. I am guessing that when runnng as a job it is running on the server, but when in BIDS it is on your desktop system?

jprabha.d Ten Centuries Points: 1086 More actions · Answer 2

the Below is the Error that i get

Description: The file name "\\tsclient\D\Data\2160_data.xls" specified in the connection was not valid. End Error Error: 2010-09-27 14:24:09.29 Code: 0xC001401D Source: FileTransfer Description: Connection "2160_data.xls" failed validation. End Error DTExec: The package execution returned DTSER_FAILURE (1). Started: 14:24:08 Finished: 14:24:09 Elapsed: 0.422 seconds. The package execution failed. The step failed.

Let me know what is causing ,

My Source loaction path is \\tsclient\D\Data\2160_data.xls --and the error is pointing out at this location

i am not sure ,how to specify,Even if i take up the IP Address,it doesnt detect the .xls File.

thanks

JP

Ganesh Lohani Hall of Fame Points: 3091 More actions · Answer 3

Hello,

I have also been using many SSIS packages related to FTP Server.

I faced similar issues in the past.

In my understanding,

1. Give the permission to the excel file/folder as a shared file

2. Encrypt the package with password and schedule the package to run.

You should be good.

Thanks