You have at least 1 duplicate primary key value. An easy way to identify the rows that have duplicate PK's is to change the source to redirect error rows...

How about this:

[font="Courier New"]SELECT

   *

FROM  

   INFORMATION_SCHEMA.Columns

WHERE

   is_nullable = 'YES'[/font]

How will you identify the bad data? Will it be based on an error when inserting into the destination?

If you will be identifying the bad data based on an...

You should use a Query as your source in SSIS. So your query would be something like this:

[font="Courier New"]SELECT

   columns

FROM

   TABLE

WHERE

   -- all the calculation does is return midnight...

You use the SQL Server Configuration Manager.

Apparently you cannot use a variable set in the Row Count transformation in the same Data Flow. Check out the discussion on this blog post:

http://blogs.conchango.com/jamiethomson/archive/2005/05/29/SSIS_3A00_-Using-the-Rowcount-component.aspx

Here are a couple of articles I found based on the Exception:

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

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

http://www.sqlnewsgroups.net/group/microsoft.public.sqlserver.server/topic4751.aspx

Are remote connections allowed on the SQL Server? By default SQL Server 2005 does not have Named Pipes or TCP enabled.

You can also go to the Report Manager Web Page, select Properties and Click Edit Report. This allows you to download the rdl file.

I'm not sure that there is anyway to have dynamic columns in a report. Do you mean that one time you would return 10 columns and the next 7?

You could use SSIS to do this. You would want to do a Data Flow Task where your source query is the SP and your destination is the Excel...

I understood what you were looking for, which is why I said that the script I linked to would be a starting point. If you use the script I...

(Dt_STR,4,1252) does not define a string large enough to hold the results you are returning. You need at least (Dt_STR,7,1252)

I actually expected that error because your varchar columns are all defined with a length of 1. This is the number in parentheses. When you define a character...

I would go with the job. I agree with Barry that using Profiler would help you identify what is currently happening, I also believe that the current design is...