Post reply

Convert DateTime to SmallDateTime in SSIS

  • November 3, 2010 at 4:07 pm

    #242609

    Hi,

    I want to convert the datatype of a field from datetime to smalldatetime in SSIS. Which datatype should I use in SSIS ?

  • November 11, 2010 at 2:12 am

    #1249329

    I probably wouldn't do this in SSIS, I would modify the query that pulls the data and does the convert there, it would be WAY more efficient. Not sure if that is possible for you..

    CEWII

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

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