How do I output Global Variables from a DTS package?

[edwardturner]

How can I get the value of global variables into say a text file using DTS?

 

[AlexCuse]

You could create a dts task to export to a text file. Set the source dynamically using an ActiveX task like this one:

Function Main()
	Dim oPkg, oDataPump, sSQLStatement

	' Build new SQL Statement
	sSQLStatement = "SELECT '" & _
        DTSGlobalVariables("@D1").Value & "', '" & _
        DTSGlobalVariables("@D2").Value & "'"
'And so on for all of your global variables.....
	' Get reference to the DataPump Task
	Set oPkg = DTSGlobalVariables.Parent
	Set oDataPump = oPkg.Tasks("DTSTask_DTSDataPumpTask_1").CustomTask

	' Assign SQL Statement to Source of DataPump
	oDataPump.SourceSQLStatement = sSQLStatement

	' Clean Up
	Set oDataPump = Nothing
	Set oPkg = Nothing

	Main = DTSTaskExecResult_Success
End Function

HTH,

Alex



It's a magical time of year in Philadelphia. Eagles training camp marks the end of another brutal season of complaining about the Phillies.