dynamically selecting which data to pull into destination

  • Hi.. I have a requirement where I have to deal with data of current year and data of next year. I have a separate query written each for the current year and the next year and the data is being written to excel destination. Now, I need to develop a package which runs periodically in such a way that, I should be able to select between which year's data i need to pull to the destination. If I choose to pull current year data, then the query related to current year should execute and the current year data has to be written to the destination.

  • Hi,

    You have to use dynamically created query and execute it. The query should have @date_from and @date_to. Because you have to get data from CUBE (am I am right?), the problem becomes harder, but it's solvable.

    So please precise from what source are you trying to get data for a selected time period?

    Igor Micev,My blog: www.igormicev.com

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

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