Hi All,

I have an application that uses several stored procedures. I want to create
an installation program for this application and within the installation
script add the stored procedures to the database.

I have created executables from DTS packages and called them from an
installation script before and it worked fine. I want to create a DTS
package that takes the stored procedures and puts them in the database.

Is there any way to do this?

Thanks in advance,
Gloria

Sure, although I am not really sure this is the way to do it.

Create a script of the procs to run in
In your package call osql in the Execute process task
Pass in the necessary parameters pointing to what files to execute etc
like this

How to manipulate the Execute Process task.
(http://www.sqldts.com/default.aspx?251)


"Gloria" <Gloria (AT) discussions (DOT) microsoft.com> wrote

Thanks for your quick response.
Is there a better way to load stored procedures into a database from an
installation script?
Could you point me in the direction of the documentation of this process?

Thanks again,
Gloria

"Allan Mitchell" wrote:

The documentation of my process would be to

Right Click on the database
All Tasks
Generate SQL Script

Save the file off and call if from OSQL.

Allan

"Gloria" <Gloria (AT) discussions (DOT) microsoft.com> wrote

Thank you very much.
I will give that a try!

Gloria

"Allan Mitchell" wrote: