Convert SSIS pacakge with XML task (xslt and loading data into DB) to VB.NET
$100-500 USD
着払い
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.
プロジェクトID: #3741794