Hi,
Below is the error message I get when I schedule my DTS. It basically drop off and recreate a table using a table with in same Database. But when I run this DTS through SEM it works fine.
DTSRun: Loading... Error: -2147287038 (80030002); Provider Error: 0 (0) Error string: The...
Hi,
I get error message " System resources exceeded " when I runs a DTS. This DTS basically opens a MS Access Database and import data into SQL7 server.
Anyone help ?
Amir
Hi Fraz,
I have read the comments regarding your query. I had worked on both produtcs and all I can add is if you are running a small scale application where volume is just couple of 000s, Response time just does not matter, data security is not a big issue and at last if you need something...
I think backup and restore is the simple solution for you. Its easy and you can easily handle it.
It's just a suggestion. Someone might give better clue.
Amir
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.