BizTalk Adapter Pack SAP SSIS integration

1
SAP SQL Server 2005 Integration
ServicesIntegration (Entry level)
Microsoft CorporationSAP-Microsoft
Competence Center (Tokyo)
2
Landscape
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

15
(No Transcript)