Document SSIS package content.
- 2016-02-15 Updated ReadMe.md and re-uploaded files.
- 2016-01-12 Created this GitHub repo and uploaded files.
SSIS Package Reader provides free-form entry of a search term and returns all entries in the supported tasks that contain that text.
Supported tasks are:
- Data Flow Task
- Destination
- Source
- Execute SQL Task
Note: This project was completed in a private Bitbucket repository.
- Environment
- Sample dtsx package files were created using SQL Server 2008.
- SSIS Package Reader was created using Visual Studio 2012 with .NET Framework 4.5, Client Tools SDK, SQL Server Data Tools – Business Intelligence for Visual Studio 2012, and Microsoft Connectors v2.0 for Oracle and Teradata.
- Programming
- Developer's Guide (Integration Services): https://msdn.microsoft.com/en-us/library/ms136025.aspx
- Required assemblies: Microsoft.SQLServer.ManagedDTS.dll (Microsoft.SqlServer.Dts.Runtime Namespace) and Microsoft.SqlServer.SQLTask.dll (Microsoft.SqlServer.Dts.Tasks.ExecuteSQLTask Namespace)
Note: Other references are given in the source code.