Active x scritp to script task in SSIS

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SSIS and Import/Export (2008)

Active x scritp to script task in SSIS

Author

Topic

under2811
Constraint Violating Yak Guru

366 Posts

Posted - 2010-08-13 : 10:48:30

Hi,

I have dts package and active x script as below i want to write into SSIS 2008 .vb in script task

Function Main()
Dim oFSO, aPointer, sScriptPathAndName

Set oFSO = CreateObject("Scripting.FileSystemObject")

sScriptPathAndName = DTSGlobalVariables("FtpScriptPath").Value

Set aPointer = oFSO.CreateTextFile(sScriptPathAndName, True)

aPointer.WriteLine DTSGlobalVariables("FtpScript").Value

aPointer.Close

Set aPointer = Nothing
Set oFSO = Nothing

Main = DTSTaskExecResult_Success

End Function

please help me out
T.I.A

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-08-14 : 02:59:28

didnt understand the problem. you mean above is not working properly?

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

gaauspawcscwcj
Starting Member

29 Posts

Posted - 2010-09-01 : 14:06:47

My.Computer.FileSystem.WriteAllText(sScriptPathAndName, Dts.Variables("User::FtpScript").Value.ToString.Trim & vbNewLine, True, System.Text.Encoding.Default)
thats all you need

gaauspawcscwcj

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources