Hi , I have source db "SourceDB in domain "CAT" and destination DB 'DestDB" in domain "Saturn". Now I want to extract data from Sourcedb to Destination db in different domain. But I face unable to connect to destination source error. Please suggest. Thanks V. Mahadevan

Permissions? What is the problem?Best Regards, Uri Dimant SQL Server MVP http://dimantdatabasesolutions.blogspot.com/ http://sqlblog.com/blogs/uri_dimant/

Hi Mahadevan, 1) This is possible. 2)The account with which the SSIS package is being executed should have the write access on the destination server which can be in a different domain.Happy to help! Thanks. Regards and good Wishes, Deepak.

1) You might try to run this SSIS with a service account or an account which has access to different domains. I have experienced the scenario where I need to load the data from a server on a different domain. There was a service account which had access to servers in different domain. 2)Check if there is one in your scenario.Happy to help! Thanks. Regards and good Wishes, Deepak.