Are you reading Excel files?

The JET OLE DB provider is 32-bit only.

chalam87 (6/23/2014)

---

Hi,

i apply constraint to check two columns values.below is my table structure

priority1 priority2 priority3 priority_hashvalue

my check constraint is

[priority_hashvalue]=hashbytes('md5',([priority1]+[priority2]+[priority3]))

it's working fine while inserting new record into...

Easy one, thanks.

waralees (6/22/2014)

---

Dear Jo Pattyn.

At the same package, same server, the Problem is depend on run-time mode. For 64 bit run-time mode, then the problem is...

If you want to give official Microsoft courses, you need to be an MCT.

I'm not sure what happens if you design your own course.

A lot of people blog, share videos...

How I usually solve this in SQL is that I have a table with all the months in it and I join this against the data with a left outer...

Great question, thanks!

You could just define new views on top of the other ones.

(which is not ideal of course)

When importing data from an untyped source - a flat file...

pwalter83 (6/19/2014)

---

Sachin Nandanwar (6/19/2014)

---

Something like this

SELECT SUM(YourSum) FROM

(

SELECT SUM(CASE WHEN SOA_TYPE = 'Agent' THEN USD_AMOUNT ELSE 0 END) +

SUM(CASE WHEN SOA_TYPE = 'Freight' THEN USD_AMOUNT ELSE 0 END) +...

Scott Clark-275269 (6/19/2014)

---

Found the issue.

SSIS 2012 still has a limitation on the String data type for variables. The use of the VarChar(Max) or NVarChar(Max) data type in the query...

Congrats!

Thanks for all the effort!

Chitown (6/19/2014)

---

What happens if there is no activity in the DB? The job will run regardless but will it send out email notification even...

Ed Wagner (6/19/2014)

---

melanie.townsend (6/19/2014)

---

About the Spam messages which have been flooding the forums -we're aware of the problem and are working to clear the posts as quickly as possible. I...