I have more number of CPU's on my server. How to enable the multi-processor ?

Is that always good to take advantage of multiple CPu's or else any drawbacks or limitations...

Hi Perry,

Can you provide the tech article what you have mentioned.

It would be great help for everyone.

Thanks 🙂

You are absolutely right!! My only point was to identify/understand the LSN sequence looking at the system catalog! Is that possible or not. You have put in all the...

Hi Civy,

I replied to the wrong post.

Thanks 🙂

This has to be executed on the source sql server and take the output and execcute it on the target sql server. Right??

Correct me if am wrong!!!

Thanks.

This has to be executed on the source sql server and take the output and execcute it on the target sql server. Right??

Correct me if am wrong!!!

Thanks.

At last,Found it my self.

Hope it helps other team members :-))

You can generate the script from GUI mode itself and append the DTEXEC in front of the command line

Way-1

------

DTEXEC...

I have created the package on dev which has Visual Studio 2008 and am trying to add to a project on target server which has Visual Studio 2005.

Does it make...

This time i tried differently

For double cross checking purpose , i saved the package to File system and tried to again add to a different project in BIDS ,

Then...

I also tried to validate the package still............its killing me !!!

C:\>dtexec /sq TestPkg /ser cscthcdbche1 /va

Microsoft (R) SQL Server Execute Package Utility

Version 9.00.1399.06 for 32-bit

Copyright (C) Microsoft Corp 1984-2005....

I went to the target server where integration services is running and done the following. still not getting ....

C:\>DTExec /sql "TestPkg"

Microsoft (R) SQL Server Execute Package Utility

Version 9.00.1399.06 for 32-bit

Copyright...

I have created a package in SQL 2008 BIDS and saved in a NAMED instance.

To verify whether it is saved or not, I also connected to SQL Server Integration Services...

I have explicitly created a user who has db_accessadmin,db_datareader roles on db1 and db2 and supplied that user and pwd of that login in the Linked Server then it worked...

I was expecting an something like below.

Server: Msg 7314, Level 16, State 1, Line 1 OLE DB provider 'DC' does not contain table '"db2"."dbo"."t1"'. The table either does not...

Pl find the generated script.

The script contains password as NULL and when i execute the same script to reconfigure , it is throwing me an error saying cannot be NULL...