Hi,

I am also looking for the Answer for above question, Can anyone please help, how to capture it

Vj

Thanks for your response .

Found very simple solution.

Used for each loop container with ADO Enumerator

Used 3 variables for variable mappings in For each loop conainer, inside used script component...

This one is very simple and Helpful .....

http://www.sqlservercentral.com/articles/Integration+Services+(SSIS)/64014/

right now got 8 packages... in future it might increase up to 15.....

Thanks Elliott. I have contacted Admin team to fix issue.

Elliott,

As you said, \\S-SQL15\IPM Source Data\Source is my relative path as well as my Destination folder.so i can take / in destination variable.

Bu as per you last post, FTp...

Hi,

My destination path : D:\IPM Source Data\DataAcademySource

i tried with forward slash (/) infront of my target path, but it is not working. even if i go for FTp task by...

HI,

i am using Sql server 2005, tried with FTP task,getting one error: Destination folder does not start with "/"

I found that FTP task not working properly in SQL server 2005....

Hello,

exactly i used same above code to send a file to FTP server.But my script task remains in execution mode all the time ( Yellow ).

can any please suggest...

Thanks Stewart.

I implemented through Package as you told. Thanks for your Reply.

VIjay