Thread: Dts

    #1
  1. Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Location
    Scotland
    Posts
    10
    Rep Power
    0

    Dts


    Hi,

    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.
  2. #2
  3. No Profile Picture
    Average Intelligence
    Devshed Novice (500 - 999 posts)

    Join Date
    Apr 2003
    Location
    Ohio/Chicago
    Posts
    678
    Rep Power
    12
    well what does your DTS package do =P
  4. #3
  5. Junior Member
    Devshed Newbie (0 - 499 posts)

    Join Date
    Aug 2003
    Location
    Scotland
    Posts
    10
    Rep Power
    0
    I'm just using the DTS import/export wizard to import the entire DB.
  6. #4
  7. No Profile Picture
    Average Intelligence
    Devshed Novice (500 - 999 posts)

    Join Date
    Apr 2003
    Location
    Ohio/Chicago
    Posts
    678
    Rep Power
    12
    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.

IMN logo majestic logo threadwatch logo seochat tools logo