DTS Package

[HLPCH]

Hi, I am creating a package to transfer data from MS Access to SQL Server. I used the connection object to specify the Source and Destination. I know the Transfer Data task would transfer data from each of the tables from Ms Access. However I wanted to know if the DTS had the capability to transfer Access queries to SQL as a Stored Procedure or Views.

If so what do I need to use ?

Please help!

SS.

 

[jbenson001]

As far as I know, know there is no way to do this. You will have to convert your queries to SPs for views manually. It shouldn't be extreamly difficult, the syntax of both are close, however there are differences. There may be some posts in here that may point you in the right direction.