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 setup … [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...]