Solved

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

Posted on 2006-06-19
8
250 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
  • 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
 

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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 

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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
Returning data in a different format 8 46
create insert script based on records in a table 4 15
SQL Query Syntax Join 4 34
sql query questions 2 21
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed. Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.
Viewers will learn how to use the SELECT statement in SQL and will be exposed to the many uses the SELECT statement has.

920 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

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now