Lookup Value in DTS Package

[Tinkerers]

Hi,

I use SQL Server 2000 and need to setup a DTS package that will pull data from an Oracle db each day. The problem is, in the Oracle db there is a partition set with the current date, like this:

select columnA,columnB
FROM Schema.TableA partition (CMEX_2007_10_26)

So each day I need to increment the date of the partition dynamically so that I can retrieve the proper data. I can't seem to figure out how to increment this date using the Lookup portion of the package. SQL Server does not like the ? in the partition part of the sql. I am not very good at using lookups anyways. I wonder if this could be rewritten using exec @sql with the actual sql code inside the variable.

Any ideas or examples would be so much appreciated!

Thanks,
Paul

 

[B827]

Hi,
I know it is a very long time since this post but I solved a similar problem today (9th April 2008). If this is still an issue I can tell you what I did.

Sandy