Hi

I've created a dts package that generates several output files from SQL & then uses the following sample VB script to export them via. cuteftp.

Dim MySit

Dim DestFolde
Dim SrcFolde
Dim FileToUploa

Dim FTPsit
Dim UserI
Dim Passwor
Dim Protoca

DestFolder = "/
SrcFolder = "C:\
FileToUpload = "CONFIG.SYS

FTPSite = "ftp.ftpsite.net
UserId = "xyz
Password = "*******
Protocal = "SFTP


'Creating a connection object and assign it to the variabl
Set MySite = CreateObject("CuteFTPPro.TEConnection"

' Now set each property for the site connection
' You can omit this section to use the default values, bu
' you should at least specify the Hos
'The default Protocol is FTP, however SFTP (SSH2), FTPS (SSL), HTTP, and HTTPS can also be used
MySite.Protocol = Protoca
MySite.Host = FTPSit
'following lines are optional since the default is anonymous if no login and password are define
MySite.Login = UserI
MySite.Password = Passwor
'if necessary, use the UseProxy method and ProxyInfo or SocksInfo properties to connect through a proxy serve
MySite.UseProxy = "BOTH
'now connect to the site (also called called implicitly when a remote method is called
MySite.Connec

....et

If I create the output files from DTS and run the vb independently via Explorer it works just fine, but from within DTS it fails with

DTSRun OnError: DTSStep_DTSActiveScriptTask_1, Error = -2147220485 (800403FB

Error string: Error Code:

Error Source= Microsoft VBScript runtime erro

Error Description: ActiveX component can't create object: 'CuteFTPPro.TEConnection

Any ideas?

I'm a bit confused about doing this in Explorer, I've only used a cmd window.

What version of MSSQL are you using?

Here's some google....

http://sqlteam.com/item.asp?ItemID=12408

http://www.eggheadcafe.com/articles/20030923.asp

http://msdn.microsoft.com/library/de...mtsk3_2jaj.asp


HTH

JeffP....


"Dan" <anonymous (AT) discussions (DOT) microsoft.com> wrote