Share via

SSIS sets numeric columns as Unicode String in Excel Destination

Rahman, Neyaz 0 Reputation points
2024-01-31T14:31:14.93+00:00

ExcelDataConversionIssue.JPGI'm creating a SSIS package with Source SQL Server Table and destination Excel. The source Numeric data type taking as Unicode String in Excel Destination by default. But my requirement is the Excel Destination data type should be numeric as source. Have any solution to fix the issue?

SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,479 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 42,286 Reputation points
    2024-01-31T20:11:04.4366667+00:00

    Unicode String in Excel Destination by default.

    Excel don't know dedicated data types, everything is a "value" with format information and so nvarchar(255) by default; that's by design

    Have any solution to fix the issue?

    There is no issue to fix, it's by design and quite normal. You have to modify the target data type manually on your own.

    0 comments
  2. ZoeHui-MSFT 34,346 Reputation points
    2024-02-01T05:47:41.01+00:00

    Hi @Rahman, Neyaz, You could only manually change the data type after you load data into Excel. Regards， Zoe Hui

    If the answer is helpful, please click "Accept Answer" and upvote it.

    0 comments