Load Data into Azure DW using C# in an SSIS script task

Now there are a lot of reasons why SSIS needs to be leveraged for loading data into the Azure DW platform. Even though Polybase and Azure Data factory are the core criteria's, here are the templates for the SSIS script task that were leveraged to load data (full and incremental into Azure DW) for a specific customer rather than using the data flow task:
SSIS Full Load script:
SSIS Incremental Load script:

There are a few reasons for this approach and one of them being that the existing package was using a similar structure and one not to be deviated from. The other being that some key logging aspects needed to be handled in a Legacy platform that could not be decommissioned at that time.


Nicole kristen said…
Great Share! This post is much useful for us. This is very helpful for who wants to learn professional Education. This blog contains Load Data into Azure DW using C# in an SSIS script task. The Script Component has to be higher octane because it is going to be called per row of data in the data stream. You are also in the context of being able to access the data buffers directly, so you will be able to perform more tasks.
Using the script component in SSIS
kiran mai said…
You really did a great job. I found your blog very interesting and very informative.I like your way of writing and explaining the topics.SQL Server Integration Services (SSIS) is Microsoft’s business intelligence suite and ETL tool. It is a component of the Microsoft SQL Server database software that can be used to perform a broad range of data migration tasks Readmore..

Popular posts from this blog

System.ConfigurationSettings.AppSettings is Obsolete

Branding your SharePoint site in a super fast way - Emgage

Sharepoint & SSRS integration Issues