Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
itmasterw
Yak Posting Veteran
90 Posts |
 Posted - 2013-08-07 : 16:29:53
|
| 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.Thank youITM |
|
|
MuMu88
Aged Yak Warrior
549 Posts |
Posted - 2013-08-07 : 18:20:29
|
| This might help:http://www.mssqltips.com/sqlservertutorial/211/sql-server-integration-services-ssis-data-flow/ |
 |
|
|
itmasterw
Yak Posting Veteran
90 Posts |
Posted - 2013-08-07 : 19:29:35
|
| 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. Any other ideas would be appreciated.Thank youITM |
|
|
|
MuMu88
Aged Yak Warrior
549 Posts |
Posted - 2013-08-07 : 20:16:49
|
| Choose "OLE DB Source" Open "OLE DB Source Editor"Setup your Source under "OLE DB Source Manager"Choose "Data Access Mode" to be "SQL Command"Click on "Build Query" to create your query.Choose "OLD DB Destination"and go through the steps above... |
|
|
|
itmasterw
Yak Posting Veteran
90 Posts |
Posted - 2013-08-08 : 09:26:26
|
| Thank you this workedITM |
|
|
|
|
|
|
troble with getting a SQL basic transformation