Gkhadka (12/22/2009)
Yes.....you are right, if he already have installed SQL 2008, then there is no need for new liscense for SSIS. SSIS comes with SQL.I think the main concern for him that his developer is not able to build/design ssis packages through his local machine.
If I were you than I would reinstall the SQL CLient tools and SSIS service agian in developer local machine. I am thinking that something went wrong during the installing process.
You still have to have SSIS service running locally (in developer local box) to build and design ssis packages. Installing just BIDS is, i think, not enough. Correct me here someone if a I am wrong.
For troubleshooting the SSIS error - we need more detailed information.
To run BIDS and develop SSIS packages - the local SSIS service does not need to be running - just verified by testing the creation of a new package.
acapucion - please provide detailed info concerning the error message if you would like that issue discussed.
Jason...AKA CirqueDeSQLeil
_______________________________________________
I have given a name to my pain...MCM SQL Server, MVP
SQL RNNR
Posting Performance Based Questions - Gail Shaw[/url]
Learn Extended Events