Convert SSIS pacakge with XML task (xslt and loading data into DB) to VB.NET

I have a SSIS package that needs to be rewritten to a Visual Basic .NET application.

The package contains:

- 1. Sql scripts (drop tables/create tables/exec sp)

- 2. XSL Transformation in a foreach loop container. After this, the data is loaded with a dataflow task (XML source) into a SQL server database. There is a .XSD and .XSLT for this.

- 3. Same as 2. but not a foreach loop container (just a single xml file as source).

- 4. Dataflow task (text file with one column as source, target is SQL server database table).

When running the application the user should be able to:

- Enter the datasource connection information incl. credentials (Target SQL Server database)

- Enter the two paths (folders) of the XML sources.

- Enter the path of the text source

- Run the script

- Monitor the progress

The user should also be able to schedule the .exe with connection parameters (windows scheduler).

I have finalized the SSIS package at the end of January 2012.

I should be able afterwards to change the script, so I also need the uncompiled VB source.

.NET Inginerie Microsoft Gestionarea proiectului Instalare script Shell Script Arhitectură software Testare software Visual Basic Windows Desktop

ID Proiect: #3741794

Detalii despre proiect