SSIS FTP Task

Hi,

I am Executing a .Net component in the Script Task and this component is
returning a DataTable containing Files newly added to the FTP.
Can I pass this as return value from Script Task and collect it in some
package variable so that I can loop through this file list n pass on it to
the FTP Task.

I am New to SSIS so if u can point me to some code sample on this if u are
aware of any, will be real help.

Thanks,
Sachin R. Chavan.
"Wei Lu [MSFT]" wrote:

> Hello Chavan,
>
> You need to use the For loop to download mutiple files from FTP.
>
> You could use a Variable in the loop to specify the receive path.
>
> Sincerely,
>
> Wei Lu
> Microsoft Online Community Support
>
> ==================================================
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
 >> Stay informed about: SSIS FTP Task 

Hello Chavan,

You could set a ReadWrite Variable to get the filepath of the FTP file in
the Script Task and contain this Script Task in a For loop container.

And in the FTP task, you could use the vatiable as the Remotepath.

Here are some sample article:

http://www.databasejournal.com/features/mssql/article.php/3518431

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 >> Stay informed about: SSIS FTP Task 

Hello Lu,

Sorry, If I miss spell ur name actaully I am confused abt what's ur First
name so forgive me for that.

Anyways, where I am Facing problem is, when I try to assign some value to
the Read/Write variable of the Script Task, SSIS is throwing some Variable
Lock exception saying the Variable is already lock n there is deadlock on
that variable. Also it shows that it tries to gain lock on this variable
around abt 16 times when i switch 2 the Exception Results Tab.

There is no code in the Script Main except the following lines:


Dim variables As Variables

If Dts.Variables.Contains("FTPFile") = True Then
Dts.VariableDispenser.LockOneForWrite("FTPFile", variables)
End If

variables("FTPFile").Value = "MyFile.txt"

Interesting thing is when I lock this for Read as a ReadOnly variable
surprisingly things work all fine. No errors!!!

I am not getting where I am going wrong, it will be really nice if u can
send in the correct lines of code n let me know where I am getting wrong.

Thanks in Advance,
Sachin R. Chavan.

"Wei Lu [MSFT]" wrote:

> Hello Chavan,
>
> You could set a ReadWrite Variable to get the filepath of the FTP file in
> the Script Task and contain this Script Task in a For loop container.
>
> And in the FTP task, you could use the vatiable as the Remotepath.
>
> Here are some sample article:
>
> http://www.databasejournal.com/features/mssql/article.php/3518431
>
> Sincerely,
>
> Wei Lu
> Microsoft Online Community Support
>
> ==================================================
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
 >> Stay informed about: SSIS FTP Task 

Hello,

You need to unlock the variable after you write the value.

Here is an example.

http://www.developerdotstar.com/community/node/512

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 >> Stay informed about: SSIS FTP Task 

Thanks Lu,

That Solves my problem, am able to write package variables now.

Thanks,
Sachin R. Chavan.

"Wei Lu [MSFT]" wrote:

> Hello,
>
> You need to unlock the variable after you write the value.
>
> Here is an example.
>
> http://www.developerdotstar.com/community/node/512
>
> Sincerely,
>
> Wei Lu
> Microsoft Online Community Support
>
> ==================================================
>
> When responding to posts, please "Reply to Group" via your newsreader so
> that others may learn and benefit from your issue.
>
> ==================================================
> This posting is provided "AS IS" with no warranties, and confers no rights.
>
>
 >> Stay informed about: SSIS FTP Task 

My pleasure, Sachine.

Sincerely,

Wei Lu
Microsoft Online Community Support

==================================================

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

==================================================
This posting is provided "AS IS" with no warranties, and confers no rights.
 >> Stay informed about: SSIS FTP Task