Hi, where do I ask SSIS related questions

Hi, Can you please direct me to the correct news group.
In case this is the correct place......
Problem:
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.
NalakaAFAIK there is no SSIS group created yet, try the DTS one instead
microsoft.public.sqlserver.dts
http://sqlservercode.blogspot.com/|||Try:
microsoft.public.sqlserver.integrationsvcs
-Sue
On Wed, 22 Feb 2006 09:22:44 -0800, "Nalaka"
<nalaka12@.nospam.nospam> wrote:

>Hi, Can you please direct me to the correct news group.
>In case this is the correct place......
>Problem:
>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 i
s
>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
>