Hello,

I have solved the problem.

Thanks,

Deepesh Verma

Check this out

http://www.sybase.com/detail?id=1034254

May it help you.

Deepesh Verma

Done

hi,

I have completed the task. Thanks a lot Sreejith.

we can use openquery or openrowset to do so.

Thanks

Hi,

There is nothing like columns.I want that if the file is not present on FTP then the error should be inserted in the table lets say

FTP URL , Error...

Thanks Jason,

Its the firewall causing the problem.Now it is working fine,

THanks

hi Sreejith,

I am not geeting any thing like "Dyanmic Propert Task". From where I can add that.

Hi Sreejith,

Can you please explain me this.Or give the links from where I can find the turotrials for this.As I am new to SSIS and DTS.

Thanks

Hi Sreejith,

Sounds Good I will try this.

But I would have such 20-30 ftp location and  excel files from different locations would be fetched.May be at specified time.I would create a...

Hi Kiran,

You insert a SQL Task that SELECT's the 20-30 different FTP sites.  In the General tab you specify the ResultSet as 'Full result set'.  On the Result Set...