Post reply

Can't get SSIS to output an int in excel file

  • September 19, 2008 at 9:08 am

    #191049

    hi all,

    I'm completely new to SSIS packages and got a very rough crash course from a coworker. What I'm trying to do is output an excel file that will have three columns. i get it to do that just fine. what I'm having trouble with is that one of the columns is of the data type int so that calculations can be done on it if the user so pleases. I have searched many sites and seems that i have to have the initial data type in SQL to be either an int or a float. i tried that and it worked in Excel 2003. the client put excel 2007 on the machines and the output fails misreably. SSIS output inserts a ' in front of the field and so making it a text field which the user can not calculate.

    any ideas how i should fix this in excel 2007? i tried manually converting the fields but it doesn't get rid of the '. I'm lost...is there a reason why it worked in excel 2003 and not in excel 2007?

    Thanks much!

  • September 22, 2008 at 1:27 pm

    #875243

    doesn't anybody know how to fix this? or is it too simple a solution for somebody to help me with this?

  • September 22, 2008 at 1:37 pm

    #875247

    Two possibilities. One, no one else has run into this particular problem. Two, no one is using Excel 2007 yet.

    Give it some time, someone may actually have a solution, they just haven't seen your post yet.

    I, unfortunately, fall into both categories above.

    😎

  • October 21, 2008 at 4:51 am

    #887509

    Hi,

    I have the same problem as yourself and would like to know if you have come up with a solution yet ?

    Thanks

  • October 21, 2008 at 7:22 am

    #887574

    Hi,

    I know how frustrating it is...Sorry. OK this may be a workaround but it's the ONLY way I can get this to work:

    In excel, I have a header row with all the heading and then the first row after that I have sample dummy data.

    here's an example:

    ItemNumber DateCreated Quantity TrackingNumber

    1/1/2008 1ABC2345DE7890

    Any fields that require a different type such as alpha-numeric fields or date fields, I set to Text and date data types respectively. Other, I can get away with by leaving as General.

    Let me know if that works for you.

  • October 22, 2008 at 4:18 am

    #888010

    Thanks for that information.

  • October 22, 2008 at 4:27 am

    #888012

    Yes your solution works fine. Thanks

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

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