Accessing DTS properties via TSQL

#1

Can anyone tell me how to access DTS properties (such as global
variable values) via TSQL?

Examples would be nice.

Thanks

#2

Probably not in the way you would want but you need to look up the
sp_OA* family of stored procedures

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

"BLS" <bigluckysmile (AT) gmail (DOT) com> wrote

Quote:

Can anyone tell me how to access DTS properties (such as global
variable values) via TSQL?

Examples would be nice.

Thanks

#3

Hello BLS,

DTS doesn't run within TSQL. Are you trying to execute some TSQL from within
a DTS package and have the TSQL use some global variable.

If so you can set the SQL in your execute sql task from an activex script
component. In here you can build the TSQL with the value of the global variable.

Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons

Quote:

Can anyone tell me how to access DTS properties (such as global
variable values) via TSQL?

Examples would be nice.

Thanks

#4

Simon Sabin wrote:

Quote:

Hello BLS,

DTS doesn't run within TSQL. Are you trying to execute some TSQL from within
a DTS package and have the TSQL use some global variable.

If so you can set the SQL in your execute sql task from an activex script
component. In here you can build the TSQL with the value of the global variable.

What I would like to do is access a DTS global variable inside a TSQL
task. I'd like to set its value, etc, only not via activex but using
TSQL.

#5

Using the ExecuteSQL task you can assign values from a SQL Statement to
Global Variables.

Is this what you want?

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

"BLS" <bigluckysmile (AT) gmail (DOT) com> wrote

Quote:

Simon Sabin wrote:
Hello BLS,

DTS doesn't run within TSQL. Are you trying to execute some TSQL from within
a DTS package and have the TSQL use some global variable.

If so you can set the SQL in your execute sql task from an activex script
component. In here you can build the TSQL with the value of the global variable.

What I would like to do is access a DTS global variable inside a TSQL
task. I'd like to set its value, etc, only not via activex but using
TSQL.

#6

Allan Mitchell wrote:

Quote:

Using the ExecuteSQL task you can assign values from a SQL Statement to
Global Variables.

Is this what you want?

Yes. Do you know the syntax for how to assign values to DTS Global
Variables in that way?

#7

Have a look at this article

http://www.developmentnow.com/g/103_...After-Move.htm

--

Allan Mitchell
http://wiki.sqlis.com | http://www.sqlis.com | http://www.sqldts.com |
http://www.konesans.com

"BLS" <bigluckysmile (AT) gmail (DOT) com> wrote

Quote:

Allan Mitchell wrote:
Using the ExecuteSQL task you can assign values from a SQL Statement to
Global Variables.

Is this what you want?

Yes. Do you know the syntax for how to assign values to DTS Global
Variables in that way?

#8

Thanks! I believe that is exactly what I was looking for.

Much appreciated.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Accessing DTS properties via TSQL

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

Accessing DTS properties via TSQL - 12-29-2006 , 02:25 PM

Re: Accessing DTS properties via TSQL - 12-29-2006 , 03:28 PM

Re: Accessing DTS properties via TSQL - 12-31-2006 , 04:45 PM

Re: Accessing DTS properties via TSQL - 01-01-2007 , 03:09 PM

Re: Accessing DTS properties via TSQL - 01-01-2007 , 03:23 PM

Re: Accessing DTS properties via TSQL - 01-01-2007 , 07:21 PM

Re: Accessing DTS properties via TSQL - 01-02-2007 , 04:47 PM

Re: Accessing DTS properties via TSQL - 01-02-2007 , 05:17 PM