Sounds like there is not a 64 bit IBMDASQL driver. I know that I had problems with SQL 2000 and IBMDASQL linked servers and preferred using the ODBC driver...

Is the PC up to the latest version of IE? What version of Excel is on the person's PC?

Have you run a TX Log backup? That should allow you to shrink the TX Log. Otherwise you should be able to shrink the DB as long as...

In addition to GSquared's questions/comments:

Do you have to return all the columns?

I am actually surprised you are getting a clustered index seek since you are using "<>"...

I think this is what you are looking for:

[font="Courier New"]DECLARE @sql NVARCHAR(1000)

SELECT @sql = 'create table ey_report_temp (county nvarchar(100),fname nvarchar(100),  ' +

           STUFF((SELECT DISTINCT ',[' + sport + '] nvarchar(10)...

Just a little note you should be using "=" instead of "like" since you are not using any wildcards.

It depends. If you do it from the UI, then you have n calls to the DB, each within it's own transaction or the UI developer has to manually...

You could have a "Check for data step" that sends an email when there are no records returned. Or, I don't know how Oracle would work, but in SQL...

Because the query is being executed in the context of DBMail it is executed within the master database so you need to fully qualify your object names in the query,...

I'd ask for a delimited string create a udf to handle delimited strings.

Wouldn't it make sense to exclude data in your source query instead of loading it and then checking it in ssis? Select x from tble where date = today-1.

The SQL Server Service itself does not run as 'SA', SA is a SQL Server user NOT a windows user. The SQL Server Serivce is a Windows Service, like...

My bad, remove from the ON to the GROUP BY in the first CTE and correct the other issues you have found. Just bad typing and deleting by...

THe SQL Server Service Manager which runs in the system tray or in the services applet. Most likely it is running under local system which has no network rights...

I don't think xp_cmdshell runs under your user rights, I think it runs under the rights of the SQL Server service. So, referencing a location using drive letter will...