String Column Issue with SSIS Wizard SP Source


  • When I use

    USE [AdventureWorks2012]
    EXEC	[dbo].[uspGetBillOfMaterials]
    		@StartProductID = 800,
    		@CheckDate = N'2008-02-01'

    As source in SSIS Import/Export Wizard, it cannot map the string column. It shows 202 for source type. Same for other sp-s with string columns in results set.  When I specifically did a convert(varchar...) in the output, it showed 200 for type.

    Kalman Toth Database & OLAP Architect
    New Book / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012

    Saturday, July 20, 2013 8:37 PM


  • Hello Kalman,

    It must be an issue logged here

    Arthur My Blog

    • Marked as answer by Kalman Toth Monday, July 29, 2013 7:36 PM
    Monday, July 29, 2013 6:04 PM

All replies