HELP

[Bell1991]

I need to create a DTS that will be called from a stored procedure.. Which is somewhat easy to do.. But i need to query the database - to only return certain records.. For example: Select * from table where state = 'NY' (Ny would be passed into the stored procedure - then i need to pass it into the DTS) and return those records in an access database. Is this possible?

Thanks in advance

 

[MDXer]

you might be able to have the sp insert the criteria into a table then have the DTS package read the table and populate a variable within the package.

"Shoot Me! Shoot Me NOW!!!"
- Daffy Duck