Hi
I have a data pump , I have a Active X Script to populate
the destintation Table
I want to insert rows based on a condition
for eg Only If the salary >100000 I want to insert a row
other wise I want to fetch the next row and do the same
check and so on
The problem is the destination has NOT NULL Columns
So when I run the package it is saying cannot insert nulls
apparently its trying to insert a dummy row and since Not
null columns exist its throwing a exception
Any one knows how to debug this ?
PS: I cannot handle this in query need to do it in activex
Script
Thanks
Sunny

Can you specify the condition in the SourceSQLStatement of the datapump i.e.

SELECT <col list>
FROM TABLE
WHERE salary > 100000

That way you only have rows the qualify to begin with.

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


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

No I cant I just gave eg there There is lot of weird
business logic going on I prefer to handle it in active x
script

OK this works for me

CREATE TABLE Source(ID INT identity(1,1) ,salary money)
CREATE TABLE Destination(ID INT, salary money NOT NULL)

INSERT into Source(salary) VALUES(10)
INSERT into Source(salary) VALUES(110000)


ActiveX looks like this

Function Main()

IF DTSSource("salary") > 100000 THEN

DTSDestination("ID") = DTSSource("ID")
DTSDestination("salary") = DTSSource("salary")
Main = DTSTransformStat_OK

ELSE

Main = DTSTransformStat_SkipInsert

END IF

End Function

make sure you are also not running into this


Problems With IDENTITY() and the DataPump task.
(http://www.sqldts.com/default.aspx?293)

--

----------------------------

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


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