JKSQL (2/11/2016)

---

If a record does not exist in this table the update on "SomeTable" should work. When I debug I see it working the way I would expect but...

mikefle (2/11/2016)

---

Does anyone have any views on what is the best file format to request data to be sent in?

We have a number of processes where files are sent to...

Jacob Wilkins (2/11/2016)

---

It's because CONCAT converts NULLs to empty strings prior to concatenation; that's its difference/advantage to ordinary concatenation with +.

In the first case, when region is null, it's converted...

bark stuff (2/11/2016)

---

Hello, I have a ssis package that reads from hadoop via an ODBC source in a for loop. The ODBC connection is a bit flaky and...

Steve Jones - SSC Editor (2/10/2016)

---

SQL Prompt and Search for me. Of course, I work for Redgate, so I get the former.

I change fonts usually to make it easier to...

leehbi (2/10/2016)

---

Hi,

I've started to personalise my SSMS environment to aid development. Not a lot but small things make a difference over the long term.

Some of the things I've done...

Here[/url] are some of the...

Sure. Here's a way:

DECLARE @x varchar(10) =...

I still don't know for sure what this means. I presume you mean SSDT.

Perhaps you would describe what was wrong with Drew's...

Interesting, thanks for posting this.

OK.

Can you elaborate on exactly what you mean here - what steps are you taking?

scotdg (2/10/2016)

---

Thanks for the response Phil.

The package runs fine on the production server when I run it from SSIS. It is only when I execute the stored procedure that I...

You should also be aware that the NOLOCK hint can lead to some nasty issues, namely:

1) The possibility that 'ghost' data (data which is inserted as part of a transaction...

Did you appropriately configure the connection to MYSERVER.MYDB, somehow, after moving the package?