June 2006 - Posts

• Identity Insert and SQL Server 2005 Import Export Wizard

  Have you ever run the SQL 2005 Server Import Export Wizard and noticed the identity values for the destination table are renumbered? The SQL 2005 Server Import Export Wizard setting " Enable identity insert " is ignored when selecting "Optimize for Many Read More... Posted Saturday, June 24, 2006 3:12 PM by chrissk | 8 Comments

• SSIS Data Flow Task An OLE DB error has occurred. Error code: 0x80040E37.

  PROBLEM: When using OLE DB Source Editor, the drop down "Name of the table or view" shows " doublequotes around the schema and table name. Selecting the table (for example "dbo"."Table1"), then Preview returns the error below: Error at Data Flow Task Read More... Posted Monday, June 12, 2006 11:03 AM by chrissk | 2 Comments

• HRESULT: 0xC0202022 An error occurred due to no connection. A connection is required when requesting metadata.

  PROBLEM : If you are using Sybase as a OLEDB Source the list of tables can appear in the "Name of the Table or the View" drop down on the OLE DB Srouce Editor even if SSIS is in "offline". Once you select a table, then try to view the columns you get Read More... Posted Monday, June 12, 2006 10:46 AM by chrissk | 0 Comments