?
Solved

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

Posted on 2006-06-19
8
Medium Priority
?
283 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
Percona Live Europe 2017 | Sep 25 - 27, 2017

The Percona Live Open Source Database Conference Europe 2017 is the premier event for the diverse and active European open source database community, as well as businesses that develop and use open source database software.

 

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

International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
In the first part of this tutorial we will cover the prerequisites for installing SQL Server vNext on Linux.
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.
Suggested Courses

800 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