• Hi Steve

    I changed the table and package to contain and use connections strings, since all my servers are in different domains, so integrated security is not use full for all. And I have a unique login account on all boxes anyway, so I just use this. In the package I of cause set the connection string variable instead of the server one.

    If I want the package to gather server specific data like @@Version, I never found a nice way to avoid getting it to return a result for all db's on a server. The crappy solution I finally came up with, was to change the select in the get data OLEDB source to "select distinct.....". Any ideas how to change this behavior?

    //SUN