Error Message : Open Database Connectivity (ODBC) error occurred. state: ‘HY000’. Native Error Code: 2008. [MySQL][ODBC 5.3(a) Driver][mysqld-5.5.5-10.1.22-MariaDB]MySQL client ran out of memory This error is caused due to large … Read More “MySQL client ran out of memory”
How to Save and Schedule SSIS Packages using SQL Server 2008 R2 for Non Administrators Step 1 Upgrade SQLServer 2008 R2 with latest SP Step 2 Saving Package from Business … Read More “Save and Schedule SSIS Packages using SQL Server 2008 R2 for Nonadmins”
While importing data from Excel to SQLServer, if a Excel column in has both Text and Numeric values then either Text or Numeric values will be NULL in SQLServer. See … Read More “SSIS import mixed datatypes from Excel to SQLServer”
If you create multiple packages in a Project, SQLServer Business Intelligence will not sort them based on file name. There is an alternate way to sort the items in the … Read More “Rearrange SSIS Packages in SSIS Project.”
Where is the Connection String in SQL Server Management Studio sp3 ? How are we supposed to import data from ODBC data sources ?