The fact that AddressLine has a sequence attribute leads me to believe that multiple address lines are possible.

So I added a sequence="2" node to the XML, before sequence="1".  So you...

DontSaveSensitive is what I use.  All passwords should be provided through configurations.

Preferable some kind of configuration that doesn't leave it sitting there in plain text, such as command-line configuration in...

The table is a heap, so there is no guarantee that DELETE TOP 100000 will delete rows in date order.  You also may run into issues with the space used...

You could create a script source component to handle multiple formats.

In the PrimeOutput method, open the file and read the first row with the column headers.  Deduce from...

It is possible to do it while only evaluating each condition once.
SELECT Results = CASE
            WHEN td.OnlyColumnProvided NOT LIKE '%RR%' THEN 'N/A'
            WHEN td.OnlyColumnProvided LIKE '%MM%'...

I assumed the author intended the INSERT to be a valid statement, for example the Codigo column could be an IDENTITY column.  And that the @Contador variable was declared somewhere. ...

There is no difference in the underlying value, the double data type is still using the same IEEE standard format with the same number of mantissa bits.  The difference is that...

I don't know where to start with trying to close another user's Excel app.  Even if you tried some dark sysadmin magic to close the process remotely, it's probably going...

Instead of using [Sheet1$] as the table name, can you create a named range in the template spreadsheet (starting below the header row) and use that for the table name? ...

You need to clarify whether the "INSERT #xml EXEC sp_OAGetProperty" is returning NULL, or whether the table is indeed getting an XML value but "yourXML.value()" results in NULL.

If...

So depending on your Management Studio version, some times answer 1 is correct even if the server is SQL 2017?  Sounds like 82 of us deserve a point.

You can find the second and later versions in sys.numbered_procedures.

Wouldn't this behavior depend on which version on Management Studio you're using, rather than the SQL Server where the...

You can't create a script task in a data flow.  You can create a script component.  But if you're using a flat file source, the script component would be downstream...

If you create a template Excel file with the desired formatting, and create a named range where you want to write the date, you can use the range name as...

The tags were OK, but the XML header said it was UTF-8 and there were illegal characters in it (not in proper UTF-8 encoding).
Specifically the fancy e in efficiënt.  I...