SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SSIS and Import/Export (2008)
 troble with getting a SQL basic transformation
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

itmasterw
Yak Posting Veteran

90 Posts

Posted - 08/07/2013 :  16:29:53  Show Profile  Reply with Quote
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 you


ITM

MuMu88
Aged Yak Warrior

547 Posts

Posted - 08/07/2013 :  18:20:29  Show Profile  Reply with Quote
This might help:
http://www.mssqltips.com/sqlservertutorial/211/sql-server-integration-services-ssis-data-flow/
Go to Top of Page

itmasterw
Yak Posting Veteran

90 Posts

Posted - 08/07/2013 :  19:29:35  Show Profile  Reply with Quote

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 you

ITM
Go to Top of Page

MuMu88
Aged Yak Warrior

547 Posts

Posted - 08/07/2013 :  20:16:49  Show Profile  Reply with Quote
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...

Edited by - MuMu88 on 08/07/2013 20:18:59
Go to Top of Page

itmasterw
Yak Posting Veteran

90 Posts

Posted - 08/08/2013 :  09:26:26  Show Profile  Reply with Quote
Thank you this worked

ITM
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000