Where i can find DTS in the hard drive ?

  • I need to locate where the dts are stored. It's very important.

    Thanks !

  • Please be more specific here. Are you talking about packages or the application (enterprise manager)?

  • DTS packages are kept on the server but you can save them (design package/ save package as) to a local or network drive as a visual basic package (.bas, a text file which can then be added to stuff like MSAccess to execute).

    You find them in Enterprise Manager under Data Transformation Services.

  • When packages are stored on the SQL server (standard option), they are stored in the msdb database.

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply