There are other ways to avoid "SELECT *" ... if you are using Visual Studio Database Projects or the Data Tier Application (DAC), the rule of avoiding SELECT * can...

Well... using SELECT *, 1 or the column name has the same affect in an IF EXISTS clause, and COUNT(PriKey) can always be used for a count.

I have seen many posts in here saying it is good for theory, but the solution is not practical. I disagree.. this is coming from a large scale data warehouse...

What are your views on using this kind of logic in an ETL flow for slowly changing dimensions - overkill?. What about the performance implications when it goes into the...

You could create something yourself based on the sys tables

Have you stored procedure (that lists the drop down values) take a default value of 'ALL' and when the input is default 'ALL' it should return everything. Configure your report...

True.... i would recommend removing your emailid from your post

It could be that you may be getting an empty result set vs a NULL result set, which is causing the error.

See this blog for more details

http://sqlscape.blogspot.com/2009/04/execute-sql-task-failure-possible.html

What is the resultset set as?

Email relay feature is turned off in your SMTP server. If you are using IIS SMTP, and testing on your local box you can enable this feature.

Sp3, and I do have backward compatibility installed

Since i could not resolve this i had to install SQL 2000 (i did not have 2000 on my box). Still the DTS packages will not open from SQL 2005,...

Were you able to solve this? I am in the same boat. The KB fix did not work for me.

http://support.microsoft.com/kb/917406

Were you on 1.0 or 2.0

For the other errors see my blog:

Executing the query "audit.up_Event_Package_OnError ?, ?" failed with the following error: "Syntax error, permission violation, or other nonspecific error". Possible failure reasons: Problems with...