Post reply

ADO Source using a SQL Command to pull data from SQL Server(2008) in SSIS(2008)

  • September 30, 2011 at 5:21 pm

    #244615

    Hello, I'm using an ADO Source to read a sql table with inline sql. I developed the sql code in Management Studio and it runs fine and returns one results row (an xml string), which is what I want. When I add the inline code to the ADO Source object in my pacakge and preview the query it returns three rows. The results set is over 4000 chars. I need the package to return a one row result. Anyone run into this problem?

    Thanks.

  • October 2, 2011 at 9:38 pm

    #1389272

    Is this a case where your inline SQL is exceeding 4,000 chars in an expression so a WHERE clause is getting truncated/cut off? That may be an explanation.

    HTH,

    Rob

  • October 4, 2011 at 9:22 am

    #1390210

    Hi Rob, no it's the results record from the ADO source using the inline sql command. It returns three rows becuase the returned result set is larger then 4k, it appears. Is this a know limitation?

    Thanks, Steve

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

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