Hi,

Is it possible to have DTS tp return a "number of inserted rows".

What I want to do is

If there has been inserted some rows I would like to do one thing.
But if no rows has ben inserted i would like to do another thing.

Is this Posible??
And how if yes?

Best regards Morten

Look at using an Active Script task and grabbing the RowsComplete property
of the DataPump task. You then look at workflow

Multiple Paths in Workflow
(http://www.sqldts.com/default.aspx?218)

--

----------------------------
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



"Morten Kruse" <morten (AT) kruss (DOT) dk> wrote

I have a DTS package containing a 'Execute SQL Task' within the task i have
T-SQL to look for the number of affected rows. Example...

DECLARE @AffectedRows int
INSERT _TempTable
SELECT
stuff FROM table
WHERE stuff NOT IN (select stuff from OtherTable)

-- How many rows were affected..?
SELECT @AffectedRows = @@ROWCOUNT
-- If something happened perform next action
IF @AffectedRows > 0
BEGIN.........

--
HTH
Ryan Waight, MCDBA, MCSE

"Morten Kruse" <morten (AT) kruss (DOT) dk> wrote

Oh so you are using that task

OK So you get the amount of records affected yes ?

Is this "Perform Next action" another task in DTS or another SQL 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



"Ryan Waight" <Ryan_Waight (AT) nospam (DOT) hotmail.com> wrote