Search Results: Error

• 
  SSIS Troubleshoot Derived Column Expression Errors

  I have come across several forum posts recently on several different websites asking for help with a problematic Derived Column Expression. When I asked the error being returned, I frequently got: "the expression just turned red" or "I don't know, it isn'

  Author:  Daniel     Date: 6/14/2011     Section: Blog

  tags : Configure Error Output, Derived Column Expression, Expression Error, Troubleshoot, SSIS
• 
  Error Code 0xC020907F - The Conversion returned status value 2 - error code 0xC0209029

  I finally finished creating my flat file test data for a series of SSIS practice exercises. While trying to create the finished project to break it down into smaller problems I ran into this error message: [Data Conversion [212]] Error: Data conversion fa

  Author:  MitchellPearson     Date: 11/22/2012     Section: Blog

  tags : DataFlow, Pragmatic Works, ssis, task factory
• 
  SSIS Fuzzy Lookup Error

  A Fuzzy Lookup Task in SSIS that I was working on was bombing out, and I had a heck of a time figuring out why. The error did not tell me much: Error: 2011-05-18 10:42:09.33 Code: 0xC0047022 Source: Fuzzy Match InfoUSA SSIS.Pipeline Description: SSIS Erro

  Author:  jamserra     Date: 6/14/2011     Section: Blog

  tags : ssis, fuzzy lookup
