POLISH
TRANSFER KONTRAHENTÓW
Business
Transfer Kontrahentów - Details
Automated ETL process of transferring contractors' data from external systems to a target system.
Functions:
- Data extraction of contractors from source systems to flat files.
- Clearing and transforming Tax Id. Number into a bigint value.
- Loading consistent processed data to a target system.
- Automatization of the process of running SSIS packages according to a schedule with planned intervals.
- Release date: 20 June 2012
- Operating system: Windows Desktop.
- Development environment: MS Business Intelligence, MS SQL Server Management Studio (C#, SQL, T-SQL).
- Database: MS SQL Server, MS Access.
- Technology: SQL Server Integration Services, SQL Server Agent.
