Importing Partial Table using SSIS...

[bmgmzp]

I want to use SSIS to import a table from access to SQL Server. The table already exists in SQL Server so it wont need to be created on the import. However, at this point I dont want to import the whole table over... how would I filter the source table so that I only import records based on a certain customer?

Would it be best just to create a view in access and import from that or is there a more effecient way to do it in SSIS. I have quite a few tables that i'm going to need to do this on.

 

[MDXer]

in your destination use a SQL command rather than Table or view. THen you can input the exact statement you need executed. If this value needs to be dynamic you can pass the variable by using a ?.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck

 

[bmgmzp]

Thanks! Just to clarify... you want me to put a SQL command in my DESTINATION rather than my SOURCE?

 

[MDXer]

no you put the sql command in your source to limit the data. if the data is already in your data flow then you can use a conditional split to filter out the needed data.

Paul
---------------------------------------
Shoot Me! Shoot Me NOW!!!
- Daffy Duck