Solved

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

Posted on 2006-06-19
8
273 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 125 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
Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

 

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

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!

Question has a verified solution.

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

When you hear the word proxy, you may become apprehensive. This article will help you to understand Proxy and when it is useful. Let's talk Proxy for SQL Server. (Not in terms of Internet access.) Typically, you'll run into this type of problem w…
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to shrink a transaction log file down to a reasonable size.

726 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