That is a great point, but if you have to do what you are asking to do, I would suggest you add a second data source to your report and...

Build a report in Reporting Services.

Step 1 of dealing with digging yourself into a hole is to stop digging.

Here is what I think your situation is.

You have a procedure with some relatively complicated logic in...

The parse button does not work with question mark (?) parameterized queries. Does the task execute successfully?

If you set your packages to DontSaveSensitive the package will not store the passwords, but you can use package configurations to store the connection passwords.

This happened to me once with a bad install of SQL.

Re-install the client tools and re-apply any service packs.

I have used it extensively and run into issues, but nothing that I would call a "brick wall".

For instance, it is not compatible with older Oracle OLEDB drivers - so...

You will need to use a merge join and then a conditional split.

Merge join on the = fields and then pull out the <> fields into another data flow in...

If you have any experience with a .Net language, the script component will be easy for you to use this way.

Just try it, drop a data flow task into your...

You have two options.

First, the Script Task can act as a control flow component, a data flow source, a transformation, and a data flow destination. So for your example,...

It's all about column positioning.

With an ALTER statement, you cannot specify an ORDINAL_POSITION so the column will always be added to the end of the table. If you want...

Ah - sorry, read the post quickly.

For a test, run the report, clear the cache manually, and then run the report again.

At the end of your query add:

OPTION (RECOMPILE)

This will...

Try eliminating the plan caching issue:

CREATE PROCEDURE MyProc

WITH RECOMPILE

AS

....

This will force the procedure to generate a new plan every time it runs. If this solves the issue, you need...

I personally would use the second option - if someone was holding a gun to my head telling me to write a cursor.

Either way will work and micro-managing between these...

You cannot - if you were able to kill a rollback, it would leave your database in an inconsistent state. If you stop and start the SQL service, it...