What is the best way to move n number of DTS package from
one SQLServer to another SQLServer?

Answer Posted / pratik

transfer data from sysdtspackages of msdb database to
another SQL Server

Is This Answer Correct ?    1 Yes 2 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What happens when unicode strings concatenate with non-unicode strings?

552


create index myindex on mytable(mycolumn) what type of index will get created after executing the above statement? : Sql server database administration

510


What is merge join?

582


how to overcome kernel isssues

1182


What is data mart? : sql server analysis services, ssas

607






1.what is the diff between nolock optimizer and read uncommitted isolation? 2.what is the diff between revoke and deny? 3.what is percieved down time? 4.whether password protection are required for backups?if yes why?if no why? 5.what is fill factor? 6.what is cost analysis? 7.what is mean by piece meal restore? 8.what is 'rowguidcol'? 9.impersonate permission? 10.what is selectivity?

1638


Explain differentiate between a having clause and a where clause?

523


what are the Prerequisites for Replication?

10579


What are scalar functions?

515


What is a raid and what are different types of raid configurations?

641


How do you improve the performance of a SQL Azure Database?

115


When would you use the stored procedures or functions?

587


How to drop an existing table?

559


Data is not being delivered to subscribers, what can be the possible reasons? : sql server replication

555


What is star, snowflake and star flake schema? : sql server analysis services, ssas

669