Using query to copy data from one DASP db to another

I have 2 databases with DASP. I need a subset of the first database to transfer into the second on a weekly basis. I have tried using Import/Export with a query to do this, but I get the error that I don't have permissions to do it. Is there a way to do what I need without copying the entire table and then subsetting from it?? Thanks for any help or insight!

 

There should be a way to do this. If you add the same "additional user" to both databases, you should be able to perform a SELECT-INSERT to transfer the data.

not sure about dts.


Joel Thoms
DiscountASP.NET
http://www.DiscountASP.NET

 

Joel: DASP won't let me add the same additional user to both. It returns error message: "*User name already exists". Any other suggestions? I'll try anything!

Ali Ibarguen
BluePrint PM, LLC
blueprintpm.com

 

Here's the KB article on how to assign another user to your SQL 2000 database. This assumes of course that your 2 databases are from the same hosting account, which means that they're on the same SQL server.

http://kb.discountasp.net/article.aspx?id=10343

Aristotle

DiscountASP.NET
www.DiscountASP.NET