The most often asked question when configuring a firewall for SQL Server access is what ports are used by SQL Server? If your SQL Server uses default port numbers, it's important to have TCP port 1343 & UDP port 1344 at the minimum opened. The rest port numbers are listed on the table below. It's important to note that a named instance will have a dynamic port number other than 1433 used … [Read more...]
Removing _x0022_ Character Issue in SQL Server and SSIS
Just recently after an a production database upgrade to a 64-bit SQL Server 2008 R2 RTM (from SQL 2000), the same SSIS 2008 package that exports data from SQL Server 2000 to a flat file (csv/txt) started to wrap all data fields with _x0022_ hexadecimal characters. The CSV file that was extracted is not totally worthless especially if it's already taken hours to produce that file. We can … [Read more...]