Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2006
    Posts
    115

    Unanswered: How do I run SSIS ?

    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?

    Thanks!

  2. #2
    Join Date
    Oct 2006
    Posts
    115
    nobody? possible to generate the SSIS from standard edition and use dtexec to run it in the express edition??

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •