Working with Transaction Cotainers for Jet Oledb provider @SSIS

Issue: If you try to user transaction container, and if your data flow task contains Jet oledb provider then transactions will not work.

Solution: User Excel or other source in place of Jet oledb provider.

Decimal points issue while working with Excel Source @SSIS

Issue: In SSIS if you use Excel source in Data flow and if you have column in your excel file with decimal points then sometime during SSIS import fetched decimal values from excel are different from actual decimal values.

E.g In Excel, Amount column has 19.31 then while doing SSIS import, it will fetch 19.30000009.

Solution:

-Try to use Jet Oledb provider in place of Excel source

- Also provide EXTEND PROPERTIES value as "EXCEL 8.0;IMEX=1" in Jet Oledb provider.

Which are the Business Intelligence Softwares?

Microsoft business intelligence tools are well up to market requirements and they are :

• SQL Server Reporting Services (SSRS)
• SQL Server Analysis Services (SSAS)
• SQL Server Integration Services (SSIS)

Why do we need BI tools?

• Facts of survey done by IDC (a sister company to CIO's publisher).

• According to the survey:
• The amount of data is growing rapidly. 
• Accessing unstructured data is difficult but increasingly necessary to decision making
• To manage the avalanches of data , business intelligence tools are becoming more widespread.
• Timely business intelligence has become mission critical to many enterprises

Solutions for all of the above listed problems is Business Intelligence tools.