Adding Rows in Incremental Loads - Level 3 of the Stairway to Integration Services[/url]

Updating Rows in Incremental Loads –...

As SSMS now uses the...

Spiff (9/27/2016)

---

--

If you absolutely need to validate the format then SSIS expressions are rubbish and the best way is to use a Regex's in a script task. Good article...

Redirecting any errors on INSERT...

Try to solve the various T-SQL problems that other people post here ... and compare your solutions with those written by others. You'll learn a lot if you take the...

Brandie Tarvin (9/27/2016)

---

SET RANT Brandie ON;

I just spent the past week working on a bug fix to get into our production systems before month end. Last night, after I leave...

Thanks for posting. I just tried it again and it seems to have gone away, thankfully.

13.0.15900.1.

Having my environment settings reset every time I get a version update remains irritating, however!

Sean Lange (9/26/2016)

---

The absolute best solution would be stop naming tables _2008 etc. Add in a transaction year or similar as a column in the table and this is no...

ah0996 (9/26/2016)

---

Hi,

I have C# script that reads last modified date of file. Script works perfectly fine while running manually from package. However, when I deploy the script/package to SQL job....

dallas13 (9/26/2016)

---

Hello,

I have so many excel files coming that I need to load to sql and create automated process.

I dont want to convert them to csv or txt file format...

Please describe what you mean by this.

Well, you can at least connect to it from SSDT.

Choose Tools/SQL Server/New Query and then expand the 'local' node to select the connection you are interested in.

When I did this...

OK, this is a start

You have a comma after the declaration of @nFY_ST_QUESTION_DTL_TABLE_ID. Should be a semicolon.

You have a mismatch between begins and ends.

Having an IF and then another IF...

Telling us that you are "getting errors" without telling is what the errors are is most unhelpful ... are we supposed to guess? Please post them.

lcarrethers (9/23/2016)

---

We have a job that sends out a pdf once a week and every now and then we get this error message. I have tried to rerun the...