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...]
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...]
Removing _x0022_ Character Issue in SQL Server and SSIS
Just recently after an a production database upgrade to a 64-bit SQL Server 2008 R2 RTM (from SQL 2000), the same SSIS 2008 package that exports data from SQL Server 2000 to a flat file (csv/txt) started to wrap all data fields with _x0022_ hexadecimal characters. The CSV file that was extracted is not totally worthless especially if it's already taken hours to produce that file. We can … [Read more...]