• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 294
  • Last Modified:

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

 
0
lblinc
Asked:
lblinc
  • 4
  • 4
1 Solution
 
nicolasdiogoCommented:
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
 
lblincAuthor Commented:
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
 
nicolasdiogoCommented:
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
Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

 
lblincAuthor Commented:
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
 
lblincAuthor Commented:
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
 
nicolasdiogoCommented:
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
 
lblincAuthor Commented:
btw -  thanks for the query on how to see the scripts.  
0
 
nicolasdiogoCommented:
you are welcome.
0

Featured Post

VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

  • 4
  • 4
Tackle projects and never again get stuck behind a technical roadblock.
Join Now