Post reply

Dynamic column names at the destination

  • October 4, 2010 at 9:31 am

    #227576

    Hi All,

    How can I have the dynamic column names at the detination, My colums name chages every quater. I mean to say, the date should be added up with the column name, everytime I run the package.

    I have been looking at different articles but I could not find any which could resolve my problem.

    It would be great if any one could guide me.

    Thanks,

    Preensheen

  • October 5, 2010 at 1:31 am

    #1231488

    Well, you can't. At least not with out-of-the-box SSIS.

    There are possibly some commercial add-ins that let you achieve this task.

    So basically, you are stuck with scripting. Either in a Script Task, or in T-SQL in an Execute SQL Task.

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

  • October 5, 2010 at 7:17 am

    #1231666

    da-zero (10/5/2010)

    Well, you can't. At least not with out-of-the-box SSIS.

    There are possibly some commercial add-ins that let you achieve this task.

    So basically, you are stuck with scripting. Either in a Script Task, or in T-SQL in an Execute SQL Task.

    Can you please guide me best way by which I can achive the task accomplished.

  • October 5, 2010 at 11:22 am

    #1231917

    What is the Business Intelligence tool you are using? SSRS or SSIS

  • October 5, 2010 at 11:34 am

    #1231933

    preensheen (10/4/2010)

    Hi All,

    How can I have the dynamic column names at the detination, My colums name chages every quater. I mean to say, the date should be added up with the column name, everytime I run the package.

    I have been looking at different articles but I could not find any which could resolve my problem.

    It would be great if any one could guide me.

    Thanks,

    Preensheen

    You may find it simpler to store your data in a table that doesn't put each quarter in a separate column, but rather has a [quarter] column, and a pivot view on top of that table.

  • October 5, 2010 at 1:52 pm

    #1232048

    laksgovi (10/5/2010)

    What is the Business Intelligence tool you are using? SSRS or SSIS

    SSIS

  • October 5, 2010 at 1:55 pm

    #1232051

    getoffmyfoot (10/5/2010)

    preensheen (10/4/2010)

    Hi All,

    How can I have the dynamic column names at the detination, My colums name chages every quater. I mean to say, the date should be added up with the column name, everytime I run the package.

    I have been looking at different articles but I could not find any which could resolve my problem.

    It would be great if any one could guide me.

    Thanks,

    Preensheen

    You may find it simpler to store your data in a table that doesn't put each quarter in a separate column, but rather has a [quarter] column, and a pivot view on top of that table.

    So it is more likely that...I have to first pull all the quater values in a table and then pivot that table ...and once the table is ready..with all quaters...then start inserting the values which have to be..right?

  • October 5, 2010 at 11:10 pm

    #1232234

    Absolutely, the package flow would resemble as below:

    Original data --> Derived Column Task --> Pivot Task --> Destination

    Raunak J

  • October 6, 2010 at 10:21 am

    #1232776

    Raunak Jhawar (10/5/2010)

    Absolutely, the package flow would resemble as below:

    Original data --> Derived Column Task --> Pivot Task --> Destination

    Hey thanks a lot. Working on it and let you know once I suceed.

Viewing 9 posts - 1 through 8 (of 8 total)

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