Welcome to dbFreaks.com!
FAQFAQ    SearchSearch      ProfileProfile    Private MessagesPrivate Messages   Log inLog in

Input Params in Exeucte SQL Tasks == Syntax error or acces..

 
   Database Help (Home) -> DTS RSS
Next:  Importing CSV File  
Author Message
BuzzCatZar

External


Since: Dec 12, 2008
Posts: 1



(Msg. 1) Posted: Fri Dec 12, 2008 3:10 pm
Post subject: Input Params in Exeucte SQL Tasks == Syntax error or access violat
Archived from groups: microsoft>public>sqlserver>dts (more info?)

I can't seem to use a parameter marker (i.e. the ? character) in my Execute
SQL Tasks Properties and then be able to select [Parameters...] to bring up
the Parameter Mapping dialog because the DTS designer keeps generating the
error “Syntax error or access violation”.

I’ve read more than these (links) that discuss this problem, not
specifically with the DTS designer:
http://support.microsoft.com/kb/330199
http://support.microsoft.com/kb/293790

However, my problem is specifically with the DTS designer with Microsoft OLE
DB Provider for SQL Server, not my own code calling the SQLDescribeParam with
said MDAC version. For the record I’m running SQL Server 2000 v8.00.2050
(w/SP4) and my MDAC is version 2.8 w/SP2 on Windows Server 2003 R2 w/SP2.

So far the only way I can define my parameter mappings is by coding the
DTSTask_DTSExecuteSQLTask_<n> InputGlobalVariableNames using Disconnected
Edit. But of course, I have to be syntactically careful to use a semicolon
to without white spaces to separate more than one global variable name for my
parameter markers. I suppose I could always write some work flow ActiveX
code to set the InputGlobalVariableNames as well. All this is pretty hinky
if you ask me, probably one of many reasons of why DTS was dumped altogether.

This isn’t very maintenance friendly and I was wondering if anyone knows
anything more about this, e.g. other experiences with this, Microsoft known
issue but not being fixed (it is SQL Server 2000 after all), or an actual
honest to goodness fix/resolution for this?

Thanks,

--Craig Schreiner
Austin, TX USA

 >> Stay informed about: Input Params in Exeucte SQL Tasks == Syntax error or acces.. 
Back to top
Login to vote
Display posts from previous:   
Related Topics:
DTS Tasks not there??? - Hello All, I have a problem with a clients station, and don't really know enough about SQL server. Here's the issue. I would attach a screenshot, but can't seem to find that option here... When the user goes into "Data Transformation servi...

control flow vs data flow tasks - I want to use SendMail task to send an email - only if data exists in table. easy enough, however to check if data exists I have to go to data flow, how do i return to control flow that data exists and yes - send an email? tia, chris

Problems with Excel date input in DTS - I seem to have an oddity in importing an Excel file via DTS using SQL Server 2000. All of the information imports just fine (including 3 date fields), however on one particular date field, it errors and fails. The following is the error log: Step..

Syntax - Trying in SSIS to do something which technically should be rather simple. 1) create a for each loop that contains as a variable the name of an mdb database in a folder 2) use a stored procedure that prepares a query based on the variable name of that...

Syntax reference for sql commands in excel 2003 via DTS pa.. - Hello, Is there (on internet) an official reference for the syntax to use trying to query data from an excel 2003 database in a DTS package ? here are the details: We use excel 2003 sp3, sql server 2000 sp4, mdac 2.8 sp1 I created a new package...
   Database Help (Home) -> DTS All times are: Pacific Time (US & Canada)
Page 1 of 1

 
You can post new topics in this forum
You can reply to topics in this forum
You can edit your posts in this forum
You can delete your posts in this forum
You can vote in polls in this forum



[ Contact us | Terms of Service/Privacy Policy ]