Hello!

How can i start an ExecuteSQLTask?


greets

chris

It is hardly ever, if indeed ever, that you will have a package that calls
individual tasks in a user defined manner on demand. It is more common to
have the workflow determine when and how a task is executed and the package
is executed not the task itself.

What are you trying to do ?

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Christian Weber" <christian.weber (AT) siemens (DOT) com> wrote

Hello,

i have an ExecuteSQLTask with a SQLStatement.

I try to change the SQLStatement via ActiveScript (it works so far),
and then i want to start this task via ActiveScript.

greets

Chris

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> schrieb im Newsbeitrag
news:uWTT7KddDHA.2672 (AT) tk2msftngp13 (DOT) phx.gbl...

Have the ExecuteSQL task follow on using an On Success constraint from the
Active Script task.

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Christian Weber" <christian.weber (AT) siemens (DOT) com> wrote

Hello,
this is not what i want.
i have to change the sqlstatement of the ExecuteSQLTask multiple and run it
multiple.

greets

chris

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> schrieb im Newsbeitrag
news:OYTzmcddDHA.1532 (AT) TK2MSFTNGP10 (DOT) phx.gbl...

Then change the statement in a loop.

Global Variables and SQL statements in DTS
(http://www.sqldts.com/default.aspx?205)

Looping, Importing and Archiving
(http://www.sqldts.com/default.aspx?246)

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Christian Weber" <christian.weber (AT) siemens (DOT) com> wrote

Hi,

i just change the Statement within a loop.
Between each change i have to run the modified ExecuteSQLTask.

greets

chris



"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> schrieb im Newsbeitrag
news:esysT$ddDHA.3836 (AT) tk2msftngp13 (DOT) phx.gbl...

How is the changed statement stored ?
How are you firing the package ?



--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Christian Weber" <christian.weber (AT) siemens (DOT) com> wrote

Set sqltask = oPkg.Tasks("DTSTask_DTSExecuteSQLTask_1").CustomTa sk
sqltask.SQLStatement = cmd

the package is fired via a external perl-script.....

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> schrieb im Newsbeitrag
news:u6RziQedDHA.3240 (AT) TK2MSFTNGP11 (DOT) phx.gbl...

Then you can do the loop in Perl. If you MUST execute this in a DTS package
then have the task in a package by itself and simply fire the package. If
this is your only goal would you not be better simply establishing a
connection to SQL Server (No DTS) and executing the statement ?

--

----------------------------
Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org



"Christian Weber" <christian.weber (AT) siemens (DOT) com> wrote