Post reply

Execute SQL Task and Parameters - getting error

  • November 2, 2006 at 12:10 pm

    #367971

    I have a SSIS variable defined:

    Name = varMyValue

    Scope = mypackagename

    Data Type =  String

    Value = "temp"

    I have a Execute SQL Task that is using a Native OLE/DB client connection object.  I have a SQL Stmt = exec dbo.spDoSomething ?.  In Parameter Mapping, I have the following:

    Varibale Name = User::varMyValue

    Direction = Input

    Data Type = Varchar

    Parameter Name = 0

    When I try to parse this query I get the following error.

    The query failed to parse. Attempted to read or write protected memory. This is often an indication that other memory is corrupt.

    Why is this happening?

  • November 2, 2006 at 11:26 pm

    #669695

    if memory serves, the parser is not smart enough to understand SSIS parameter queries with the "?" place-holder.  The parser can only handle literal SQL.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply