It is a 6 instance with 32GB of RAM, 64-bit 2005 Enterprise, I can't remember but I seem to remember 8 cores, each instance has its own portion of that...

Depending on your mapping..

Your scheduling app executes the command as a particular user, that user appears to not be mapped correctly. It might be helpful to run a trace...

I'm going to go with Transactional Replication as well.

CEWII

No probably about it, each will try to take whatever memory they want and need, even if it thrashes the hard disk or chokes out another instance..

You might see how...

First a critique

1. Temp table names have no meaning (might just be example).

2. DG1, DG2, and DG3 should have been trimmed when they were inserted into #temp5.

Suggestions/Issues

1. You cannot group...

Not bad ideas altogether. However:

C. This sounds like security through obscurity, keeping the username secret is NOT security, it also can't reallty be kept secret.

2. Any user who has...

I'm wondering if he means lookup tables and transactional data tables. Examples: lookup tables such as Customer or Customer Address and transactional tables such as Sales.

If this IS what...

Warning, I haven't used MySQL in this configuration so mileage may vary..

However, have you looked at the query plan for a representative query (or better yet the same query) on...

Good catch.. CONCAT NULL YIELDS NULL in play.. I'd bet you are right..

CEWII

There are a couple other thoughts

1. You don't have to change the connections in the package, you can change them from a SQL Agent Job.

2. You don't have to change...

I was thinking about a solution while driving accross my state this morning..

I would probably put a For-Each-Loop loop in and have it loop through the files. Inside the...

It gives you all the control you want. You can open and close the connection the way you want.

The code I gave is the starting point.. It is...

I think you'll have to move away from the built-in task and do it from a script task. You can start with this code..

Code to send mail for SSIS:

Dim...

Were you able to unzip the file with winzip or equivalent tool?

CEWII

I would probably not use that task, I'd probably do it with an EXEC SQL task, since all it really does is:

EXECUTE msdb.dbo.sp_notify_operator @name=N'operator name',@body=N'the body'

CEWII