SQL Server Performance

DTS Packages

Discussion in 'SQL Server DTS-Related Questions' started by preethi.talapanuri, Mar 30, 2007.

  1. preethi.talapanuri New Member

    Hi everyone

    We are migrating the databases from 2000 to 2005. what we are
    doing is ......... just migrating the databases. but not the DTS
    packages. we are saving the DTS packages as .dts on the
    application server. and we are trying to execute these .dts
    files using dtsrun. we place this dtsrun command in a batch file
    and schedule them using windows scheduled task.

    what my doubt is as these DTS packages upload some data on to the
    databases which are in sql 2005........ do we need to use the
    dtexec o0r dtsrun will do.

    thank you in advance
  2. shashank sharma New Member

  3. MohammedU New Member

    You can't run the dts packages without installing DTS add-ins or migrating these dts packages to SSIS packages....
    dtexec used to execute SSIS packages where as dtsrun used to execute dts packages...

    Feature Pack for Microsoft SQL Server 2005 - November 2005
    Microsoft SQL Server 2000 DTS Designer Components


    All postings are provided “AS IS” with no warranties for accuracy.
  4. satya Moderator

    IMHO & exp. its better to rewrite the logic with SSIS rather than spending time to migrate the DTS packages, if you have very few then its fine otherwise you might be wasting lot of time.

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    This posting is provided AS IS with no rights for the sake of knowledge sharing. The greatest discovery of my generation is that a human being can alter his life by altering his attitudes of mind.
  5. preethi.talapanuri New Member

    thanks guys. I started rewriting the packages in SSIS. This is much easier than wasting time to migrate.

    thank u again for the help
  6. MohammedU New Member

    You got the point <img src='/community/emoticons/emotion-1.gif' alt=':)' /><br /><br />MohammedU.<br />Moderator<br />SQL-Server-Performance.com<br /><br />All postings are provided “AS IS” with no warranties for accuracy.<br />

Share This Page