Yes, I just looked, that is the correct task type.

It just runs another SSIS package.

It looks like remote.exe is the correct utility from MS.

There are third party utilities available also - search in your favorite search engine.

RCMD is a command line utility that remote executes a command on another machine. There are dozens of tools like it available. Look at what is in the...

Create a new package.

Add 10 Execute SSIS tasks to the control flow - don't connect the arrows together.

Point each of these at the 10 packages you want to run in...

Make sure your clustered index is an efficient index for the lookup. If you have a clustered index on say a bit field, you end up having to scan...

You will probably get more overhead adding it into the source SQL than you will adding it in through a derived column component. Adding it into the source means...

Job steps run sequentially.

You either need to create 10 jobs, or you need to create one package that calls the other 10 packages in parallel.

You need a utility like RCMD that will allow remote command line execution.

Here are two more options:

[font="Courier New"]SELECT DISTINCT

T1.*

FROM

myTable T1

LEFT JOIN myTable T2 ON T1.BatchID = T2.BatchID

AND T2.Status = 'Rework'

WHERE

T2.BatchID IS NULL

SELECT

T1.*

FROM

myTable T1

WHERE

NOT EXISTS (SELECT * FROM myTable T2 WHERE T2.Status =...

Yes, it has to buffer the data it is going to show in the output window.

You are probably somewhat deadlocking yourself. The BCP cannot access the record because it is exclusively locked from the insert statement. You could use a NOLOCK hint in...

I forgot to add, peer-to-peer transactional replication may work for you as well if you are using the Enterprise Edition of SQL.

Well then, I believe the answer is no.

I do not believe you can use MS SQL replication services and make a MySQL database your publisher.

I was not paying close attention...

You need to remove the MAX() out of the case statements in both the select list and group by clause. The case should read:

[font="Courier...

Why not just make your first SQL statement return the data?

[font="Courier New"]SELECT @sqlstmt='SELECT ROW_NUMBER() OVER (ORDER BY ' + @col_name + ') AS display_id f_name,l_name,city,state from tblx ORDER BY '...