Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

MS SQL Server 2000/DTS

Status
Not open for further replies.

damell

Programmer
Jul 3, 2003
1
GB
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.

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top