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: SQL Network Interfaces, error: 26 – Error Locating Server/Instance Specified)  I got this error when… (0 comment)

  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 ActiveCustomers — Fetch the first row of the cursor and assign its values into variables… (0 comment)

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 ++  Scroll down to <DTSPackages> Example :  <DTSPackages>     <DtsPackage>           <Name>20-Export-To-Production.dtsx</Name>… (0 comment)