Certainly you can call a package from TSQL. Would you want to in your
situation?. If both of these are on the databases are on the same box
and you are simplly doing an update then probably not, a stright TSQL
statement would be better.
Don't think of a DTS package as a database object. DTS and packages can
live pretty happily without a SQL Server underneath.
You mention Events also. Have a look at this
Execute a package from T-SQL
(
http://www.sqldts.com/default.aspx?210)
How can I execute a DTS package from a trigger
(
http://www.sqldts.com/default.aspx?219)
--
----------------------------------------
Allan Mitchell (Microsoft SQL Server MVP)
www.SQLDTS.com www.SQLIS.com www.Konesans.com [quoted text, click to view] "Chakra" <nospamr_chakravarthy@hotmail.com> wrote in message
news:O06fYsaxFHA.3236@TK2MSFTNGP14.phx.gbl:
> Can a DTS package, developed though a DTS wizard ,be wrapped into a Stored
> procedure ? Would it make sense to do so at all , since the DTS itself is a
> database object , just like a Stored procedure ?
>
> The reason i am asking is because i have to update one table of one SQL
> database from another table of another SQL database, when there is an event
> in one of the applications.I am hoping to call the DTS based on the event.
> How feasible is this ?
>
> Is a DTS package callable from any program ?
>
>
> Regards,
>
> Chakravarthy
>
> R. DISCLAIMER: This e-mail and any files transmitted are confidential and
> intended solely for the use of the individual or entity to whom it is
> addressed. If you have received this email in error or are not the intended
> recipient, please notify SMNetserv Technologies Private Ltd.You are
> prohibited to copy, distribute or take any action in reliance, as the
> information contained are privileged and confidential belonging to SMNetserv
> Technologies Private Ltd. The recipient shall check this email and any
> attachments for the presence of virus as the company accepts no liability
> for any direct or consequential damages caused thereof. Any Views or
> opinions presented in this email are solely those of the author and do not
> necessarily represent those of the company.
Can a DTS package, developed though a DTS wizard ,be wrapped into a Stored
procedure ? Would it make sense to do so at all , since the DTS itself is a
database object , just like a Stored procedure ?
The reason i am asking is because i have to update one table of one SQL
database from another table of another SQL database, when there is an event
in one of the applications.I am hoping to call the DTS based on the event.
How feasible is this ?
Is a DTS package callable from any program ?
Regards,
Chakravarthy
R. DISCLAIMER: This e-mail and any files transmitted are confidential and
intended solely for the use of the individual or entity to whom it is
addressed. If you have received this email in error or are not the intended
recipient, please notify SMNetserv Technologies Private Ltd.You are
prohibited to copy, distribute or take any action in reliance, as the
information contained are privileged and confidential belonging to SMNetserv
Technologies Private Ltd. The recipient shall check this email and any
attachments for the presence of virus as the company accepts no liability
for any direct or consequential damages caused thereof. Any Views or
opinions presented in this email are solely those of the author and do not
necessarily represent those of the company.
