I agree, I enabled as many tranformations as possible to run in parallel and removed a lot of merge joins, sorts and just did a join in the oledb source...

Well I just asked our DBA how much the ssis server had and he said 8 GB and 4GB alloted to SQL Server. I have improved a package from a...

I have it running now. I'm thinking that the issue was that even after creating the SQLServer configuration I needed to go in and manually update the connection string to...

Right now I'm trying to test it in Visual Studio. Am I correct in assuming that what ever is in the configuration will overwrite whats in the package?

Message

Executed as user: HNETNT\sqlwebdev. Microsoft (R) SQL Server Execute Package Utility Version 10.50.4000.0 for 64-bit Copyright (C) Microsoft Corporation 2010. All rights reserved. Started: ...

Ok, I found a way to access the server. Somehow I needed to add /UAT to the end of the servername when selecting the server to look for the package...

I noticed that the OnError wasn't being called so I added a oledb source and selected a varchar column and then attempted to convert it to an integer to cause...

Great point Grant, thx

Thanks for the info guys. I have another idea I'd like to run by you. In the stored procedure the temp tables are being created with a select .... INTO...

Oh one more thing...Its using transactional replication

One more question. We have the transactional replication in place. Every 5 minutes we are running jobs executing tsql merges from the subscriber database tables (I inherited this) to various...

Thanks Gail, it turns out transactional is exactly what we need.

What is the difference between transactional replication and merge replication? Does either immediately upsert the data in the subscriber database?

Would it be possible to create triggers on the OLTP database to perform the same inserts and updates on the reporting database?

Can this be done with mirroring?