1 / 15

SAP & SQL Server 2005 Integration Services Integration (Entry level)

SAP & SQL Server 2005 Integration Services Integration (Entry level). Microsoft Corporation SAP-Microsoft Competence Center (Tokyo). Landscape. SAP. Region info table (T005U). Flat text file. SAP R/3 SAP ERP. 3. SQL Server Integration Services package development.

cinnamon
Download Presentation

SAP & SQL Server 2005 Integration Services Integration (Entry level)

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. SAP & SQL Server 2005 Integration ServicesIntegration (Entry level) Microsoft CorporationSAP-Microsoft Competence Center (Tokyo)

  2. Landscape SAP Regioninfo table(T005U) Flat text file SAP R/3SAP ERP

  3. 3. SQL Server Integration Services package development • Creating an Integration Services project • Creating an ADO .NET connection for SAP • Designing SAP table extract and data load • Debugging the package • Executing the package

  4. SQL Server BI dev studio 3-1. Creating an Integration Services project

  5. SQL Server BI dev studio 3-2. Creating a new ADO .NET connection for SAP

  6. SQL Server BI dev studio 3-3. Designing SAP table extract and data load

  7. SQL Server BI dev studio 3-3. Designing SAP table extract and data load

  8. SQL Server BI dev studio 3-3. Designing SAP table extract and data load

  9. SQL Server BI dev studio 3-3. Designing SAP table extract and data load

  10. SQL Server BI dev studio 3-3. Designing SAP table extract and data load

  11. SQL Server BI dev studio 3-3. Designing SAP table extract and data load

  12. SQL Server BI dev studio 3-4. Debugging the package

  13. SQL Server BI dev studio 3-5. Executing the package

  14. Disabling data validation • ADO provider by default does not handle garbage values in the DATS/TIMS column. There is a workaround: • “SELECT * FROM TABLE” should instead be “SELECT * FROM TABLE OPTION ‘disabledatavalidation’” •  The DATS/TIMS column will be exposed as Strings instead of .NET DateTime

More Related