August 28th, 2003, 05:08 AM
Is it essential that no one is using the database when using the Data Transformation Services ? I was wondering if I could run it during the day when users were accessing it. If I could run it during the day would the performance hit be too much for the server? I tried to schedule the DTS to run last night when no users were on,but it didn't run. there was an error message in the application log in event viewer that simply said "Status failed.Invoked on....The job failed". (I'm using SQL 2000 on Windows 2000 Server).
Last edited by Dagk; August 28th, 2003 at 05:14 AM.
August 28th, 2003, 11:20 AM
well what does your DTS package do =P
August 28th, 2003, 11:44 AM
I'm just using the DTS import/export wizard to import the entire DB.
August 28th, 2003, 12:05 PM
yea sure, why not? You're doing a snapshot I assume? I do it on my SQL servers during primetime. I tend to do transactional though but both will work.