Your trigger is referencing another database:

dbname.dba.tb_table2

If that database does not exist on the second server - or has different data, your trigger may bahave differently.

This is one reason...

I worked for a company that did a lot of mass marketing and one thing the owner was completely against was trying to proper case legacy name information (and I...

It's one of those days.

Apparently all of my posts today are going to be to tell people to post their sample data in a useable format.

Putting your sample data in a useable format will get more people to reply.

http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

It would really help if you made your sample dataa easier to use:

http://www.sqlservercentral.com/articles/Best+Practices/61537/[/url]

sqlcmd -S IP address,port -U username -P password -Q "query"

Notice the captial "Q" - this will run the command and quit.

Either I do not understand what you are trying to do, or you do not understand configuration files.

The configuration file is applied when the package first starts running. Any...

Look up "Checkpoints" in SSIS. It is designed to save checkpoints so it can restart where it left off.

You could also handle this through the control flow and some...

You indicate you want to use replication, but you have not said what kind of replication and what you need the replicated database for.

Will changes be made to the database...

I assume you mean:

exec xp_cmdshell 'perl script.pl in the ticks'

What error are you getting? Is xp_cmdshell enabled? Do you have the appropriate permissions or proxy configured?

Without defining "correctness" there is little to tell you.

SSIS and MSSQL will verify that your data matches the data types in your desintation table and error if the data does...

You can use a second package with a loop container and run your package within the loop. Package configurations will allow you to pass a variable value from the...

You haven't really posted much information here.

What type of data source are the records coming from?

Are the records being dropped in the source, destination, or lost in one of the...

Ninja's_RGR'us (1/29/2009)

---

Greg Edwards (1/29/2009)

---

So when The Thread gets a 100 posts or so,...

GilaMonster (1/29/2009)

---

What I'd suggest is, instead of sending the mail direct from a trigger (which is usually a bad idea anyway), have the trigger write the info for the mails...