Post reply

Format Excel file

  • March 26, 2010 at 8:08 am

    #142206

    Hi,

    I'm new in SSIS. I've filled a excel spreadsheet using sql query. Now I want to format the Amount column in number because its comming in text format in excel sheet. Please help me.

    Many thanks

    Sneh

  • March 26, 2010 at 8:43 am

    #1140403

    You're going to have to use the data conversion transformation to put it in the proper format.

    FYI, the easiest way is to use the "Export Data" wizard in SSMS, specify your query as the source, and Excel as the destination, and then save this to an SSIS pkg (file system). This will properly set up everything, and then you can go back and see what it did.

    Wayne
    Microsoft Certified Master: SQL Server 2008
    Author - SQL Server T-SQL Recipes

    If you can't explain to another person how the code that you're copying from the internet works, then DON'T USE IT on a production system! After all, you will be the one supporting it!
    Links:
    For better assistance in answering your questions
    Performance Problems
    Common date/time routines
    Understanding and Using APPLY Part 1 & Part 2

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply