Magenic Technologies Community Blog

Browse by Tags

• Informatica PowerCenter vs. Integration Services (SSIS) Comparison

  This past year I got an opportunity to finally take the great Informatica product for a test drive. I guess it wasn’t really a test drive since this was the ETL tool that was being used for the project, but it was my first time using the product (other Read More... Posted Saturday, June 12, 2010 12:14 PM from Dan English's BI Blog | 0 Comments Filed under: Integration Services

• PASSMN May 19 SSIS Presentation Follow-up

  I have posted this content on the PASSMN user site here - May 19, 2009 - Dan English: SSIS Team Development, Deployment and Configuration , but if you do not have access I have also uploaded my presentation and SSIS demo project files to my SkyDrive area Read More... Posted Tuesday, May 19, 2009 7:32 PM from Dan's space | 0 Comments Filed under: Integration Services

• SSIS 2008 ADO NET Source issue with SSAS data source - error code 0x80004002

  A few weeks back I upgraded a SSIS 2005 package to SSIS 2008 and ran into a issue with my Data Flow Task source. In the original package I was using a DataReader source to query information from Analysis Services (SSAS) and during the upgrade this gets Read More... Posted Sunday, March 29, 2009 7:56 AM from Dan English's BI Blog | 0 Comments Filed under: Integration Services

• Integration Services (SSIS) Package Designing Tips

  I recently co-presented at a local event in Bloomington, MN talking about SQL Server Integration Services – Enterprise Manageability . There was a lot of content to discuss and along the way I mentioned a few items in regards to designing SSIS packages, Read More... Posted Sunday, February 01, 2009 8:08 AM from Dan English's BI Blog | 0 Comments Filed under: Integration Services