ActiveX was present in SSIS 2005 and 2008 to support legacy DTS. You could convert DTS into SSIS and the ActiveX would still be there. However, DTS is removed in...

Take a look at the actual query plans. Is there anything different?

(also, more than 5 seconds just to insert 5000 rows? There seems something off at your system)

Nice attempt to a trick question 😀

What should work:

Read the column into a script component as a transformation. In the .NET script, cast the DT_NTEXT (which is a BLOB column) to a string. Apply the substring...

Does the user ELSTREE\JXYZCUSR have read access to the path S:\Private\AML Data Extract\AML Data Extract.xls?

If there is, I haven't found it yet.

Ah ok, now I get it. As far as I know, this is a common issue with drillthrough reports. If you drillthrough, the prompt area is hidden (unfortunately).

I tried it myself, and I could set a default value for a boolean parameter without a problem.

How did you try to set the default value?

Did you mark param2 as hidden?

Please do not crosspost. It wastes peoples time and fragments replies.

Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1383930-1550-1.aspx

Great! Glad this was solved so quickly 🙂

This is crucial:

So you could take a look at the output window and post everything you find there here in...

Isn't log shipping and mirroring high availability? I thought having plenty of verified backups is disaster recovery.

No. A cube uses a different storage engine than the relation model.

Furthermore, an index is used to find the needle in the haystack. A cube is used to aggregate the...

Maybe you can download the evaluation edition from the SQL Server website and upgrade it to developer edition? Don't really know where you could purchase the license key though.