DTS Import text file into Global Variable

[Chance1234]

I have a text file source, which i want to import into a global variable which i can then later retrieve as a recordset.

I know how to do this if it was a database source, but cant see how to do it with a text source


with regards

Chance,



Filmmaker, gentleman and pearls before swine fan

http://WWW.5YLAC.S5.COM

 

[ClaireHCM]

In the ActiveX--
'**********************************************************************
' Visual Basic ActiveX Script
'************************************************************************

Function Main()

Dim oPKG
Dim cn
Set oPKG = DTSGlobalVariables.Parent
Set cn = oPKG.Connections("Text File (Source)&quot cn.DataSource = DTSGlobalVariables("FilePath&quot.Value
Main = DTSTaskExecResult_Success
End Function


You should have a on success connection pointing to a Text File (Source) and
GlobalVariable as FilePath