Hello folks,
I want to BCP a csv file in to a table.
1. The csv file has footer records. Theres a blank line after the data
itself and the footer records start.
The number of data records can vary everyday.

My question is
How can i BCP only upto the data records.
I am quite new to DTS. Any help would be appreciated.

Thanks



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Anon nymous,

BCP does not care about content. You can import all rows and delete unwanted
afterwards. Or use Transformation task instead and fail unwanted rows.

Ilya

"Anon nymous" <jayalakshmi.anbanandam (AT) corporate (DOT) ge.com> wrote

Since I use a format file to BCP only the Columns needed for BCP, it
fails the destination type column is Dateval type.So it fails.
How can i delete the unwanted rows from a Data file in a Data
transformation Task. I wasnt successful using that for this purpose.
Would appreciate if you could elaborate.
Thanks






*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Help,

You need to test for the value being of date data type in an ActiveX
transformation:

Function Main
If Not IsDate(DTSSource("<Field Name goes here>")) Then
Main = DTSTransformStat_SkipRow
Else
Main = DTSTransformStat_OK
End If
End Function

Ilya

"Help" <help (AT) devdex (DOT) com> wrote

Hi,
Thanks..I tried to copy the required columns to the table directly.
Note: ISdate function doesnt work on the CsV dile source column. So i
used a Text function.
It says the "Encountered Invalid data value for DATEVAL column.
The destination table has the file of datatype DATETIME. So i think its
not accepting the Char value. When i commen out that line, it runs fine.
How to resolve this issue. I will be good if this is resolved. Below is
my code. Thanks for all your help.


Function Main()

If Left(DTSSource("Col001"),1) = "2" then
' DTSDestination("DATEVAL") = DTSSource("Col001")

DTSDestination("RATE") = DTSSource("Col007")
DTSDestination("DESCRIPTION") = DTSSource("Col006")
DTSDestination("RIC") = DTSSource("Col005")
DTSDestination("ID") = DTSSource("Col002")
Main = DTSTransformStat_OK
Else
Main = DTSTransformStat_SkipRow
End If
End Function






*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!