It happens to me too. Regularly. Every day.

I'm working alone on the machine. I'm pretty sure that the SSDT and SQL code are the same (when i start with...

Interesting...Thnx

Running into this issue too... I was curieus how to implement a SCD2 dimension in SSAS? For instance I want to compare Revenue with an organisation dimension in old and...

Please more information. I'm interested in the technical implementation..

Very nice article and my thoughts are confirmed by this article..Thank you...

Thnx for this great book!!!

gr

Hennie

Coming Soon?

Currently there are two main architectures approaches: Inmon and Kimball. Kimball is a quickstarter and you'll get quick results. The problem with Kimball architectures are the adaptibility in case of...

Well, off course you have a point and in this case i could build this as you suggests but my question has also a fundamental background: whenever i want to...

Hi,

Yes, there is a parent child relation between the fact tables. Okay you're saying: add the dimensions of the parent fact to the child fact?! Hmmm for clarity, purity, etc...

okay, i agree this is not a desireable situation to implement multiple different measures in a cube. The alternative is building multiple cubes?! That would mean you need to define...

okay, it seems there something going on here with the web service task:

http://sqlblog.com/blogs/jamie_thomson/archive/2010/05/11/five-things-ssis-should-drop.aspx

https://connect.microsoft.com/SQLServer/feedback/ViewFeedback.aspx?FeedbackID=126247&wa=wsignin1.0

http://sqlblogcasts.com/blogs/simons/archive/2007/07/02/SSIS---Web-Service-task-doesn-t-cut-it-but-who-cares.aspx

I think there something with supported versions or features of the WSDL file.

On http://www.tech-archive.net/Archive/SQL-Server/microsoft.public.sqlserver.dts/2009-04/msg00004.html James Wang (Microsoft Online Community Support) says that "HTTP connection is only used for sending (uploading) or receiving (downloading) files via HTTP". He advices to use the...

some probleem here!

I've this problem in SQL Server 2008 R2 standard edition.

Trying to connect to Bing webmethod with the web services task.

Downloaded the wsdl file from the webmethod and...

Great! I haven't read this but it looks great. Will read this and place some comments (when i have them).