How to conduct unit testing in SQL server integration services using visual studio (ssdt)

Question

0.00/5 (No votes)

See more:

I have a ssis package where it reads a folder with csv files and transform those files into sql server table. at the same time those csv files are moved to an archive folder. If there is any file with wrong extension or file format against the defined sql server table, it is moved to another folder named error folder. I need to conduct unit testing to this package and validating the file format against the table without using any external tools.

What I have tried:

I have completed the extracting data and loading data into the sql server table,moving the csv files corresponding to the table into the archive folder and file with the wrong extension to the error folder.

Posted 8-Mar-20 8:19am

Member 13958707

Updated 9-Mar-20 0:44am

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

#realJSOP · Answer 1 · 2020-03-09T00:45:00

Solution 1

You could load the excel file and the database table's schema into separate ADO datatables, and then compare the schemas between the datatables. Depending on how extensive your data type discovery is during the import process, you could also validate data types.

Posted 9-Mar-20 0:45am

#realJSOP

Comments

Member 13958707 9-Mar-20 10:30am

is it done by using visual ssdt?

#realJSOP 10-Mar-20 19:07pm

You can write a ssis package or SQL Server CLR assembly to do it.

How to conduct unit testing in SQL server integration services using visual studio (ssdt)

1 solution

Solution 1

Add your solution here

Preview 0

How to conduct unit testing in SQL server integration services using visual studio (ssdt)

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us