Remoive the insert statement from your code so you can see the results of your query. You will see that you are getting multiple records returned by your select...

Profiler is probably going to be the easiest and fastest way to find the process causing the problem. Are you using sp_who or sp_who2 to find the blocking process?...

Are the report server database server and IIS server the same machine? If not you need enable kerberos within the domain in order to use a trusted connection. ...

Before killing the process that is holding the locks you can run DBCC InputBuffer([spid]) which will give you the last sql statement executed by the given spid.

I don't think you want to use the bulk insert task for this. The bulk insert task is expecting the source to have the same # of columns as...

How did you migrate the 2000 DTS packages to SSIS? Are you using the Execute DTS 2000 Pakcage Task or did you re-write the packages in SSIS?

Hey Brandie, this looks like a reporting services, not Integration Services question, but I'll give it a shot anyway.

What is being returned by the datasource in the planes row, empty...

When you create a package, at the bottom of the screen there is a tab titled Connection Managers, or in the menu SSIS -> New Connection. Professional SSIS By...

Yes. You would use the Flat File connection manager and set it to use a fixed width format and you can define the width of each column. The...

It may nort be timing out in Query Analyzer, but how long is it taking to run? The timeout settings on your connection from the PHP app may be...

From BOL:

The Attention event class indicates that an attention event, such as cancel, client-interrupt requests, or broken client connections, has occurred. Cancel operations can also be seen as part of...

Yes you can install 2000 and 2005 on th esmae box. One needs to be a named instance. I would uninstall SQL Express (yes it comes with VS...

Are you getting any errors when you run the stored procedure? or is the problem that you are not getting the results you expect or no results at all?

I...

Found someone else with this problem here:

http://www.devnewsgroups.net/group/microsoft.public.sqlserver.tools/topic37118.aspx

THis post suggests making sure the database compatibility level is set to 9.0 (Sql Server 2005).

EXEC sp_dbcmptlevel 'database name', '90'

If you do what Steve mentioned and use a "real" table to hold the rows you want to delete you could run the select in one pass and then have...