if my data is residing at SQL 2005 Express?
Okay, here is the scenario. ServerA contains some data but stored under SQL 2005 Express. ServerB contains another set of data and stored under SQL 2005 Standard Edition. I have to export data from ServerA to Excel via DTS manually (which can be saved as dtsx, the SSIS packages) . Can I make use of the resources in ServerB to run the SSIS packages? DTS is good but there are too many steps.
I do not have the DBA access to ServerB, what shall I ask the DBA to grant me in order to run this SSIS against the remote SQL 2005 Express sitting on ServerA?