custom execute sql ssis task
Posted on 2014-03-13
I need to get data from a non ODBC database into SQL for various reporting processes. The non ODBC database does have a way to query the data via VB.NET code, but my report writer isn't familiar enough with .NET coding to get at the data that way.
I am thinking the best solution is to create an custom "Execute SQL Tasks" for SSIS that others can use to pull data from the proprietary database into SQL to do their work.
Does anyone have any good example of how to create a custom SSIS task. Specifically in mimicking the current "Execute SQL Task" that current exists. Can I inherit directly from that object?
Thanks in advance...