How to send many files to FTP server

Question

Post reply

How to send many files to FTP server

RexSmith

Ten Centuries

Points: 1027
More actions
April 1, 2010 at 7:27 am

#143728

Hello,
Has anyone coded a script task that will upload 2 or more files to an FTP folder?
I have done the same using a ForLoop and an FTP task but I need the code in a Script task that will not use a foreach loop container
Rgds,
See
Rex Smith

Viewing 14 posts - 1 through 13 (of 13 total)

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

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

Lynn Pettis

SSC Guru

Points: 442467

April 1, 2010 at 9:57 am

#1144168

Nope.

Erik Kutzler SSCarpal Tunnel Points: 4287 More actions · Answer 2

This link contains code for an Active X Script Task in DTS to do what you want. It shouldn't be too hard to put in a SSIS Script task.

http://www.sqlservercentral.com/Forums/Topic444266-19-1.aspx

RexSmith Ten Centuries Points: 1027 More actions · Answer 3

Hello,

Both scripts are different. I need the VB.Net Script.

Rgds,

See

Rex Smith

COZYROC One Orange Chip Points: 28499 More actions · Answer 4

seeteshh (4/1/2010)
Hello,
Has anyone coded a script task that will upload 2 or more files to an FTP folder?
I have done the same using a ForLoop and an FTP task but I need the code in a Script task that will not use a foreach loop container
Rgds,
Seetesh

What's the point of this exercise?

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

steveb. SSC-Forever Points: 46733 More actions · Answer 5

seeteshh (4/6/2010)
Hello,
Both scripts are different. I need the VB.Net Script.
Rgds,
Seetesh

Is there a reason you can't use a for-each loop.

doing this in .net is farily straight foward, start off by referencing System.Net and then use the FTP classes in there.

http://msdn.microsoft.com/en-us/library/system.net.aspx"> http://msdn.microsoft.com/en-us/library/system.net.aspx

RexSmith Ten Centuries Points: 1027 More actions · Answer 6

Our client has instructed to write script task where ftp password & other information is kept in some other files.

Rex Smith

COZYROC One Orange Chip Points: 28499 More actions · Answer 7

seeteshh (4/9/2010)
Our client has instructed to write script task where ftp password & other information is kept in some other files.

You can accomplish this without a need to write a script to FTP. You can write a script, which sets package variables and then use expressions to setup your FTP connection manager with the proper credentials information.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/

RexSmith Ten Centuries Points: 1027 More actions · Answer 8

Dim ssisFtp As FtpClientConnection

Try

'Now we create an SSIS connection for pulling the files:

Dim ssisConn As ConnectionManager = Dts.Connections.Add("FTP")

'Set the properties like username & password

Dim intRetries As Int32 = Int32.Parse(Dts.Variables("FtpRetry").Value.ToString)

ssisConn.Properties("ServerName").SetValue(ssisConn, Dts.Variables("ServerName").Value.ToString)

ssisConn.Properties("ServerUserName").SetValue(ssisConn, Dts.Variables("FTPUser").Value.ToString)

ssisConn.Properties("ServerPassword").SetValue(ssisConn, Dts.Variables("FTPPassword").Value.ToString)

ssisConn.Properties("ServerPort").SetValue(ssisConn, Dts.Variables("ServerPort").Value.ToString)

'The 0 setting will make it not timeout

ssisConn.Properties("Timeout").SetValue(ssisConn, Dts.Variables("TimeOut").Value.ToString)

ssisConn.Properties("ChunkSize").SetValue(ssisConn, Dts.Variables("ChunkSize").Value.ToString) '1000 kb

ssisConn.Properties("Retries").SetValue(ssisConn, intRetries.ToString)

'Next we create the FTP Connection

ssisFtp = New FtpClientConnection(ssisConn.AcquireConnection(Nothing))

'And we pass the modified file names in to retrieve the inflated files:

ssisFtp.Connect()

//Need to modify this code ********************

Dim requiredFiles(2) As String

requiredFiles(0) = "a.doc"

requiredFiles(1) = "b.doc"

// End - Need to modify this code *****************

Dim intCount As Int32 = 0

While (requiredFiles.Length > 0 OrElse (requiredFiles.Length = 1 AndAlso requiredFiles(0) <> "")) AndAlso intCount <= intRetries

ssisFtp.SendFiles(requiredFiles, Dts.Variables("FtpDestination").Value.ToString, True, False)

intCount += 1

End While

Need to work on the code postfix with ******

Rex Smith

RexSmith Ten Centuries Points: 1027 More actions · Answer 9

RexSmith

Ten Centuries

Points: 1027

April 15, 2010 at 4:24 am

#1151992

Any clues on this?

Rex Smith

RexSmith Ten Centuries Points: 1027 More actions · Answer 10

RexSmith

Ten Centuries

Points: 1027

April 28, 2010 at 12:35 pm

#1159215

Has anyone used an array for files?

Rex Smith

RexSmith Ten Centuries Points: 1027 More actions · Answer 11

Hi Cozy/all,

Can you post a sample snippet of script task reading data like userid/password/ipaddress from some flat file and using these as variables in the code.

Instead of declaring environment variables.

Rgds,

Seetesh

Rex Smith

VijayakumarKP Old Hand Points: 363 More actions · Answer 12

VijayakumarKP

Old Hand

Points: 363

May 20, 2010 at 4:55 am

#1169998

use third party software like filezilla...

😛

COZYROC One Orange Chip Points: 28499 More actions · Answer 13

RexSmith (5/20/2010)
Hi Cozy/all,
Can you post a sample snippet of script task reading data like userid/password/ipaddress from some flat file and using these as variables in the code.
Instead of declaring environment variables.
Rgds,
Seetesh

You can use XML configuration file or SQL Table. There is no out-of-the-box setup from flat file.

---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/