asked on

where do these live? inside which Directory? i.e. C:\Program Files\Microsoft SQL Server\ ??

Very simply... where do the following live after they are created?

1) DTS Scripts - Where does SQL Server save the DTS Scripts after creating using the SQL server front-end UI ?

2) Stored Procedures - What about these? Is there a specific directory I should know about?

3) Other types of Scripts

Is it in any of these dirs here? C:\Program Files\Microsoft SQL Server\80\Tools\Scripts or C:\Program Files\Microsoft SQL Server\80\Tools\Templates

ASKER CERTIFIED SOLUTION

nicolasdiogo

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

lblinc

ASKER

nicolas, the problem i'm having is this: i have a few .dts scripts from a previous project that I attempted to open (right-click on Data Transformation Services, then select Open Package...) I proceed to browse to the directory where I temporarily saved these .dts files, but then when i open any of them i get a DTS Designer Error first before it displays the colorful view of the DTS package. Here is the error:

"There was a problem retireving the list of OLE DB providers."

I then click 'Ok' and the package opens for viewing the dts package. When opening the package in the Slect Package window... it says: Slelect the package to load. The File selected has multiple DTS packages or package versions.

nicolasdiogo

the odbc connections how are they defined,

some developer like creating udl files (universal data link) which can be ported to any machine as they only have definitions for connections. And DTS refer to these by their locaiton on the OS.

the question about: Slelect the package to load
DTS keeps versions of the package, thus we can assume that the latest would be the most up to date.
;-)

lblinc

ASKER

I know where they exist in the registry. All the drivers seem to be present. HKEY_LOCAL_MACHINE/SOFTWARE/ODBC.INI AND HKEY_LOCAL_MACHINE/SOFTWARE/ODBCINST.INI

The exact error, which occurs just before the DTS design screen appears....

DTS Designer Error

There was a problem retrieving the list of OLE DB providers.

lblinc

ASKER

nicolas - someone solved this issue for me... on another post. not sure how to resolve this, or if to accept your answer, give you these points and move on... any thoughts?

this was the other link.. https://www.experts-exchange.com/questions/21893060/opening-a-DTS-Package-error.html

nicolasdiogo

i agree with you that i have not helped on this one.

maybe the next.

you may leave the post open until it expires, or check the forum guidance to close it and have your points back into your account.

that is another one that i learn.

best of luck,

Nicolas

www.brainpowered.net

lblinc

ASKER

btw - thanks for the query on how to see the scripts.

nicolasdiogo

you are welcome.