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 |
|
lcchs
Starting Member
4 Posts |
 Posted - 2011-07-28 : 11:42:30
|
| Hello Experts,1. My company wants to extact data from SQL server 2008 using SSIS tool, I have never done that before and want to learn this Business Intelligence tool so I can extract data from SQL database and create and execute the packages.I would appreiate if you advise me any link , document, videos for step by step process to create these packages and execute it.2. I also need to find out that before I actualy start building a package, do I need to create an ODBC connection here. For more understanding on the question, this is the landscape I am working on:I have several SAP functional modules (All transactional records)---->Data goes to SQL server database-----> Will use SSIS ETL tool to extract data into datawarehouseing----> will build reports using SAP Business Objects.I would appreciate if you advise me that what kind of connections do I need to create wheile I am extracting data from SQL server into SQL datawarehouse using SSIS tool.Your help will be much appreciated.Regards |
|
|
Samadhi69
Starting Member
20 Posts |
|
|
|
|
|
SSIS ETL