SSIS - how to export csv to display long number instead of display 13.4+3E

nononame2021 256 Reputation points
2022-06-20T10:21:07.467+00:00

i am preparing SSIS to export csv, however, when i export long number, it can't display correct upon i format the column to number or special in csv manually, it is very inconvenience.

anyone know how to resolve it in SSIS? the column data type in SQL server is set as nvarchar(50). it contain data are list as below:

1234566666666666
12345678(4)
11111111111111-111

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,487 questions
SQL Server Integration Services
SQL Server Integration Services
A Microsoft platform for building enterprise-level data integration and data transformations solutions.
2,438 questions
Transact-SQL
Transact-SQL
A Microsoft extension to the ANSI SQL language that includes procedural programming, local variables, and various support functions.
4,536 questions
{count} vote

8 answers

Sort by: Most helpful
  1. Tom Phillips 17,716 Reputation points
    2022-06-20T17:32:03.6+00:00

    You are apparently talking about Excel's "auto typing" of columns. Unfortunately, there is no way to control that feature of Excel. You have to set the type after the import into Excel.

    0 comments No comments

  2. Tom Phillips 17,716 Reputation points
    2022-06-20T19:51:16.467+00:00

    If Excel is your desired output, I suggest you use an Excel "template" to format the output for Excel.

    See:
    https://brandietarvin.livejournal.com/28230.html

    0 comments No comments

  3. ZoeHui-MSFT 32,236 Reputation points
    2022-06-21T01:55:10.357+00:00

    Hi @nononame2021 ,

    It is a good idea like YitzhakKhabinsky-0887 said to add the Derived Column Transformation.

    Or you may open the csv file and format the whole cell with number.

    Regards,

    Zoe


    If the answer is the right solution, please click "Accept Answer" and kindly upvote it. If you have extra questions about this answer, please click "Comment".

    Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

    0 comments No comments