Can Transform Task Select Based On a Column Value? 1

[JohnBates]

hi experts,

This is 2000.

I'm importing a text .txt file into a table.

Very simple but I want to check the value of the text file's first column - if it begins with '9', import it else exclude it.

Can this be done when the connection is table/view, not SQL query?

Thanks, John

 

[AlexCuse]

I have never done this, but perhaps you could try something like this:

Function Main()
	
If Left(DTSSource("MyCol"), 1) = "9" then
     DTSDestination("MyCol") = DTSSource("MyCol")
     DTSDestination("MyCol2") = DTSSource("MyCol2")
     'etc...

End If

Main = DTSTransformStat_OK

End Function

I think this will move your rows across ONLY if the condition is met.

If I need something like this done, I bring it into a staging area first so that I can use a SQL Query to filter what I want to move into final table, but this might work.

Let me know how it turns out.

Alex

Ignorance of certain subjects is a great part of wisdom