I am saying that I would like to be able to export the Excel file with the header rows frozen.

It is allegedly possible, but I couldn't get it to work.

Freezing the header of a table is simple for the online version of an SSRS report, but freezing the header of a spreadsheet exported from an SSRS report appears to...

I haven't touched this subject for years.

I did google this, however.

https://www.mssqltips.com/sqlservertip/4025/sftp-in-sql-server-integration-services-ssis-package-with-bitvise/

I would open the CSV file in Excel and search-and-replace the apostrophe with nothing, then save the revised file as a CSV file that now contains no apostrophes.

Looks like they just restored the resource file to the article.

https://www.sqlservercentral.com/wp-content/uploads/2019/04/QRCoderResources.zip

SQL Server Central hasn't restored the resource files after the conversion yet.

I scoured my hard drive and found copies of QRCoder.dll and QRCoderImageToByteArray.dll that I think are the ones I...

• This reply was modified 5 years, 7 months ago by  Stan Kulp-439977.

Steve, the resource files for articles are missing.

This article should have a resource file named QRCoderResources.zip.

https://www.sqlservercentral.com/articles/linear-barcodes-in-ssrs-using-the-barcode-image-generation-library

Our version of ELT is dumping the data to a staging table as VARCHARs with SSIS, creating a destination table with appropriate data types for each field and then writing...

Nice article. Dynamic SQL is one of those things you don't use very often, and a simple article like this is useful for refreshing your memory on the basic principle.

Great article!
One question: How do you decide how many instances are required?

I had to deal with data containing a field with multiple values. It wasn't my choice. I managed to solve the problem. I just shared it in case it might...