I need to extract data from three different data sources in two different domain, and load it to my dataware house db. Two data sources are in one domain and 1 datsource in different domain. My package extracts data from two database in same domain but it s unable to connect to third database in different domain, please suggest V. Mahadevan

It should be possible to connect all Datasources. Maybe you need the correct permissions. What kind of Source is the third, you can't connect? SQL Server? Then try with SQL Login and Password

worth for checking windows event / SSIS error logs. seems to be some permission issueshttp://uk.linkedin.com/in/ramjaddu

Hi Mahadevan, I would suggest you to post a question with error message. I agree to the 2 other comments. Please test the database connection for the 2 domain and you can solve yourself? Thanks, Ayyappan http://sqlserverrider.blogspot.com