The link in the whitepaper seems to be broken :(.

• This reply was modified 5 years, 5 months ago by Mr. Brian Gale. Reason: fixing mistake (article vs whitepaper)

Not looking through the logs sounds like you don't really want to find out what caused the problem.  That is what the logs are there for.  Without finding the cause,...

My best guess as to why it suddenly broke is that something changed on your system.  Could have  been a windows update, a sql update (although those are both unlikley),...

To address the security certificate message, that is semi normal.  Computers generate a certificate to be used for RDP connections.   It is used to encrypt the connections.  It should have...

My advice - First script will be dropping the server name from the SQL Instance.  So this will NEED to be the one that is stored in your databases.  Since...

One thought on how to create the excel file dynamically would be to have a "template" excel file that has the table headers already entered, but no data and then...

My laptop that I grabbed for cheap came with 6 GB of RAM and a 64GB disk.  Got it new and first thing I did was install the latest windows...

Might be a dumb question but why would you want to install different editions of SQL Server on the same physical machine?

I would recommend having a different folder for each...

A 32GB disk is pretty small for sharing both Windows and SQL Server.  Plus 4 GB of RAM is pretty low for SQL and Windows to play nice.

To install SQL...

Sounds to me like a version issue.  Is your VS2017 project set to use the same SQL Server version as your SSIS server?

Failing that, you can export the ispac file,...

From the article linked in the question:

SQL Server Management Studio uses Microsoft.NET FrameworkSqlClient for execution in regular and SQLCMD mode. When run from the command line, SQLCMD uses the OLE...

I think this information should already be captured in a few tables.  Looking at the table ReportSchedule, joining that back to Schedule, Catalog, and ExecutionLogStorage, you can see the timed...

• This reply was modified 5 years, 6 months ago by Mr. Brian Gale.

I wasn't trying to rag on you Steve.  I was just commenting on the different data types (at least in SQL 2008 R2 which I tested it in) that give...

While I agree with Jeff, it doesn't apply to all larger numbers.  TINYTINT, SMALLINT, and INT's have the same behavior but bigints throw an error instead.

As for the VARCHAR value,...

Can you post more information?

What I expect you are doing is something like:

SELECT *
FROM <TABLE>
WHERE <COLUMN> = 12.3

If that is the case, double check the datatype of...