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,414 questions
0 comments No comments
{count} votes

2 answers

Sort by: Most helpful
  1. Olaf Helper 39,026 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 No comments

  2. ZoeHui-MSFT 30,566 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 No comments