This post will demonstrate one way to add custom logging to SSIS Package. This is still considered one of the better practice that comes in handy when we need to troubleshoot SSIS packages and track progress. There's no better way to explain the concept other than giving a simple case example on how to add it to a real SSIS package. For starter, the package in this example does a simple … [Read more...]
How to Create SSIS Package in Visual Studio 2017
This posting will show you how to create an SSIS package using the legacy package deployment model in Visual Studio 2017. Please be sure before you do anything that you have SQL Server Data Tools for Visual Studio 2017 installed. You can find the SSDT download link below. Install it within the instance of your Visual Studio instead of creating a new one. With SSDT, you will be able to design … [Read more...]
How to Build SSIS Package for Different SQL Server Version with Visual Studio 2017 and SSDT
After deploying an SSIS package built with Visual Studio 2017, we encountered a surprise when running it via a Command Prompt: Pay attention to this section of error message: Description: Package migration from version 8 to version 6 failed with error 0xC001700A "The version number in the package is not valid. The version number cannot be greater than current version … [Read more...]
Configuring Asset Manager Connector in HP Connect-IT
In a Connect-It scenario, typically Asset Manager (AM) connector is used either as a source or destination of data flow. In most cases, AM connector simply works without too many changes from the default settings. But if you receive a System error 126, make sure the "dynamic library to use" is manually specified. On the AM connector, open the connector configuration wizard by right-click on the … [Read more...]
Replicate Oracle Data to SQL Server
Background HP Asset Manager SaaS data need to be transferred across customer's internal network without too much impact on the bandwidth between the two VPNs. The agreed solution is to replicate data in Oracle to a Microsoft SQL Server database in a local network. Any new records will be inserted into the new database while existing ones will be updated. The steps below are the quick way to … [Read more...]