Post reply

single quote in excel destination?

  • November 27, 2007 at 11:08 am

    #122523

    I am writing to an excel destination and I am writing out text data and the data is preceded by a single quote in every row. The end users do not want that. Is there a WAY FOR ME TO GET RID OF THE SIGNLE QUOTE?

    Please let me know.

    Thanks,

    Manisha

  • November 27, 2007 at 2:25 pm

    #754733

    Hi Manisha,

    Where is the data source. Another file or a db.

    One way would be to substring in a query.

    The other would be to use a derived column task in the transform. Use the REPLACE or SUBSTRING function in the expression for a new column.

    Norman

    DTS Package Search

    http://www.dtspackagesearch.com//

  • November 27, 2007 at 2:51 pm

    #754743

    I figured this out. The datasource is SQL Server 2005. The problem is not with the data it is with Excel. For text fields excel prepends it with a semi colon indicating that it is a text field. I used a csv destination instead and got around the problem.

    Thanks,

    Manisha Waghray

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

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