SSIS Packages To Automate Customer Specific Reports
About Client
A technology-driven medical and industrial gas company utilizes a network business model to manage the gas supply chain. This company focuses on large national clients with numerous locations who benefit from a combination of Process, People, and Product. These three elements form the unique molecular makeup of the company.
Business Challenges
Client deals with a lot of customers.Some of their customers requested to see their Total Orders/ Invoices/ Products on a daily and weekly basis.
Client’s internal team used to write SQL code to fetch specific customer data from their production database and used to do calculations to make that data presentable on a daily basis.
Venture7 Solutions/Engagement Model
We have created SSIS packages to automate customer specific report
SSIS packages allows:
- Develop a CSV file version for each individual customer
- Timestamp with the time file was generated
- Drop the table in public directory/ Shared folder
- Schedule to run on certain intervals
Tools & Technology
SQL Server
Visual Studio
Key Benefits/ Value Delivered
Following are the key benefits of Venture7 Solution:
- Viewing robust data from various sources in a single place
- Easy access to customer specific reports
- Less human resources
- Easy process to store all historical data
- Saving time
- Enhancing the accuracy of information
