-
How reset values in DTS global variables before execution?
Hi,
Default values in DTS globale variables saved with DTS
and it cause problem.
Example
Default global variables values in dts 'flash_default_values1
SERVER_NAME =SQL_TEST
DB_NAME=bamboo
if we run
dtsrun /S SQL_DEV /E /N 'flash_default_values1 /A "SERVER_NAME":"8"="SQL_DEV" /A "DB_NAME":"8"="price"''
everything is fine
if we run
SQL_DEV /E /N 'flash_default_values1'
dts will not generate error ,but use default values
How to flash default values before execution ?
I tried to use ActiveX as first step in DTS
Function Main()
Dim oGlobalVariables
Dim oVariable
For Each oVariable in DTSGlobalVariables
oVariable.Value = """"
Next
Main = DTSTaskExecResult_Success
End Function
..but it erase value in my input paramters when execution starts
thank you
Alex
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|