April 29, 2011 at 12:33 am
Hi,
I am a SQL Server DBA with limited knowledge in SSIS. I have a 64-bit windows 2008 server where a 64-bit SQL Server standard edition was installed along with Integration Services. Everything works fine till here.
Now, I added a new instance of SQL Server 2008 R2 version and chose just the 'Database Engine' from the setup choices (Integration Services were not touched). Now ,when I open a package from Visual studio, I get an error:
Error1Error loading 'Importfinal.dtsx' : Could not load type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPackageSigning100' from assembly 'Microsoft.SqlServer.DTSRuntimeWrap, Version=10.0.0.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91'..C:\Users\admin\Desktop\Importfinal.dtsx11
Please help me as I am seeing such problems reported elsewhere too but solutions are not emntioned clearly.
thanks
Chandan
April 29, 2011 at 12:52 am
I am all alone and before someone replies with an elegant answer, I have used the following workaround.
When I had installed SSIS with 2008 version ,BIDS was included too during that installation. When I installed SQL2008R2, I had installed just the database engine. today I ran the R2 setup again and this time I chose shared component features only like Visual studio, client Backward compatibility etc.
Now BIDS is there in both SQL2008 and SQL2008R2 and I can open the packages again as the Visual studio is upgraded too.
Can someone provide me with a more elegant solution. I never upgraded my SSIS-2008 to R2 version, so why my packages were not opening when I simply installed 2008R2 database engine.
Regards
Chandan
April 29, 2011 at 1:07 pm
on which version you have created those SSIS packages
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
Regards,
Syed Jahanzaib Bin Hassan
BSCS | MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
www.aureus-salah.com
May 1, 2011 at 10:58 am
Syed Jahanzaib Bin hassan (4/29/2011)
Regards,
Syed Jahanzaib Bin Hassan
MCTS | MCITP | OCA | OCP | OCE | SCJP | IBMCDBA
My Blog
http://www.aureus-salah.com[/quote%5D
The SSIS packages were created by the visual studio which got installed by the sql 2008 setup. If you need exact version number, I will find it out tomorrow.
As you can see, if those packages are of sql 2008 version and when i ran the setup for sql 2008 r2, i chose only database engine and nothing else.
Still i had following problems:
-Could not edit earlier package
- Management studio on the server showed just 'Database engine' and Compact edition' to choose from while connecting.
So i had to run R2 setup again and chose BI and management tools then all the problems got solved. Cant say why it happened!
May 2, 2011 at 4:32 am
Has anybody experienced this issue before?
May 18, 2011 at 7:37 pm
August 9, 2011 at 8:25 am
See the final post here:
That's what fixed it for me...
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply