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 Tables” causing the identity values at the destination to be renumbered. The “Optimize for Many…

8

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 [OLE DB Source [1]]: An OLE DB error has occurred. Error code: 0x80040E37….

5