VB.Net override DTS Global Variable problem - Programmers Heaven

Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

VB.Net override DTS Global Variable problem

StompcatStompcat Posts: 2Member
The relevent code I'm using to override the global variable is below. The DTS package runs within DTS, however, when I try to execute with .Net, I get the error log file below: What parameter is missing a default value? 'DTSTransformation__28' is a text file which I'm trying to override with the global variable "FileName".
Any clues or hints?


Dim oPKG As DTS.Package
Dim oVar As DTS.GlobalVariables
oVar = oPKG.GlobalVariables
oVar.Item("FileName").Value = sFileName


*******************************LOG FILE *******************************************
Execution Started: 5/3/2005 12:24:14 PM

@@LogSourceRows: Q:CLP-ITStatisticsPeople CounterWaitingInputTestInputFrankErrors.txt.Source
@@LogDestRows: Q:CLP-ITStatisticsPeople CounterWaitingInputTestInputFrankErrors.txt.Dest

@@ErrorRow: 1
Error during Transformation 'DTSTransformation__28' for Row number 1. Errors encountered so far in this task: 1.

Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Error Description:Error Code: 0
Error Source= Microsoft VBScript runtime error
Error Description: Invalid procedure call or argument: 'DTSDestination'

Error on Line 7

Error Help File:sqldts80.hlp
Error Help Context ID:30631


Error Source: mscorlib
Error Description:Missing parameter does not have a default value.
Parameter name: parameters
Error Help File:
Error Help Context ID:0
@@SourceRow: Logged
@@DestRow: Not Available

@@ExecutionCompleted

Execution Completed: 5/3/2005 12:24:16 PM
Sign In or Register to comment.