ExecuteSQLTask SQLStatement Property Name
-
I have instantiated an object for an existing ExecuteSQLTask in an ActiveX task. How do I set the SQLStatement property? I can't find the property name anywhere, and the name in the DynamicProperties task ("SQLStatement") is not recognized by the ActiveX instantiation.
Can someone help me?
-
This was removed by the editor as SPAM
-
This may be what you are looking for:
'**********************************************************************
' Visual Basic ActiveX Script
'************************************************************************
Function Main()
Dim oPackage
Dim oTask
Set oPackage = DTSGlobalVariables.Parent
Set oTask = oPackage.Tasks("DTSTask_DTSExecuteSQLTask_1")
oTask.Properties("SQLStatement").Value = "SELECT * FROM [Table]"
Main = DTSTaskExecResult_Success
End Function
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply