Results 1 to 3 of 3
  1. #1
    Join Date
    May 2010
    Posts
    52

    Unanswered: BIDS is 2008 and SQL Server is 05

    so i have designed SSIS packages that execute a stored procedure. the packages were designed in BIDS 08 and the stored procedures are sitting on a 05 box. i thought i could not execute SSIS packages designed in BIDS 2008 on a 2005 SQL Server Box.
    NB i am executing the packages straight from BIDS. may someone please explain why i can execute the SSIS packages

  2. #2
    Join Date
    Jan 2007
    Location
    UK
    Posts
    11,434
    Provided Answers: 10
    If you're running it straight from BIDS then you're using the 2008 dtsexec.exe
    The 2005 server only has the 205 version of dtsexec installed.
    George
    Home | Blog

  3. #3
    Join Date
    May 2010
    Posts
    52
    makes sense, thanks

Posting Permissions

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