Hello,

I have a file that ends with .dts. I believe this file is the actual script
for the .dts package and not the data itself.

Does anyone know how to access this file or pull it into SQL since it is not
in a DB?

Thank you!
Diane

In Enterprise Manager, right click on the Data
Transformation Services node and select Open Package. From
here you can open a .dts file which is probably a DTS
package saved as a structured storage file. With the package
open, you can do a save as and change the location to SQL
server if you prefer that your packages be in SQL Server.

-Sue

On Sun, 25 Sep 2005 11:36:04 -0700, "Diane"
[quoted text, click to view]