Post reply

Converting a column value 12:27:2008 to 12.27.2008

  • June 19, 2008 at 10:57 pm

    #122828

    hi,

    I have created a package for transfering excel sheet values to the sql tables .In that i want to convert the total timeworked column values as a float value in sql table,since i want to use it as a measure in the cube.So i must made the conversion,either in the excel or using the SSIS component.

    Help me out guys.

    Thanks & Regards

    vijay

  • June 20, 2008 at 12:28 am

    #831507

    Please don't cross post. It just wastes people's time and fragments replies.

    No replies to this thread please. Direct replies to:

    http://www.sqlservercentral.com/Forums/Topic520331-148-1.aspx

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

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

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