Post reply

How to Format excel template sheet column data using ssis

  • October 6, 2014 at 7:41 am

    #397463

    Hi,

    I am filling an excel sheet named sheet1 of a predefined template using SSIS. The template has many other sheets which are calculated using predefined formulas referring sheet 1. Currently I am able to successfully fill the data in sheet1 but other sheets not getting populated until I manually perform Text Column conversion on few columns like Date,Time(hh:mm:ss). Could some one please help me to achieve this task. Can I automate the Text to Column conversion operation after filling the excel.

    Thanks in advance,

    Jithu

  • October 6, 2014 at 7:48 am

    #1750310

    You'll have to use .NET to do this. SSIS cannot do this out of the box.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

  • October 6, 2014 at 8:14 am

    #1750315

    Thanks for the quick response.

    So can I use a script task after DFT do formatting.

    Thanks,

    Jithu

  • October 6, 2014 at 12:52 pm

    #1750380

    jjr.123 (10/6/2014)

    So can I use a script task after DFT do formatting.

    That's an option yes.

    Need an answer? No, you need a question
    My blog at https://sqlkover.com.
    MCSE Business Intelligence - Microsoft Data Platform MVP

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

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