General Network error. Check your network documentation.

This is a proper netwrok error and has nothing to do with the coding if any of your jobs/queries/packages fail with this message. Please refer the following article for the workaround. http://support.microsoft.com/kb/942861/en-us Another work around we tried and succeeded in our project was as follows: There is something called Network Speed setting which is usually…

2

Package migration from version 3 to version 2 failed with error 0xC001700A. The version number in the package is not valid. The version number cannot be greater than current version number.

I guess at least once every SQL developer might have come across this error on SQL Server 2008 while running a SQL job that calls a package. Reason for the error: Old version of the DTEXEC is picked up by SQL Server instead of the new one. That means, the exe shipped with 2005 is…

30

How to open DTS packages in SQL Server 2008?

An error occurs if you try to open a DTS package from Leagcy –> Data Transformation Services in SSMS of 2008. The message says, SQL Server 2000 DTS Designer Components are required to edit DTS packages. Install the special web download, “SQL Server 2000 DTS Designer Components” to use this feature. (Microsoft.SqlServer.DtsObjectExploreUI).   Downloading the following software from…

33

Reading DTS and SSIS packages programmatically

Reading a DTS/SSIS programmatically helps a lot in doing impact analysis. Consider a scenario in which all the packages containing a particular table or stored procedure need to identified. Let me give another usage scenario for this. The sql native clinet provider SQLNCLI.1 is no longer supported in SQL server 2008 and it has to be changed to SQLNCLI10.1. If you…

4

Moving indexes from one filegroup to another in SQL Server

This is a pretty simple task but I would like to provide a generic method for doing this. It will help if the requirement is one (or all) of the folowing. I have only considered non-clustered indexes along with the Inclued columns and filtered indexes. No point in moving clustered indexes as moving them would move the data as well. This is…

11

Creating new tables and loading data in SQL server by reading an Xml file

This kind of requirement may come if VSTS is used for test automation and the test results have to be loaded to a Database. Since the output of test automation is an xml file, let us look at how we can create tables and load them with data by reading an xml file. The logic at a high level…

2

How to get missing values from an Identity column?

Let us assume that there is an Employee table with EmployeeId as the Identity column in which some values are missing.  The following batch will show all the missing values in that Identity column. The logic I preferred is to create another table with the same increment as that of the parent table but without…

1