SSIS package Query results Error

• ns.sharath

  SSC Eights!

  Points: 876

  More actions

  March 3, 2009 at 11:18 pm

  #135139

  When i run a query in SQL Server Management Studio it returns correct results.

  When i paste the same query in OLE DB Source component in SSIs and preview the result the result set shows new line character for some of the records.

  Is there any reason why this happens?

• TangoVictor

  SSChampion

  Points: 10975

  More actions

  March 4, 2009 at 5:36 am

  #953036

  my guess it that it exists in the data but just not displayed in Mgnt studio results.

  If you open the table not query it you should see those characters.

  Other thing you could do to confirm is check for these in your where clause.

  Where myField = Char(14) or whatever the ASCII code is for the characters you are seeing.

  or display the value of the non-print characters

  - ASCII(myField) (returns ascii value of first character in field)

  that should clear things up.