Post reply

dts transfer problem

  • August 31, 2009 at 7:58 am

    #96114

    hi friends

    Daily i need to give some daily report to some dept

    So I kept some job for taking the report ..in that I am using import and export wizard to transfer data from temp table to excel

    Everything is fine but in excel , all varchar data have single quotation in first char of the data so we facing problem..

    Please help me

    I forward the excel also

  • August 31, 2009 at 8:16 am

    #1046883

    Basically this is Excel feature that it puts a single quotation mark before any thing that seems to be anonymous data type to Excel. Single quotation mark tell excel that the data to be displayed as text, not as any formula or number etc.

    I don't know, how you have configured your DTS package, however, in DTS package, you can specify the data type for the columns. You need to make sure that you specify data type in DTS package, and also configure excel column for same data type, in your case it should be TEXT i guess.

    If still it does not work, then probably you may need to give some details about your dts package, including the step that brings data from source to target.

    Swarndeep

    http://talksql.blogspot.com

  • September 1, 2009 at 7:49 am

    #1047525

    hi Swarndeep

    thanks..

    today i changed the datatype to text ..but no use

    i am using dts normal paclage

  • September 4, 2009 at 5:54 am

    #1049313

    What I would do is create a DTS package witht he Excel source and SQL destination and define your transformation as a "ActiveXScript" and then use vb script to strip out the single quotation marks in the xls column (Source).

  • September 4, 2009 at 10:21 pm

    #1049667

    thanx

    please can u give the vb script

    i will try with the vb script

  • September 8, 2009 at 6:54 am

    #1050470

    I went back and read your post again. Sorry I misunderstood your original quesion. So you have a source SQL temp table and you need to export those results to excel?

    From what I understand the single quotation that you get in the excel sheet is due to the formatting options in excel.

    The only thing that I can think of is maybe to create a script in excel to change the column format of the data after the DTS runs

  • September 25, 2009 at 1:40 pm

    #1058650

    Is it resolved? Whats the data type of the source column tht is causing problem in excel?

    MJ

  • September 25, 2009 at 9:36 pm

    #1058721

    hi this is not solved .. problem is coming for varchar,nvarchar,char data type ..please give solution

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

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