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.
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.