Run queries against diffrerent databases and/or SQLservers

• fasttrack

  SSCertifiable

  Points: 6071

  More actions

  August 10, 2007 at 10:47 am

  #121027

  Hello,

  I am new in SSIS.

  I am using an OLEDB source and setted as SQL Command.

  The Query is a JOIN between different databases.

  How can I make the QUERY with different source (different databases or SQL Servers)?

  I mean, any solution is OK,  the important is to make queries against different databases with SSIS.

  Thank

• fasttrack

  SSCertifiable

  Points: 6071

  More actions

  August 10, 2007 at 6:32 pm

  #726256

  Hello,

  for everybody:

  Using a Join Trnsformation to make what I need