Hello,
I'm having a couple of issues using DTS(Data Transformation Services) with MS Server 2000 and was wondering if there were any guru's around here that could possibly help.
Basically in Enterprise Manager(DTS), I'd like to pass a global variable, set in a VB Active X script from an input text file, into my sql script. I know this is possible because the help file shows you how to achieve this, but im getting the same error when using '?'(paramter mark) in my 'Execute SQL Task' Script:
---------------------------------------------------------------------------
Syntax Error Or Access Violation
---------------------------------------------------------------------------
So I can't set the parameters for the script due to this syntax error. Anyone come across this before?
Secondly, I'd like to know the syntax for Outputting to a file(I know you can achieve this by setting an option in query analyser) but I need to know how to do it via a DTS Package.
Sorry for making this so long winded, hope you can help...thank you.
I'm having a couple of issues using DTS(Data Transformation Services) with MS Server 2000 and was wondering if there were any guru's around here that could possibly help.
Basically in Enterprise Manager(DTS), I'd like to pass a global variable, set in a VB Active X script from an input text file, into my sql script. I know this is possible because the help file shows you how to achieve this, but im getting the same error when using '?'(paramter mark) in my 'Execute SQL Task' Script:
---------------------------------------------------------------------------
Syntax Error Or Access Violation
---------------------------------------------------------------------------
So I can't set the parameters for the script due to this syntax error. Anyone come across this before?
Secondly, I'd like to know the syntax for Outputting to a file(I know you can achieve this by setting an option in query analyser) but I need to know how to do it via a DTS Package.
Sorry for making this so long winded, hope you can help...thank you.