by XTIVIA | Jul 19, 2015 | Blog, Business Intelligence, Data Warehousing, Databases
SQL Server Integration Services offers a useful tool to analyze data before you bring it into your Data Warehouse. The Profile Task will store the analysis in an XML file, which you can view using the Data Profile Viewer. Before we review how to use the...
by XTIVIA | Oct 7, 2013 | Blog, Business Intelligence, Databases
At XTIVIA we often receive requests from clients who require somewhat more than the average database administration tasks. Recently I had a request to help a client pull normalized data from one object in one data source and merge that data with data in two...
by XTIVIA | May 7, 2013 | Blog, Business Intelligence
Often times when implementing data integration projects – we come across a need to implement a row/key based lookup and based on the found/not-found condition update or insert a row. I started implementing a simple data flow in SSIS. The idea was simple and has...
by XTIVIA | Mar 1, 2013 | Blog, Business Intelligence
I am not a regular ETL developer but I do “dabble” in developing code from time to time. One requirement that I come across is looping (while, for, infinite) in a job and performing a task based on condition and then going to sleep for a period of time....
by XTIVIA | Feb 12, 2013 | Blog, Databases
Started: 1:03:12 PM Progress: 2012-02-08 13:03:15.24 Source: Data Flow Task Validating: 0% complete End Progress Error: 2012-02-08 13:03:16.15 Code: 0xC0047062 Source: Data Flow Task V91MOD APIMAG [1] Description: System.Data.Odbc.OdbcException: ERROR [IM002]...
by XTIVIA | Mar 22, 2012 | Blog, Databases
As a DBMS SQL Server is a powerful, cost-effective, and simple-to-use DBMS able to service the needs of most small-to-medium size businesses right out-of-the-box without professional management by a DBA. In fact, a recent survey reported that 45% of IT personnel...