Hi Raghav,

You're getting ahead of me. Step 5...

:{>

Yes. Several of my servers already tweet, others interface with Twitter and other social media sites in different ways. My most visible server tweeting today is the AndyWeather server.

Having...

rockstar283 (6/4/2011)

---

Guys..what is your opinion about indexes..as per my knowledge indexes are heavily used in OLAP..but I generally disable the indexes before loading new data and again enable them back...

Please email the package to me: andy.leonard@gmail.com. I'm missing something.

:{>

Try the DT_DBTimeStamp data type.

Hope this helps,

Andy

What is the problem you are trying to solve?

Andy

Hi Ramadesai108,

If you want to store the value of your variable inside a table via an OLE DB Destination, one method is to use a Derived Column...

Excellent editorial Steve!

When it comes to the continuing struggles of the global economy, there's a bunch of blame to go around. I don't think enough blame has made it to...

mikewhi (4/29/2011)

---

We use them in ETL processing. We BCP into a heap, create a clustered index, run multiple queries on the CL index and then drop it in preparation for...

Great editorial Andy!

Like you, I see the job changing. I think everything you mentioned is quite possible given current trends, and I agree with another comment about having to know...

Eric M Russell (4/7/2011)

---

The initital build of the datawarehouse typically stems from a request coming from uppermost management for an enterprise level report or dashboard that shows them X, Y,...

Thanks Jamie,

I think you're being prudent and that I was sloppy with my terminology. It's ok to make analogies, but it's best to keep them out of...

Jamie,

Uh oh. What's wrong with referring to the Data Flow Task as a data pump?

John,

Yep - I missed that. You worded it correctly.

:{>

Thanks everyone for reading the article, the helpful suggestions, and kind words!

Roland: I have plans (and outlines) to show loading from several sources. Excel and flat files are included. Your...

Hi Dave,

Check out Bill Pearson's Stairway to MDX[/url].

:{>