Blog is a collection of misc troubleshooting tips collected while supporting Microsoft SQL Server 2000 2005 and 2008 customers.
Forcus area covered include SSIS, Performance, and Replication
June 2006 - Posts
-
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...
|
-
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...
|
-
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...
|