Hello John.. thanks for your reply....

I'm getting this error, when tried to run it

[Execute SQL Task] Error: An error occurred while assigning a value to variable "Variable": "Unable to...

Thank you... let me try it

Thanks Again

Thank you for your reply....

can you please allobrate the step you mention, how to pass the value from the "execute sql task" to ADO.NET connection source (in btw... we are...

Yes, I can use SSIS.. but I'm not sure how to setup the Insert, Update and delete commands in SSIS. In other words... I actually want to compare my source...

Hi Ron,

Here is the output of that T-SQL query:

Object_Name ...

Thanks for the reply....

Hi,

Please refere this article:

http://sqlblog.de/blog/2009/07/linked-sql-server-encrypted-connection/

Thanks

Hi,

I dont have any special Issues, but it's good if you re-create Linked server after you upgrade your sql server and after you migrated Logins and SIDs to new server.

With...

Perfect.. Thanks Ninja's_RGR'us and Gila

Hello GilaMonster,

Thanks for the reply and me personally your answers will help a lot and thanks for that.

I am watching TempDB size, but my question is can I add "Set...

Hi Gianluca Sartori,

Your valauble helps me a lot. Thanks for all your advices

Thanks

Hi Gila,

Thanks for the reply.

Here is the sample Insert statement of the XYZ table:

INSERT [dbo].[XYZ] ([cacheId], [TrackingNumber], [FormID], [CCIPortID], [OriginStationID], [DestinationStationID], [DestinationZipCode], [CarrierOID], [SentToSPSS], [ProcessedBySPSS], [SpecialSorted], [SepUID], [UpdatedTrackingIndex], [OkToSendToSorter], [RouteID],...

Hello Gianluca Sartori,

Thanks for the reply

The name table-1 is just a dummy name, it's not the real name of the table

We are using Nolocks because in my application select, Insert,...

Hello,

I am getting the same error "No replicated transactions are available". I am getting in the Log reader agent. When I run the command SELECT SUM(rows) FROM sys.partitions WHERE object_id...

Thank you so much SQL Experts, that would be a gr8 help 🙂