stored procedure

Question

Is it possible make 2 stored procedures in 1 where the 1st one reads data from access database and the 2nd writes the data read before to a sql server database?

Administrator · Answer

Create DTS process and use dtsrun command prompt utility to run it. Mike

Administrator · Answer

and how do i do it using Data Tranformation Services i'm doing this in c# component

Administrator · Answer

I guess it's possible if you have Access as a linked server. However I personally would do it using Data Transformation Services. Mike