Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
sarahmfr
Posting Yak Master
214 Posts |
 Posted - 2011-09-28 : 16:28:55
|
| I created a package and I can execute if successfully by right clicking the package. I am using sql server 2005I changed the properties to createdeployment utility to yesI want to deploy the package to sql serverOn right clicking and say build the build is successfulthe manifest is created. I am used to sql 2008 but this is sql 2005on double clicking the manifest I get the following error retrieving the com class factory for component with cls" and "failed due to the following error: 80040154 (microsoft sqlserver manageddts)"What I am doing wrong?I have windows 2008 server 64 bit and sql server 2005sarah |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-28 : 23:01:15
|
| you've created package in 2005 and trying to deploy in 2005 itself rite?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
sarahmfr
Posting Yak Master
214 Posts |
Posted - 2011-09-29 : 12:11:07
|
| yessarah |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-09-29 : 12:51:57
|
| did you try rebuiding solution and trying deploy using newly created deployment utility?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
error message deploying a package in sql 2005