Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

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

Posted on 2006-06-19
8
Medium Priority
?
291 Views
Last Modified: 2011-09-20
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

 
0
Comment
Question by:lblinc
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 4
  • 4
8 Comments
 
LVL 5

Accepted Solution

by:
nicolasdiogo earned 375 total points
ID: 16937735
hi,

if you want to see your scripts, where they are stored then run this query;

select obj.name , body.text

from
  sysobjects obj
, syscomments body

where obj.id = body.id

you will find most db objects,

DTS will depend on how you choose to seve them, metadata , in database or file?
0
 

Author Comment

by:lblinc
ID: 16937907
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.  

 
0
 
LVL 5

Expert Comment

by:nicolasdiogo
ID: 16938872
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.
;-)
0
Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 

Author Comment

by:lblinc
ID: 16942840
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.
0
 

Author Comment

by:lblinc
ID: 16954818
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..     http://www.experts-exchange.com/Databases/Microsoft_SQL_Server/Q_21893060.html
0
 
LVL 5

Expert Comment

by:nicolasdiogo
ID: 16956271
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
0
 

Author Comment

by:lblinc
ID: 16959803
btw -  thanks for the query on how to see the scripts.  
0
 
LVL 5

Expert Comment

by:nicolasdiogo
ID: 16964714
you are welcome.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
In part one, we reviewed the prerequisites required for installing SQL Server vNext. In this part we will explore how to install Microsoft's SQL Server on Ubuntu 16.04.
Via a live example, show how to extract information from SQL Server on Database, Connection and Server properties
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

636 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question