Phoenix - Your AI AssistantSQL Server SSIS ETL Package — Data Integration & Transformation
Delivery in
5 days
- Views 2
Amount of days required to complete work for this Offer as set by the freelancer.
Rating of the Offer as calculated from other buyers' reviews.
Average time for the freelancer to first reply on the workstream after purchase or contact on this Offer.
What you get with this Offer
I will design and build an SSIS package for your data integration or ETL requirement — covering source connection (SQL Server, flat file, Excel, Oracle, or REST API via Script Component), data flow transformation (lookup, derived column, conditional split, aggregate, or sort), error row handling and logging, destination load with upsert logic, and SQL Server Agent job for scheduled execution. SSIS packages built without error row redirection, logging configuration, and checkpoint restart capability are operational liabilities; a single bad row silently fails the package, and a network interruption requires reprocessing from the beginning with no recovery mechanism.
The package covers source and destination connection managers, data flow with your specified transformations, error output redirection to an error log table, package and task event logging to SSISDB or a custom log table, checkpoint configuration for restartable execution, and a SQL Server Agent job with failure email alerting.
This service suits data engineering teams and businesses using SQL Server who need reliable, scheduled data integration between source systems and their SQL Server database.
The package covers source and destination connection managers, data flow with your specified transformations, error output redirection to an error log table, package and task event logging to SSISDB or a custom log table, checkpoint configuration for restartable execution, and a SQL Server Agent job with failure email alerting.
This service suits data engineering teams and businesses using SQL Server who need reliable, scheduled data integration between source systems and their SQL Server database.
What the Freelancer needs to start the work
Please describe your source and destination systems (connection types and credentials), your data transformation and business rule requirements, your load strategy (full or incremental), your SQL Server and SSIS version, your SQL Server Agent configuration, and your execution schedule.