1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

  2. Anuncie Aqui ! Entre em contato fdantas@4each.com.br

Pass SSIS parameter into OPENQUERY

Discussão em 'StackOverflow' iniciado por fdantas, Novembro 28, 2018.

  1. fdantas

    fdantas Administrator Moderador

    Please I need help passing a parameter in SSIS into an 'OPENQUERY', to test the query I'm using the script below but getting errors:

    Script:

    DECLARE @TSQL varchar(8000), @Date varchar(11)
    SELECT @Date = '28 Nov 2018'
    SELECT @TSQL = 'SELECT * FROM OPENQUERY([TEST], ''SELECT * FROM PUB.TEST
    WHERE Test_Date >= ''''' + @Date + ''''''')'
    EXEC (@TSQL)


    Error:

    OLE DB provider "MSDASQL" for linked server "TEST" returned message "[DataDirect][ODBC Progress OpenEdge Wire Protocol driver][OPENEDGE]Invalid date string (7497)".
    Msg 7321, Level 16, State 2, Line 4
    An error occurred while preparing the query "SELECT * FROM PUB.TEST
    WHERE Test_Date >= '28 Nov 2018'" for execution against OLE DB provider "MSDASQL" for linked server "TEST".


    Script in SSIS OLE DB Source should look like this:

    DECLARE @TSQL varchar(8000), @Date varchar(11)
    SELECT @Date = ?
    SELECT @TSQL = 'SELECT * FROM OPENQUERY([TEST], ''SELECT * FROM PUB.TEST
    WHERE Test_Date >= ''''' + @Date + ''''''')'
    EXEC (@TSQL)

    Continue reading...

Compartilhe esta Página