filter from the datasource

#1

Hi..
I need to extract all employees with state='CA' from a sqlServer 2005.

Solution so far:
What we have done is created a
1) "DataReaderSource" to the DB
2) Then a "conditional split" filters the state="CA"

My questions is....
is it that I first get all the data from the DB and then discard all that is
not "CA".

is this the correct method, or is there a way to extract on the state='CA'
from the DB?

Any help is deeply appreciated.
Nalaka

#2

Hello Nalaka,

You need an OLEDB connection to SQL Server.
You need an OLEDB Source Adapter

In your SQL Statement you say

SELECT <column List> FROM <table> WHERE state = 'CA'

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Quote:

Hi..
I need to extract all employees with state='CA' from a sqlServer 2005.
Solution so far:
What we have done is created a
1) "DataReaderSource" to the DB
2) Then a "conditional split" filters the state="CA"
My questions is....
is it that I first get all the data from the DB and then discard all
that is
not "CA".
is this the correct method, or is there a way to extract on the
state='CA' from the DB?

Any help is deeply appreciated.
Nalaka

#3

Thanks

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote

Quote:

Hello Nalaka,

You need an OLEDB connection to SQL Server.
You need an OLEDB Source Adapter

In your SQL Statement you say

SELECT <column List> FROM <table> WHERE state = 'CA'

Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Hi..
I need to extract all employees with state='CA' from a sqlServer 2005.
Solution so far:
What we have done is created a
1) "DataReaderSource" to the DB
2) Then a "conditional split" filters the state="CA"
My questions is....
is it that I first get all the data from the DB and then discard all
that is
not "CA".
is this the correct method, or is there a way to extract on the
state='CA' from the DB?

Any help is deeply appreciated.
Nalaka

#4

Hello Nalaka,

Welcome!

Regards,

Peter Yang
MCSE2000/2003, MCSA, MCDBA
Microsoft Online Partner Support

When responding to posts, please "Reply to Group" via your newsreader so
that others may learn and benefit from your issue.

================================================== ===

This posting is provided "AS IS" with no warranties, and confers no rights.

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

filter from the datasource

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

filter from the datasource - 02-22-2006 , 01:28 PM

Re: filter from the datasource - 02-22-2006 , 07:45 PM

Re: filter from the datasource - 02-23-2006 , 04:55 PM

Re: filter from the datasource - 02-23-2006 , 07:42 PM