N.B. (1/12/2016)

---

Greetings,

I've been trying to find an answer to this for a couple of days, but either it doesn't exist (unlikely), or I'm just not phrasing the question correctly (far...

If it works fine in BIDS but not as a SQL Agent job, then it's likely a rights issue or an issue with a parameter being passed at execution time.

You...

Hint: try Googling: SQL heap

How good the search results you get are depends a lot on your...

A heap is how much trouble you're in if you mess up your database.

Seriously now, did you try to Google Heap?

Here's the first link Google showed me.

https://msdn.microsoft.com/en-us/library/hh213609%28v=sql.110%29.aspx

Eric M Russell (1/11/2016)

---

Alvin Ramard (1/11/2016)

---

Eric M Russell (1/11/2016)

---

rahulsahay123 (1/8/2016)

---

I am getting a data feed with date column of type integer.Format is mmddyyyy.

Values are like : 01092015

Now...

Ed Wagner (1/11/2016)

---

Jack Corbett (1/11/2016)

---

Ed Wagner (1/11/2016)

---

Koen Verbeeck (1/11/2016)

---

Ed Wagner (1/11/2016)

---

Grumpy DBA (1/11/2016)

---

Grant Fritchey (1/11/2016)

---

Continuing my role as the harbinger of death, Ziggy Stardust is no more.

One...

J Livingston SQL (1/11/2016)

---

GilaMonster (1/11/2016)

---

Steve Jones - SSC Editor (1/11/2016)

---

Grant Fritchey (1/11/2016)

---

Continuing my role as the harbinger of death, Ziggy Stardust is no more.

One of my favorite songs. Although...

Orlando Colamatteo (1/11/2016)

---

Alvin Ramard (1/11/2016)

---

If using SSIS, I think it would be easier to first dump the headers and details into separate files then using a script task to merge...

If using SSIS, I think it would be easier to first dump the headers and details into separate files then using a script task to merge the two files together....

I can see a way of doing this in SSIS, if the output is a text file with one or two columns.

What's I'm visualizing is rows in the data flow...

Eric M Russell (1/11/2016)

---

rahulsahay123 (1/8/2016)

---

I am getting a data feed with date column of type integer.Format is mmddyyyy.

Values are like : 01092015

Now i want to convert this...

Lynn Pettis (1/8/2016)

---

Jason A. Long (1/8/2016)

---

rahulsahay123 (1/8/2016)

---

I am getting a data feed with date column of type integer.Format is mmddyyyy.

Values are like : 01092015

Now i want to...

Jason A. Long (1/8/2016)

---

rahulsahay123 (1/8/2016)

---

I am getting a data feed with date column of type integer.Format is mmddyyyy.

Values are like : 01092015

Now i want to convert this...

How can this work? Reread the OP's post.

I'm sure we can all agree that no tool can prevent bad designs.