EDT Worked examples

In this tutorial we will help you complete the task of importing or processing data from a Microsoft Excel workbook file. We will demonstrate how to configure a task to complete this goal, and be able to quickly repeat the process time and time again

In this tutorial we will help you complete the task of validating and processing data from a Microsoft Excel Workbook File using a Microsoft SQL Stored Procedure.We will demonstrate how to configure a task to complete this goal, and be able to quickly repeat the process time and time again.

In this first example we show you how to import or update existing data in a table, later we will create how-to examples to show you how to send the data to a stored procedure.

In this tutorial we will help you complete the task of validating importing data from Multiple Microsoft Excel Workbooks. One single task will handle importing multiple Excel Workbooks with varying filename from a single folder/directory. We will demonstrate how to configure a task to complete this goal, and you will able to quickly repeat the process time and time again.

In this tutorial we will help you complete the task of importing or processing data from a Comma Separated Value (CSV) file. We will demonstrate how to configure a task to complete this goal, and be able to quickly repeat the process time and time again.

In this tutorial we will help you complete the task of importing or processing data from multiple worksheets from one Microsoft Excel workbook file. We will demonstrate how to configure a task to complete this goal, and be able to quickly repeat the process time and time again.