In your debugging, were you able to detect whether the ExcelReader was retrieving any data?

Have there been any environment changes? Software updates? Permissions changes (including at network/file level)?

Provide the output you expect, based on the data you provided.

Not an English...

Your description is unclear. Are you able to introduce clarity by...

SQLAddict01 (2/11/2016)

---

I have a column with varchar data type but has numeric data in it

I know I can't use arithmetic operation for varchar

This is my query

select * from table1

where col1>...

yb751 (2/11/2016)

---

Just a couple things to consider. Make sure you validate your data to make sure it's actually a number. i.e. (ISNUMERIC). Secondly, try to avoid using CONVERT...

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.