hi
I wrote an activex script in the data pump. I have a flag that will be set depending on the column value in the text file. Based on the flag, I was to transform the data from source to destination. So, the code looks like this

Function Main(
Flag = GetTheColumnValu
If Flag = 1 The
DTSDestination(1) = DTSSource(1
....
...
End I
End Functio

So, whenever the Flag is not 1, the data should not be transferred. But, the column 1 in the destination is a primary key
so, the datapump is throwing an exception, primary key cann't be null....blah blah..

Am I doing some thing wrong? How can I avoid the transformation if the flag is not 1
any ideas are appreciated

thanks
Sreenat

OK

So you have a text file that perhaps looks like

MyCol
1
2
3
4
5


You want to move all rows that are <> 1


I know this isn't your exact scenario but the principal is the same

In your Active Script transform you need to do this

Function Main()

select case DTSSource("MyCol")

case "1"

Main = DTSTransformStat_SkipInsert

case else

DTSDestination("MyCol") = DTSSource("MyCol")

Main = DTSTransformStat_OK

end select

End Function



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
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


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

was to transform the data from source to destination. So, the code looks
like this:

Thanks Allan
Good Suggestion.

In message <9028F81C-A3EE-4501-9495-946A2BB791C3 (AT) microsoft (DOT) com>,
Sreenath <Sreenath (AT) discussions (DOT) microsoft.com> writes
Maybe this will help-

Excel treats First Row of Data as Headers
(http://www.sqldts.com/Default.aspx?255)

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

Thanks for the reply, we thought the same but unfornately it is not and the
behaviour is weird.

Detailed description:
In my excel file, the first few rows (6) are blanks and the next 3 rows were
headers and from 10row the data starts. If numerical value exists for that
cell, then the value will be numeric otherwise it will be "--". We found
that the format cell of those columns is Generic.
But, in the DataPump source screen preview, we could see only some of the
numeric values other numeric values are blanks. If you want I can send you a
screen short of the file and preview in data pump.

thanks,
Sreenath


"Darren Green" wrote: