Results 1 to 8 of 8

Thread: DTs in Sql Server2005

  1. 03-05-2007, 04:27 AM #1
    chachva
    chachva is offline Registered User
    Join Date
    Mar 2007
    Posts
    1

    DTs in Sql Server2005

    Hello evrybody..........
    hope u all r doing fine ...well i hve a little problem that i hve installed sql server2005 express edition on my machine and now i just want to import my clients database which is on Acess but m not getting DTS wizard anywhere in 2005 edition so what should i do....infact i found the exe of dtswizrd in program files microsoft sql server folder but when i hit that exe it throws error that one of the file is could not be loaded it is SQLSVC.RLL file...so what should i do shall i reinstall my package ???and even m not confirmed that the free packageof 2005 which i hve downloaded by download center..wheather microsoft gives the whole package or not???like because here in my package i don't find DTS wizard anywhere like we have in 2000 package....
    So does anybody help me Plz?????
    hope for a positive reply from all u experts .........
    thnks
    Reply With Quote Reply With Quote
  2. 03-05-2007, 09:34 AM #2
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    You need install SSIS which replaced dts.
    Reply With Quote Reply With Quote
  3. 03-08-2007, 11:52 AM #3
    mmg@interleaf.i
    mmg@interleaf.i is offline Registered User
    Join Date
    Mar 2007
    Posts
    1
    You don't need to install SSIS. A 2000 DTS script will run on 2005 if you have these dll loaded

    INSTALLATION NOTES FOR DATA TRANSFORMATION SERVICES (DTS)
    ---------------------------------------------------------

    dtsffile.dll
    dtspkg.dll
    dtspump.dll
    axscphst.dll
    sqlresld.dll

    The sqlunirl.dll file should reside in the system folder (i.e., \winnt\system32 or \windows\system).

    Just run DTS from a command line and it will tell you if any of the dlls are missing
    Reply With Quote Reply With Quote
  4. 03-09-2007, 10:38 AM #4
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    True, but you can't create new package nor edit old ones with them.
    Reply With Quote Reply With Quote
  5. 03-26-2007, 12:53 AM #5
    Michael Raven
    Michael Raven is offline Registered User
    Join Date
    Jan 2007
    Posts
    9
    Well, if the problem is only transfer data from Access to MSSQL then you can use 3rd party utilities, instead of manipulating with DLLs.
    Reply With Quote Reply With Quote
  6. 03-26-2007, 08:43 AM #6
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    You can install Legacy component of SQL 2005 client tool which allows you to edit existing DTS packages without converting them to SSIS.
    Reply With Quote Reply With Quote
  7. 03-26-2007, 04:16 PM #7
    cajinamaster
    cajinamaster is offline Registered User
    Join Date
    Mar 2007
    Posts
    1

    Question How can I install that Legacy?

    I saw a folder called Legacy and I can see from my Microsoft SQL Managemet Studio, Some DTS I created on SQL Server 2000 but I can't access them .
    Reply With Quote Reply With Quote
  8. 03-27-2007, 08:42 AM #8
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Did you connect as sysadmin? Should be able to edit them by right click on it and choose open.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules