Hello every one, I have scenario where I need to move one SQL Server As A Tables to another SQL Server As B, both are on different remote systems. When I am trying to configure OLEDB source for server A, I do not see the Databases under that server which I have provided?? Any suggestions on this.. Thanks Please Help People When they need..!!

Why don't you use SQL Server Import and Export Data Wizard? At the end of wizard it provides the option to save your setup as an SSIS package. Once you save the package you can modify it and it will save you from a lot of effort.

Does the login you are using to connect to the remote server have permission to log in to that server? Has the login been added as a user on Server A?Russel Loski, MCT, MCITP Business Intelligence Developer and Database Developer 2008 Blog: http://www.bidn.com/blogs/RussLoski/ Twitter: @sqlmovers

Russ is right. if you can loggin in to a SQL server and not into a DB, then you dont have enough rights on that user for that db and/or sql server. good luckSincerely Nik -- Please kindly mark the post(s) that answered your question and/or vote for the post(s).

are both servers SQL Server? and do you use windows authentication? or sql server authentication? and does your account have enough privilege to source and destination databases?http://www.rad.pasfu.com

This question is duplicated: http://social.technet.microsoft.com/Forums/en-US/sqlintegrationservices/thread/9d6f71e6-6abf-4f3a-b2ea-2af53bd11311 http://www.rad.pasfu.com

Hello, Check out the threads below. It may help you. http://social.msdn.microsoft.com/Forums/en-US/sqldataaccess/thread/4c3be3e5-6609-4775-993d-6fc4cc288c21/ http://awesomesql.wordpress.com/2009/08/18/copy-all-objects-from-one-database-to-another-in-ssis-using-transfer-sql-server-objects-task/