none
String Column Issue with SSIS Wizard SP Source

    Question

  • 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 sqlusa.com
    New Book / Kindle: Pass SQL Exam 70-461 & Job Interview: Programming SQL Server 2012


    Saturday, July 20, 2013 8:37 PM

Answers

  • Hello Kalman,

    It must be an issue logged here http://connect.microsoft.com/SQLServer/feedback/details/775897/sql-server-import-and-export-wizard-does-not-recognise-varchar-and-nvarchar


    Arthur My Blog

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

All replies