Thanks a lot for that advice. I will try today.

Shawn, I've been googling but OData links are sparse.

I want to create an OData source in a new Project/package but there's no Source Connection Manager called that in my...

Shawn, thanks.

Icbidtg (I can't believe I didn't try google:w00t:). I didn't think it could be about the type of connection. Thanks for the next lead.

Shawn, In the XML file I find three connectionManagers.

It seems that VS is not liking the OData one. So, I removed it (left other two alone) and tried reload,...

And what files would be a reasonable way to ask for from someone intending to share their ssis package with you? This ssis package exists on that person's computer...

very good ideas. I will try this.

thanks for replying happycat and shawn. Glad to learn about opening up in notepad and tips for finding version.

PackageFormatVersion is 6 so 2012!

So, should I...

Hi Dixie Flatline, I saw this on another post and was trying to understand it so I appreciate that you explained the code more in this version. I will...

Well, I thank you very much for advising on the NEWID() function.

I went searching for the answer to my question in an existing thread and found these. I hope...

by...

The Dixie Flatline (12/16/2010)

---

Using ORDER BY NEWID() with huge files is slow, because of the sort time.

Generating TOP (X) WHERE (random number test) is fast, but tends to skew towards...

Hi RBarryYoung,

Can you please explain use of 0x7fffffff ?

Problem is solved by using Dense_Rank function and the blog that helped me solve problem of not being able to use COUNT DISTINCT in the OVER clause with PARTITION BY...

Jeff, the query you gave me gives incorrect average, anyway. So the following query shows how I get just the correct Average#ofLineItemsPerDistinctInvoice for any given month. It's what...

the reason for preaggregating is because there's too much data to fit into excel and growing. But, in preaggregating the column names need to remain intact, with no intersection...