Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2003
    Posts
    17

    Unanswered: DTS to Excel Export - Changing Format

    Hi,

    I have a dts package which is reading from a sql table and writing it to an excel file, its working fine except that I have a decimal field in the sql table but in excel file its writing it as string field.

    The way I create this package is that I create a template file and I format that column to a "Number" format. Then I take this template file, rename it, export all the data to this file.

    But when I open this file that decimal field is displayed as a string column and its left aligned.

    Is there any way to fix this problem?

    Thanks,

  2. #2
    Join Date
    Nov 2003
    Location
    Christchurch, New Zealand
    Posts
    1,618
    I've never seen this happen. You aren't wrapping you values in quotes are you when you export them.

  3. #3
    Join Date
    Nov 2003
    Posts
    17

    DTS to Excel Export - Changing Format

    No, I am not wrapping values in quotes.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •