title: Is it possible to use multiple data sources inside an SSIS package under the OLE DB connection manager?
body: <p>The query is used for inserting new records only.</p>
  
  <p>How can I use this query? whether the sql script is inside the Execute SQL Task: SQL command task or OLE DB Source: SQL Command task when using 4 different Data sources(databases) such as database A,B,C and D. </p>
  
  <p>In the Data Source under the Solution Explorer, I added four databases under one server, these are database A,B,C and D. Would it be possible to add four databases with four corresponding data source inside the OLE DB connection Manager??</p>
  
  <pre><code>OLE DB connection manager: Database/Data Source A, B, C, D &lt;--- Is this possible??
  Data Access Mode:
  SQL Command
  
      SQL Command Text:
  
      Insert into DWResourceTask.dbo.DimEntity
  
      select 
      a.EntCode, 
      a.Name, 
      a.Active, 
      a.AccessLevel, 
      a.SiteURN, 
      a.CompanyURN,
      a.SiteName, 
      a.SiteDesc, 
      a.SiteURL
      from 
      (Select e.EntCode, e.Name, e.Active, e.AccessLevel, ss.SiteURN, ss.CompanyURN,
      ss.SiteName, ss.SiteDesc, ss.SiteURL
      from A.dbo.Site ss, A.dbo.LegalEnt e
      where ss.localsiteflag = 1
      and e.active = 1
  
      UNION ALL
      Select e.EntCode, e.Name, e.Active, e.AccessLevel, ss.SiteURN, ss.CompanyURN,
      ss.SiteName, ss.SiteDesc, ss.SiteURL
      from B.dbo.Site ss, B.dbo.LegalEnt e
      where ss.localsiteflag = 1
      and e.active = 1
  
      UNION ALL
      Select e.EntCode, e.Name, e.Active, e.AccessLevel, ss.SiteURN, ss.CompanyURN,
      ss.SiteName, ss.SiteDesc, ss.SiteURL
      from C.dbo.Site ss, C.dbo.LegalEnt e
      where ss.localsiteflag = 1
      and e.active = 1
  
      UNION ALL
      Select e.EntCode, e.Name, e.Active, e.AccessLevel, ss.SiteURN, ss.CompanyURN,
      ss.SiteName, ss.SiteDesc, ss.SiteURL
      from D.dbo.Site ss, D.dbo.LegalEnt e
      where ss.localsiteflag = 1
      and e.active = 1
      )a
  
      where not exists (select * from DWResourceTask.dbo.DimEntity w
                        where(a.EntCode=w.EntCode
                              and a.Name=w.Name
                              and a.Active=w.Active
                              and a.AccessLevel=w.AccessLevel
                              and a.SiteURN=w.SiteURN
                              and a.CompanyURN=w.CompanyURN
                              and a.SiteName=w.SiteName
                              and a.SiteDesc=w.SiteDesc
                              and a.SiteURL=w.SiteURL))
  </code></pre>
  
  <p>Please Help. Thanks in Advance!</p>