Script(s)

technology as-is

May 6, 2010
by gchandra
0 comments

LoginControl and CSSAdapters

A network-related or instance-specific error occurred while establishing a connection to SQL Server. The server was not found or was not accessible. Verify that the instance name is correct and that SQL Server is configured to allow remote connections. (provider: … Continue reading

May 6, 2010
by gchandra
0 comments

Avoid Using SQL Server Cursors

  Based on http://www.sqlbook.com/SQL/Avoiding-using-SQL-Cursors-20.aspx with a minor change. DECLARE @CustomerID int DECLARE @FirstName varchar(30), @LastName varchar(30) — declare cursor called ActiveCustomers DECLARE ActiveCustomers Cursor FOR  SELECT CustomerID, FirstName, LastName   FROM Customer  WHERE Active = 1 — Open the cursor OPEN … Continue reading

May 6, 2010
by gchandra
0 comments

Rearrange SSIS Packages in SSIS Project.

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 way you need. Open .dtproj file in Notepad / Notepad … Continue reading