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?

Answer 1

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

Answer 2

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

Answer 3

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