The link in the first response by Thom A explains that the { oj ... } syntax is an ODBC escape sequence.  Which leads me to believe that this code...

I would use a Script Task instead of a File System task, and use C# code to figure out where the Archive folder is and to move the file.

You seemed to be concerned about how many seconds it would take to run all the commands, so you should realize that reconnecting to the database each time can be...

I would suggest opening the connection once and reusing it, rather than creating and opening a new connection in each IF section.

Also, I don't see anything in your...

If you create a named range in the Excel spreadsheet, you can use it as a table name in an Excel connection and insert directly into that part of the...

You can't rely on syscomments for this.  The text column is nvarchar(4000), so large procedures can be split into multiple syscomments rows.  If your target text is split on a...

I inherited code from someone who couldn't do a thing without cursors.  I'd swear they had a DECLARE CURSOR snippet auto-populated in every new query window.  Nested cursors instead of...

The question was "If I use QUOTENAME(), what is the type of data that is returned to me?".  The answer is NVARCHAR(258).

If the arguments are invalid the VALUE...

I would probably use minimalist aliases myself, but it might make more sense to you if the element names were used for aliases.  Also, the .query() function can be useful...

You may be getting two archive INSERTs because of the UPDATE inside your trigger.

You could surround the INSERT with an IF to avoid auditing when the Type_ column...

I think the your trigger should INSERT as many audit rows as there were rows affected by the original UPDATE, and you should likewise only have one UPDATE statement that...

A foreach loop container can handle a collection object, so you could use a script task to get file lists from both folders and populate some kind of List object,...

If you want to capture the email failures, just enter your own email address as the reply address for all SQL email accounts.

The invalid domains are captured in sysmail_faileditems, because the invalid domain can be detected by checking the syntax of the address.  

The valid-looking addresses that are undeliverable are not...

I have a package that does something like that.  One script task generates files, and saves the file names in a table.  Another script task tries to get a filename...