The requirement is to load a table (in server A, database A) with a query which involves selecting data from three different servers, three different databases and 3 different tables. The query is very simple as select, from, where, group by and order by. They are asking me to design an SSIS package for this. Daily data gets loaded. What I did is in my package, I added an execute sql task and run it as a job. Though this package gets the job done, I know it wouldn't be that simple. Any idea of overall ssis package would be really helpful.