Post reply

Formatting Output Fields in Connection Manager

  • August 12, 2008 at 10:29 am

    #124779

    Hello,

    I have a data source that holds several fields in "float" format. I want

    to output to a flat file in SSIS in a currency-type format like

    1234.99 (no symbol) rather than the 1234.990000001 type that is

    currently being output. In the Connection Manager Editor, Advanced tab,

    it appears that the output can be configured to format differently,

    however I can't figure out which one (if any exists) that could be

    used to do this. Is this possible?

    Thanks in advance

  • August 12, 2008 at 11:03 am

    #856893

    Try using "derived column" to convert the data

    Add a "derived column" component after OLEDB source and

    use (DT_NUMERIC,4,2) in expression for derived column.

    Hope this helps 🙂

  • August 12, 2008 at 3:25 pm

    #857068

    Hi Sarang,

    Thanks for your reply.....it does look like I need to convert the datatypes

    further upstream than where I was hoping to do it --- the app wouldn't take

    my conversion in the Connection Manager Editor. I'll give the Derived

    Column Transform a try.

  • August 12, 2008 at 3:40 pm

    #857074

    Use type Numeric

    Change the Data Scale and precision values

    Regards
    Venkat
    http://sqlblogging.blogspot.com[/url]

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

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