Running:

Update table

Set char_field = Rtrim(char_field)

Does not actually trim as the char data type is fixed width so the data is right padded with spaces. ...

You have either not entered the name of the SQL Server correctly or the login does not have rights to the SQL Server.

I have only seen this error in a script component in a data flow task and it is because I did not click okay when exiting the component, I clicked...

Okay, now I understand the issue better.

You want to set the error output on your destination to either ignore error or redirect row, the issue is the that, what if...

I think you need to do it with an SP as I cannot find a way to break after n records.

The "With" defines that you are creating a CTE (Common Table Expression) and it needs to be the first part of a statement. You need to either put

";...

I don't think that there is a way to apply different formats to parts of text in a textbox. You need to use multiple textboxes to do this I...

Your other option is writing a custom aspx page with the parameters and calling the report passing the parameters and making password a hidden parameter.

Well you won this time and with a better solution.

If you want to insert new records and keep the old then this will work:

[font="Courier New"]SELECT

   *

INTO

   #data

FROM

   tableA

WHERE

   bspid LIKE '%CI11%'

INSERT INTO tableA

   SELECT

       [columns],

       'MHCIRC1208' AS bspid

  ...

Yeah me too! Just glad I was first this time.:D

How are you merging the data from the sources? It's not clear to me if you have 2 or 3 sources? Is the reject a destination or a...

I don't have any experience with clusters, but it sounds like to each node has its own plan cached for the query. Try executing it on the slower node...

This should work:

[font="Courier New"];WITH cteCountByNameType AS

   (

   SELECT

       firstname,

       lastname,

       itemType,

       COUNT(*) AS itemCount

   FROM

       myTable

   WHERE

       created >= @start_date AND created < @end_date

   GROUP BY

       firstname,

       lastname,

       itemType        

   )

  ...

Have you tried running DBCC InputBuffer(blocking spid) to see what the blocking spid is doing?

Have you run sp_lock [blocked spid] to see what resources the job can't access?