Home Forums Data Warehousing Integration Services truncation of datetime works fine in tsql but does not work when data loaded to txt file RE: truncation of datetime works fine in tsql but does not work when data loaded to txt file

  • July 27, 2016 at 3:50 pm

    #1892391

    I used Convert(varchar(19) , [Date] ,120 )

    still i get the same in text file with datetimeoffset