Post reply

data export to csv file

  • June 24, 2011 at 1:41 pm

    #253388

    Hi,

    I created a SSIS package to export data from SQL Server 2005 table to csv file

    One of user table has a free text column with datatype varchar(3000).

    so now issue is , data is incorrect in csv file

    for example: the value 10.3 is converting to date format 1/10/1900 7:12

    is this something bug in SSIS 2005?

    Appreciate your help!

  • June 24, 2011 at 2:13 pm

    #1343917

    sounds like you opened the file in Excel, and not a simple text editor;

    excel might reformat the presentation of any column to what it thinks is best...

    open the csv in notepad or a better text editor like EditPlus,SSMS, NotePad or something....i think you'll find the real value in the file really is 10.3.

    Lowell

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

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

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