Check the SSIS FTP Connection String

Hi,

i have a table like

No

FileLocation

UserName

Password

1

ftp://sarvi3/test/

xyz

xyz

2

ftp://pandit3/test/test1

abc

abc

3

ftp://katta1/test/test2

klm

klm

i want to check the filelocation is valid (exist) or not before transfering the file from the location. can anyone help me out to resolve

thanks

Sun

Would any checking not be part of the actual transfer code? perhaps some sort of error trapping?

I've always found FTP to be a pain... although I'm willing to accept that could well be down to me rather than any shortcomings in FTP :)

Is this really a TSQL related question? I'd have thought you'd get more joy from one of the scripting forums.