Yep sure did but I think I figured it out.  The database is much larger than usual.  I have an alert that checks the threshold on this database and I...

Have you tried changing the xls. to csv.

Just to let you know stopping and re-starting the sql agent fixed the problem

Thanks.  I must have had a brain fart.  I was thinking way to complicated

I also found out that if you enable dynamic properties and nested query by creating a new link server and selecting Microsoft OLE DB Provider for sql server will enhance...

Ok we ran into it again.  it seems like it only happens on 1 and the 16 of the month.  Mid_month and end of month.  There is a step in...

we actually just recreated the whole package and it worked. Thanks for your help though. I will keep this mind next time we come across this situation

here is the actual error I recieve

Step Error Source: Microsoft SQL-DMO (ODBC SQLState: 42000)

Step Error Description:[Microsoft][ODBC SQL Server Driver][SQL Server]Line 1: Incorrect syntax near '?'.

Step Error code: 800400AA

Step Error Help...

Thanks I was able to find out there was a backup being done by the admins at the same time. 

Thanks so much From now on all the procs will be tracked

I am using profiler and found the objectid for that table.  Do you recommend any other parameters to capture this information

Thanks.  There is a table that gets populated somehow and the previous DBA does not have this documented therefore I need to know how the data is getting populated into...

That worked Thanks much