• 
  The CASE of the missing non-NULL T-SQL Error: None of the result expressions in a CASE specification can be NULL.

  Recently, while doing some data scrubbing for a customer I got an interesting error in SSMS with one of my CASE statements. The error received was: None of the result expressions in a CASE specification can be NULL. It was a long T-SQL script (and a long

  Author:  JoseChinchilla_SQLJoe     Date: 11/16/2011     Section: Blog

  tags : case, case statement, Error, sqlserver, syntax, T-SQL
• 
  Because the Fortune Cookie tells me to use Configuration Files!

  If you have ever developed SSIS packages that would eventually be deployed to a production environment then you've run into this issue. I'm talking about Package Protection Levels. What tends to happen is users set up their packages how they want them, th

  Author:  Tyler     Date: 11/18/2011     Section: Blog

  tags : config, configuration, Deployment, errors, Files, Package Configurations, validation
• 
  Cube Deployment - Credential Problems

  I recently upgraded to SQL Server 2008 R2 on my local machine and had to go through the joyous occasion of reloading all the adventure works sample databases. This is never a problem, until I have to deploy the sample cubes. I'm not too knowledgeable in t

  Author:  ShawnHarrison     Date: 7/21/2010     Section: Blog

  tags : Analysis Services, deployment, impersonation, SSAS, Cubes
• 
  SQL Server 2012 Master Data Services Error: The required .svc handler mappings are not installed in IIS.

  Microsoft SQL Server 2012 Release Candidate 0 (RC 0) has a confirmed issue with Master Data Services configuration. The following error is raised by the Master Data Services Configuration Manager when launched: Before creating an MDS web application, you

  Author:  JoseChinchilla_SQLJoe     Date: 11/29/2011     Section: Blog

  tags : 2012, Error, iis, Master Data Services, MDS, sqlserver
• 
  Valuable lessons in loading a .dbf file in SSIS packages

  During my short time here at Pragmatic Works I have come across some VERY valuable lessons. The most important one so far is being able to decipher certain error messages in SSIS when executing a package that keeps failing; something I am sure everyone in

  Author:  tiffswn     Date: 3/8/2011     Section: Blog

  tags : CANNOTACQUIREFROMCONNECTIONMANAGER, error code 0xC0202009, Jet Driver, OLE DB, SSIS, Connection Manager
• 
  Help with Oracle Connection

  I have a set of SSIS Packages which connects to Oracle source using MSDAORA (Microsoft OLEDB Provider for Oracle).I have added a new package to the project by copying and renaming an existing object. When I run this new package I get the following error &

  Author:  Yuvaraj     Date: 6/13/2011     Section: Forum

  tags : 64 Bit, Connection Manager, Oracle
• 
  Custom Auditing and Error Handling in SSIS

  My Blog: ( Link ) Errors can occur at any stage when you extract data from source and load it into destination. You must include error handling method for your package to test and troubleshoot. There are several ways to handle it at different levels durin

  Author:  hardikabhavsar     Date: 7/18/2012     Section: Blog

  tags : Auditing, Error handling, ssis
• 
  SQL Server 2008 R2 Developer Installation

  Anyone else run into this? I'm installing a development / testing VM in Virtual PC 2007 and when attempting to install SQL 2008 R2 ( developer - from MSDN ) under Win XP SP3 ( fully patched ) - otherwise, a clean install, I get the following error: "Insta

  Author:  KeithHyer     Date: 7/26/2010     Section: Forum

  tags : error, Installation, setup
• 
  Excel Data Load Truncation Error

  This article gives an explanation of and a solution to a truncation failure that can occur when loading from an excel data source. The engine that brings in the data will be examined and solutions will be laid out. There is a demonstration section that ca

  Author:  DanMatisis     Date: 7/18/2010     Section: Article

  tags : Data Load, Registry Keys, Truncation Error, TypeGuessRows, Excel Source
• 
  Watch out, Visual Studio 2010 does not support BI

  When Visual Studio 2010 was released about a year ago, I was very excited and wanted to quickly open up a SSAS project created in VS 2008 to see the new features that were available in VS 2010. So I copied one of my projects to a test folder and proceeded

  Author:  jamserra     Date: 6/16/2011     Section: Blog

  tags : SQL Server, SSAS, SSIS, SSRS, Visual Studio 2008, Visual Studio 2010, Business Intelligence
• 
  MDS Error: MDMMemberStatus does not de-activate members through the StgMemberAttribute table

  Master Data Services provides a way of de-activating entity members using the StgMemberAttribute table as described in Books On Line http://msdn.microsoft.com/en-us/library/ee633772.aspx This is a somewhat straightforward approach and requires for you to

  Author:  JoseChinchilla_SQLJoe     Date: 10/11/2011     Section: Blog

  tags : Data, De-Activated, Error, Master, Master Data Services, MDMMemberStatus, MDS, Services, StgAttributeMember
• 
  Derived Column Help

  Hi Kylewalker, I just want to give you update, I tried my best to fix this issue/error that i am reciving but no luck. I am going to post error for you reference, Please let me know if any luck, [Derived Column [47]] Error: SSIS Error Code DTS_E_INDUCEDTR

  Author:  tooba     Date: 2/22/2011     Section: Forum
• 
  SSAS error when processing the cube

  Every couple of weeks I see this SSAS error when processing one of my cubes: Internal error: Invalid enumeration value. Please call customer support! is not a valid value for this element. An error occurred while parsing the ‘StorageMode’ element at line

  Author:  jamserra     Date: 6/15/2011     Section: Blog

  tags : SSAS, SQL Server
• 
  MDX Tuple Error in SSRS

  A quick post today about getting an error regarding too many tuples returned: An error occurred during local report processing. An error has occurred during report processing. Query execution failed for dataset ‘DataSet1′. The expression contains a functi

  Author:  TomLannen     Date: 12/8/2010     Section: Blog

  tags : 294, 296 tuples, 967, The expression contains a function that cannot operate on a set with more than 4
• 
  Excel Web Access error in Sharepoint 2007

  I wanted to use Excel Services on Sharepoint 2007 to migrate some of our BI reports from a third party application that we use. So I tried publishing to Excel Services from Excel 2007 assuming that our Sharepoint was setup to be used with Excel Services.

  Author:  indupriya     Date: 2/16/2011     Section: Blog

  tags : Excel Calculation Server, Excel Services, Excel Web Acccess, MOSS 2007
• 
  SSIS Execute SQL task Error: No disconnected record set is available

  SSIS Execute SQL Task Error : No disconnected record set is available for the specified SQL statement. If you get the error in SSIS that says: [Execute SQL Task] Error: Executing the query "INSERT INTO [table].[dbo].[tablename] ([N..." failed with the fol

  Author:  MikeDavis     Date: 7/26/2010     Section: Blog

  tags : Error, SQL Task, SSIS
• 
  DTS Runtime Required

  Yesterday, I dealt with a client that was having issues converting his dts packages to SSIS 2008. He was using DTS xChange to convert the packages, but each time he tried to run the migration, he received the following error. "Can not load Tasks. Error :

  Author:  ShawnHarrison     Date: 3/12/2010     Section: Blog

  tags : Active X, migration, SSIS, DTS runtime
• 
  Microsoft Office 12.0 Access Database OLE DBO Connection Manager Error

  If you have ever tried to use a Microsoft Office 12.0 Access Database Engine OLE DB Provider Connection Manager to pull data from a .xlsx file, you may have received the following error message when you try to test your connection... If this is the case,

  Author:  kylewalker     Date: 12/9/2010     Section: Blog

  tags : Unrecognized database format Error, xlsx Source, SSIS
• 
  abort/exit child package without exiting parent loop

  There are two ways to handle this. Either set the master package to handle more errors by increasing the maximum error count. I don't like that because it leaves room for other errors to slip by. The other option is to add a bad row output to your child p

  Author:  MikeDavis     Date: 2/16/2010     Section: Forum

  tags : child, error, master, parent
• 
  Illegal character in File Path

  bluize76 said: This is the error that I get now..... Error at File System Task [File System Task]: An error occurred with the following error message: "Failed to lock variable "I:\DEPARTMENTS\Business Management\Business Intelligence\Initiatives\ScopingDB

  Author:  KeithHyer     Date: 8/24/2011     Section: Forum
• 
  Generating a Blue Screen of Death with SQL Configuration Tables in SSIS

  One of my duties at work is to teach a class on using SSIS. On the last day of class, I cover various admin topics. One of my favorite segments is using configuration files in SSIS packages. There is a known bug I like to show that involves adding two con

  Author:  ShawnHarrison     Date: 6/21/2011     Section: Blog

  tags : Blue Screen of Death, BSOD, bug, Configuration Tables, SSIS
• 
  SSIS Master or Parent Package Handling Child Errors

  Learn how to call child packages and handle errors between them.

  Author:  MikeDavis     Date: 2/17/2010     Section: Article

  tags : Child, Errors, Handling, Master, Package, Parent, SSIS