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,628 questions
0 comments

2 answers

Sort by: Most helpful
Most helpful Newest Oldest
  1. Olaf Helper 45,626 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 39,666 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

Your answer

Answers can be marked as Accepted Answers by the question author, which helps users to know the answer solved the author's problem.