SSIS use

Hi Adele,

Could you please elaborate on this question as to what is required so we can better assist you?

Regards,
Subject7 Team

We will be receiving a files with a lot of data from the different agencies (probably in Excel format?), and we need to validate this data represented in a different ways, such as line graph, bar chart, pie chart, etc. 

Thank you,

Adele

Hi Adele,

Thank you, so how is this related to SSIS ?

Would you be able to provide some typical cases/scenarios so that we know what they require?

Regards,
Subject7 Team

We will be getting a lot of files probably in CSV format from the  different Government agencies, we need to test the files and make sure  that the data will end up in the right tables and will display properly as this data visualization in UI

Just to be sure I get this right, does the following pseudo-code sum up what you want to do: 

1. Read many files in CSV
2. Compare the data to rows/columns in different databases
3. Check a web application to make sure data is correctly shown

Few questions: 

1. Is the above a correct summary of what you want to do? If not, please elaborate further. 
2. What is the target database? (Postgres/Oracle/MySQL). 
3. Is the target data visualization UI a web application?  
4. How are you going to get the CSV files? And how frequent? 

This is correct, that what we want to do.

The target database is Oracle/MySQL.

The data visualization UI is a web application.

We will be getting the CSV files monthly.

Thank you!

Our platform currently supports these operations.

if you want, you can prepare a sample scenario and we can jump on a call to illustrate how it works. 

Please let us know how we can further assist. 

Will do.  And then, should I let you know when it is ready, so we could set the call for illustration?

Thanks a lot.

Adele