hi

1) create two temp tables in sql db and transfer the access information into the temp tables.

2) write update statement to your original db comparing the key's of temp...

Yes, you can change the connection dynamically. I have given a c# code for the same. Conversion from c# to access is very simple

DTS.Package2Class package =

new

Hi

I am using DTS with C# to transfer txt information into SQL 2000. We can change the path and also the file name during runtime. Here is the code.

I have...

check for rows in dtproperties table

select * from dtproperties

if there are no rows in dtproperties table, then you cannot open the diagram

Hi grant the stored procedure to public so that it can be accessed from any database.

GRANT EXEC ON 'spname' TO public

http://www.sqldts.com

could be the best place for DTS related queries

http://www.sqldts.com

Thanks Frank / Prasad

It worked out with temp table creation