Thanks, Sergey. That helped.
Richard
>>I need to import data from an Oracle database that is 95% out of my control and they create table names like this:
>>
>>SomeData_{year}_{qtr} where {year} and {qtr} is the fiscal year and quarter the data applies to.
>>
>>I'm looking for some way to do this dynamically in SQL Server in DTS. I'm pretty sure I will end up using an ActiveX script but I'm mainly looking for something else first.
>>
>
>
>Hi Richard,
>
>See if you can find answer at
http://www.sqldts.com/.
State of Florida, DCF