June, 2006

Posts

| |

|

Troubleshooting Microsoft SQL Server

Identity Insert and SQL Server 2005 Import Export Wizard

Posted over 6 years ago

by Chris Skorlinski [MSFT]
- 7 Comments
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...
Troubleshooting Microsoft SQL Server

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

Posted over 6 years ago

by Chris Skorlinski [MSFT]
- 2 Comments
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...
Troubleshooting Microsoft SQL Server

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

Posted over 6 years ago

by Chris Skorlinski [MSFT]
- 0 Comments
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...