Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Pull Data from diffrent servers - SSIS Expand / Collapse
Author
Message
Posted Wednesday, June 19, 2013 11:44 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Wednesday, April 02, 2014 4:19 AM
Points: 18, Visits: 140
Hi All,

Greetings,

I have multiple ID's (Which are data type Uniqueidentifier), I need an approach for creating SSIS package to pull the data related to ID's from different server.

for your information, the queries used to pull the data are different.

please help on this :)

Thanks,
Tony.

Post #1465460
Posted Thursday, June 20, 2013 2:22 AM


Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Wednesday, April 09, 2014 2:57 AM
Points: 704, Visits: 3,270
You haven't provided enough information Tony.

Are you pulling data from multiple SQL instances/databases?
Are the SQL instances within a trusted domain?

I would look at using the Foreach Loop Container for this kind of thing.

If you can get back to us with clearer requirements I may be able to guide you through this.


---------------------------------------------------------


It takes a minimal capacity for rational thought to see that the corporate 'free press' is a structurally irrational and biased, and extremely violent, system of elite propaganda.
David Edwards - Media lens

Society has varying and conflicting interests; what is called objectivity is the disguise of one of these interests - that of neutrality. But neutrality is a fiction in an unneutral world. There are victims, there are executioners, and there are bystanders... and the 'objectivity' of the bystander calls for inaction while other heads fall.
Howard Zinn
Post #1465506
Posted Friday, June 21, 2013 9:44 PM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:25 AM
Points: 7,070, Visits: 12,523
This might help you start learning how to connect to databases on many different instances using SSIS:

http://thesqldev.wordpress.com/2013/03/23/iterate-over-databases-using-ssis-part-2/


__________________________________________________________________________________________________
There are no special teachers of virtue, because virtue is taught by the whole community. --Plato

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy
Post #1466432
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse