Home Sitemap Feedback About... Print
Custom Search

SQL Server troubleshooting


Known problems - Integration Services (SSIS)

  • 904800 - You receive an "Error loading" error message when you try to run an SQL Server 2005 Integration Services package in SQL Server 2005
  • 910512 - Custom events information from a child package is not logged under the log provider context of the parent package in SQL Server 2005 Integration Services
  • 910890 - SSIS reports that a query was successful when a SQLOLEDB provider ends an SSIS query because of a server error
  • 911003 - You may receive an error message when you try to export a table by using the SQL Server Import and Export Wizard
  • 911821 - Item labels in the SQL Server Integration Services toolbox window may appear in an incorrect language
  • 913817 - You receive an error message when you use Business Intelligence Development Studio to build a SQL Server 2005 Integration Services package
  • 914805 - An expression that you defined in a data flow task does not appear in the Property Expressions Editor dialog box in SQL Server 2005
  • 918633 - The login account of SQL Server 2005 Integration Services changes to Network Service after you install SQL Server 2005 Service Pack 1
  • 918760 - An SSIS package does not run when you call the SSIS package from a SQL Server Agent job step
  • 919224 - Error message when you connect to an instance of SQL Server 2005 Integration Services by using SQL Server Management Studio on a computer that has a 64-bit processor: "Connect to SSIS Service on machine <computer_name> failed"
  • 922546 - You receive a "No description found" error message when you create an SSIS package or a SQL Server maintenance plan in SQL Server 2005
  • 922647 - You cannot debug assemblies that are referenced in the Script task code by using Visual Studio for Applications in SSIS
  • 922648 - The binary zero (0x00) data and the successive data in a character column is truncated or is replaced with spaces (0x20) when you use the SQL Server Import and Export Wizard to transfer a table in SQL Server 2005 Integration Services
  • 924016 - BUG: You may receive an access violation error message when you try to run an SSIS package in SQL Server 2005
  • 926629 - You cannot connect to an instance of SQL Server 2005 Integration Services by using SQL Server Management Studio after you install an SSIS hotfix on a computer that has a 64-bit processor
  • 928324 - Error message when you use the dtsrun command prompt utility (Dtsrun.exe) to run a DTS package in SQL Server 2005 Integration Services: "This application has failed to start because SQLResourceLoader.dll was not found"
  • 931846 - You may be unable to execute SQL Server 2005 Integration Services packages that contain a Script task or a Script component on a Windows Vista-based computer
  • 933835 - Error message when an SSIS package runs that is scheduled to run as a SQL Server Agent job: “An OLE DB error has occurred. Error code: 0x80004005”
  • 938608 - You receive an error message after you install SQL Server 2005 Service Pack 2 when you try to edit a Script component that is inside an SSIS package and the SSIS package was created in an earlier version of SQL Server 2005
  • 940232 - Error message when you use SQL Server Management Studio to connect to SQL Server 2005 Integration Services from a client computer: "Connect to SSIS Service on machine '<SSISServer>' failed Access is denied"
  • 941154 - The "SQL Server:SSIS Pipeline" performance object does not appear in the "Performance object" list after you install Integration Services from a 64-bit version of SQL Server 2005
  • 952110 - Error message when you save a SQL Server 2005 Integration Services package in SQL Server Business Intelligence Development Studio: "Exception of type 'System.OutOfMemoryException' was thrown"

Known problems - Notification Services

  • 910892 - SQL Server 2005 Notification Services does not start successfully when you restart the computer