beginner question on DTS

[beefeater267]

Hey,

I a new to DTS.... I understand the basics of many of the tasks.. however, can anyone give me guidance on how to do this?

I have records in a table that i would like to put into a text file. I know how to tranform EVERY record .... but, how can I put a condition on the record?

EX... Only transfer records where balance > 5000?

thanks

 

[MattBeas]

Hi,

You can specify a SQL Query in the Source of the transformation task. Just select the "SQL Query" radio button on the source tab instead of selecting the "Table/View". Then type the sql query in the window

For example:

SELECT * FROM [YOURTABLE] WHERE BALANCE > 5000

This will then only write out records meeting the condition

Thanks
MattBeas