Two brief suggestions, then we'll need sqlplans and the like to actually help you troubleshoot the direct cause.

Add OPTION ( MAXDOP(1) ) to the full query and confirm it's not...

You're pulling the short form of the error message from the job history. Do you have step logging turned on? If so, go into the log file that...

Lynn Pettis (9/5/2012)

---

If you look, you will see the attachment in your post. It can be viewed by clicking on it.

Now, how to...

Lynn Pettis (9/5/2012)

---

Actually, my bloody tongue has nothing to do with my saintly stature. I was asked by Steve to avoid further confrontage with Mr. Celko and a few...

Edit attachments at the bottom of the edit/create post window. it'll open up an upload window.

Alright, finally home and can spend a little time on this. First, get your hands on a copy of the function DelimitedSplit8k from here: http://www.sqlservercentral.com/articles/Tally+Table/72993/

Read the article as well,...

The only thing that comes to mind for Root-er to me is something that digs for roots as its food, or when oddly describing how a tree functions. Otherwise,...

Via the wizard I have no idea.

Via the regular build interface in BIDS/VS, yes. Go to the data tab and switch it from 'procedure' to 'text', and plug in...

XML Task doesn't like attributes, it prefers only fully formed tags. When you want access to the attributes, you've got to fuss with it a bit.

A brief...

SS53217 (9/4/2012)

---

Enum ScriptResults

Success = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Success

Failure = Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure

End Enum

Public Sub Main()

Dim FILETOTEST As String = Dts.Variables("CurrentFileName").Value.ToString()

...

This is a deep set of requirements, I'm not sure if you're aware of how deep this rabbit hole is going to go. Also, please less caps next time.

SS53217...

george sibbald (9/4/2012)

---

L' Eomot Inversé (9/4/2012)

---

I can't imagine anyone saying...

Add another step to task scheduler that will call db_sendmail from the server and shoot you an email. You won't see failures (which is when it's important to get...

I would recommend approaching this differently. IN ( @variable ) is notoriously a pita to get to work.

Instead, use a string splitter (delimited8k, SQLCLR, whatever you like) and turn...

For warehouses, particulary for cubes, you need to start with 'what questions do I want to ask of the data?' This will help inform you of what are facts...