Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
bdrhoa
Starting Member
6 Posts |
 Posted - 2006-08-07 : 21:33:51
|
As I process a text file, I need skip rows that that have missing data. I added the following row transformation script, but it causes every row to be skipped.Function Main() Dim missingFields Main = DTSTransformStat_OK missingFields = "" if IsNull(DTSSource("Address1")) or trim(DTSSource("Address1").value) = "" then missingFields = missingFields + "Address1" Main = DTSTransformStat_SkipInsert end if End Function |
|
|
bdrhoa
Starting Member
6 Posts |
Posted - 2006-08-08 : 21:07:16
|
| I've also tried setting Main = DTSTransformStat_SkipRow.It looks like what's happening is that if one row get's skipped, all the rows get rolled back.But I've turned off transactions and still don't get any data.Any ideas would be greatly appreciated. |
 |
|
|
bdrhoa
Starting Member
6 Posts |
Posted - 2006-08-09 : 11:27:08
|
| This code is actually OK. It turned out I messed something up in the next step.I did end up putting all row transformations in 1 script. |
|
|
|
|
|
|
Skipping Rows With Bad Data