Hi, I am new to SSIS, and trying to learn, but I am trying to run a simple transformation and I cannot find this anywhere. I am just trying to bring in a text file to a table (basicly a temp table). Then I want to run query and send the results to another table. I have successfuly brought in the data and populated the table, but I can not find how to do the secound part. I also would like to do all this in one SSIS package.
Unfortunately this does not show how to insert a query. I want to query the table that I populated so that what I insert into the second table is filtered. So for example I may want to insert all customers that are not in New York.