Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Create interface for SSIS package 1

Status
Not open for further replies.

Durbslaw

Programmer
Aug 17, 2016
2
ZA
Hi Group,
Thanks for reading and where applicable replying, I have a request in that a SSIS package that imports several different formats of flat files needs to be driven by a UI process. I am thinking of using C# and allowing the end user through a series of options to eventually map the flat file input to the predefined/existing database for importing. In a nutshell I would like to know if the process in SSDT or BIDS used for Excel to DB mapping can be included in either an application or online .NET site.
Thanks again.
 
you can do it but won't be easy to deal with all cases.

look at - download the source code and look in particular at the code for SsisEnumerator.cs ( ) which deals with the SSIS object model

You can also use EzAPI - works for most things, but does have a few limitations which will require you to change the API code if you require the use of particular functionality.

As for including in any other application. you always need to have the code executing on a fully licensed SQL Server server. You can not legally execute any SSIS code with production data if one of the following isn't true
1 - executing from BIDS
2 - executing on a fully licensed SQL Server machine


Regards

Frederico Fonseca
SysSoft Integrated Ltd

FAQ219-2884
FAQ181-2886
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top