Perhaps, as in genetics with the recent CRISPR scandal, new ventures with AI / machine learning (that require massive large datasets that can't be easily manufactured), should be regulated and...

Hi Tom & Phil,

I am currently setting up version control and workflow / processes within a DevOps MI / datawarehouse team I have just joined.

We will...

Thanks. Will either put the SQL straight into the LKP or create a view and select that.

Thanks to both of your for your input.

The solution to this is to use a SQL query rather than Table or View in the ADO.NET connection source editor.:-D

So I have been able to create an ODBC Connection in the Connection Managers pane at the bottom of the SSIS project area, by right clicking and choosing the last...

Hi,

Have you had any luck resolving this issue as I have a similar problem.

Cheers

eric

Simply upgrading your Excel desktop application does not fix this problem if you are running SSRS 2005.

Here is a link describign the problem and an official Microsoft response.

It would...

We have this error also, so I tried running the report as I have Excel 2010 and the user has Excel 2003. Still got the same error. My theory is...