Check this out. Be sure to...

It depends on the Oracle driver used by SSIS. I had the bad experience on having a very slow one.

A faster option was to export to a flat file and...

Sombrero

Blocking is not a bad thing. It's used to keep data integrity.

Excessive blocking is a problem and...

Remove the braces and just leave the pipes. Then click refresh.

If it doesn't work, copy the delimiter from the file and paste it in the column delimiter field.

J Livingston SQL (6/21/2016)

---

Hi Luis

have you seen this other thread from OP?

http://www.sqlservercentral.com/Forums/FindPost1796115.aspx

this...

Do you understand how it works? Remember that you'll be the one supporting it.

Adding to Phil's comment. Your second example is using an integer. This integer is being converted to a datetime before applying the datename function. The number 2 is converted to...

Mad Myche (6/20/2016)

---

Luis Cazares (6/20/2016)

---

The code mentioned here isn't the problem. The problem comes from the database design. Dates shouldn't be stored as strings or integers. We also need to...

rajemessage 14195 (6/20/2016)

---

hi,

i wanted to know , is there any overhead of begin try cache,

like is there any situation it takes more resources , so i will use it causesly.

yours...

Chicken

This is what I got from your code, you might need to tweak it.

To understand how it works, you can read the following articles:

http://www.sqlservercentral.com/articles/comma+separated+list/71700/

http://www.sqlservercentral.com/articles/Crosstab/65048/

DECLARE @fromdate datetime = '2014-08-01',

...

The code mentioned here isn't the problem. The problem comes from the database design. Dates shouldn't be stored as strings or integers. We also need to know if the time...

Ed Wagner (6/20/2016)

---

djj (6/20/2016)

---

ThomasRushton (6/20/2016)

---

Ed Wagner (6/20/2016)

---

TomThomson (6/18/2016)

---

Hugo Kornelis (6/18/2016)

---

mjagadeeswari (6/17/2016)

---

Law of Selective Gravity ("An object will fall so...

Don't forget to add the year as well.

An alternative to get both in a single function is to convert them to a string: CONVERT(char(6), yourDateColumn, 112)

I'm not sure which approach...