.NET Tutorials, Forums, Interview Questions And Answers
Welcome :Guest
Sign In
Win Surprise Gifts!!!

Top 5 Contributors of the Month
Gaurav Pal
Post New Web Links

Error opening an DTSx package

Posted By:      Posted Date: May 22, 2011    Points: 0   Category :

Hi everyone,

I get this error when I try to open a DTSx package in my machine, can anyone help me ? I've all the dlls that I need ( at least the ones that I think I need ) registred on assembly and in the right places. 

Uploaded with ImageShack.us





Thanks a lot for your help

View Complete Post

More Related Resource Links

BIDS Error loading 'Package.dtsx' in 2008


So everything was working grand. I had both SQL2005 and 2008 installed and were working together just fine. Then I installed 2008R2. And everything was still fine minus the fact that I couldn't run anything with the dtexecui.

I have 2 computers that mirror each other in what's installed on them. SQL2005/2008/R2 were installed on both of them. Then when I started having package issues, I uninstalled R2.

Computer A works fine. After I uninstalled R2, I reinstalled the components from the sql2008 disk and packages work/open/run with dtexec/ui

On Computer B (which is the more important one of course) I get this error when trying to open a package (in bids).

Error    4    Error loading 'Package.dtsx' : Could not load type 'Microsoft.SqlServer.Dts.Runtime.Wrapper.IDTSPackageSigning100' from assembly 'Microsoft.SqlServer.DTSRuntimeWrap, Version=, Culture=neutral, PublicKeyToken=89845dcd8080cc91'..

And then it gives me the little red x in the right corner.

I tried re-registering everything based on this post http://social.msdn.microsoft.com/Forums/en-IE/sqlkjsetupandupgrade/thread/5ed7480b-2ca5-48de-bd3b-4b3752237c31 and that didn't work.

Then I uninstalled SQL2008, reinstalled, applied SP1, it still didn't work. Then I re-registered things again and it still d

Error when opening Infopath Form


Background: Created an Infopath 2003 form with 2 views (1 as Read-Only View and another 1 for Submitting content) and published to a Sharepoint 2007 Library.

Working: When a user opens a new form it opens in submit view; once the form has been submitted, when the user tries to open again, the form opens in read-only view.

Error: 99% of the users do not face any issues, however when the the rest 1% of the users try to open a new form; they receive the following error and are unable to open the form.

Form template: _http://server/sites/subsite/library/forms/template.xsn
InfoPath cannot open the following view: Edit_View
The following view file is not valid: view1.xsl
The file is not a valid XML document.

An invalid character was found in text content.

Line 673, Position 12

I am not sure what is wrong here (or) from where this error is being generated!

Balaji Baskar [Please mark the post as answer if it answers your question]

Error while executing a package through SQL Server Agent

Hi All,   I have a ssis package. It has 3 tasks, first task updates a record in Oracle database to set an Indicator to “Y”, second task process SSAS Cube and the third again updates the same record and sets the indicator to “N”. This package has 2 data sources, one is Oracle and the other is Analysis Services. I gave the credentials for the Oracle and use NT Authority for Analysis services.   When I am executing from BIDS package is executing successfully. But when I am calling the job to execute this package its throwing me the error. Below is the error.     Message Executed as user: User\Username. ...ion 9.00.4035.00 for 64-bit  Copyright (C) Microsoft Corp 1984-2005. All rights reserved.    Started:  10:57:46 AM  Error: 2010-08-27 10:57:46.79     Code: 0xC0016016     Source:       Description: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.  End Error  Error: 2010-08-27 10:57:47.16     Code: 0xC0202009     Source: Ord_test Connection manager &q

Just-In-Time Debugger error when opening SQL Server studio express

Hi,   I am new to these forums; hope I am posing in the correct forum   I have problem opening the SQL Server 2005 Management Studio Express. Getting the error below   'An unhandled win32 exception occurred in ssmsee.exe [5336]'   Searched in many forums but none of the suggestions resolved my issue..   I have re-installed .net 2.0, upgraded to 3.5 but still no luck either   Have re-installed SQL server management studio express again no luck   Deleted the shell folder from both documents and settings and in registry still have the same problem   Appreciated your suggestions to resolve this issue   Many thanks

Error opening an Infopath form

I am trying to open an Infopath xsn form and I get the following error - "infopath cannot load this form. Either the signature is corrupted, or the certificate used to sign this form is expired or revoked. Contact the author of the form." I am the author of the form. I tried calling my cellphone number but there was not answer. Anyway, I've encountered this error before and I ended up redoing the form from scratch. I don't want to do that obviously. Is there a way to open the form somehow?Thanks,Dave

WSS2.0 opening pdf documents an error message appears: The document could not be saved. The file may

Hi All,. In a WSS2.0 document library, a user is trying to open pdf files. However, an error message is displayed: 'The document could not be saved. The file may be read only, or another user may have it open. Please save the document with a different name or in a different folder'. No one else has the file open. When the user saves the file using Save As (as it is apparently Read Only) and then saves the file back to the SharePoint site, all previous versions of the file disappear. The user has noted that this has been happening since today, and she had some other network issues that have been resolved. No other users are experiencing this problem.  Not sure if this problem is related to the network problems the user was facing. I've had the user reboot but this has not resolved it. Any ideas?

SSIS Package working on SQL Client Machine but when trying to run on SQL Server machine giving error

Hi We are trying to run SSIS package on sql server machine but sometimes it is giving error for data flow task containing Script Component. Error is - [SSIS.Pipeline] Error: component "SCR DimensionRelation" (1) failed the post-execute phase and returned error code 0x80004002. This error is not coming continuously. And also not for specific DFT. It comes for different DFTs as we rerun the package. Can anybody help me on this? We are using SQL server 2008. We are not getting any error on client machine :(:(

Error Importing SSIS Package

I can't import a package from the SSIS to the file system of my SQL Server Management Studio. Every time i've tried the following message appears. What should i do to correct this problem? Any ideas?   =================================== Invalid access to memory location. (Exception from HRESULT: 0x800703E6) (Microsoft.SqlServer.ManagedDTS) ------------------------------Program Location:    at Microsoft.SqlServer.Dts.Runtime.Application.SaveToDtsServer(Package pPackage, IDTSEvents pEvents, String sPackagePath, String sServerName)   at Microsoft.SqlServer.Dts.ObjectExplorerUI.ImportPackageAsAction.ImportPackage(ImportPackageAsForm dlg)

Get error on runing Package - ComVisible

hi all im try to run a simple package with 2 Execute SQL Task and im get this error : Error: The Execute method on the task returned error code 0x80131509 (This type has a ComVisible(false) parent in its hierarchy, therefore QueryInterface calls for IDispatch or class interfaces are disallowed.). The Execute method must succeed, and indicate the result using an "out" parameter. any help

SSIS Package returns the error - The command execution generated errors.

SSIS Package returns the error - 'The command execution generated errors'. Please let us know the cause for this error if anyone encountered this error before. Require a solution for this.   Thanks

Warning Message while i'm opening SSIS package

Hi, I'm getting below mentioned Error message whenever i'm opening the package. anybody came across same problem kindle help me to resolve the issues. "Document contains one or more extremely long lines of text. These lines will cause the editor to respond slowly when you open the file. Do you still want to open the file?"   Regards, Sabarinathan

.net framework 3.5 full package error in installation

i downloaded the full package and when it went to the install part it started then it said an error has occurred deleting all files downloaded :( i have windows xp professional, 200gb hard drive 1.5gb ram hp pavilion a1310n i get this error msg plz help [04/11/10,19:44:09] Microsoft .NET Framework 2.0a: [2] Error: Installation failed for component Microsoft .NET Framework 2.0a. MSI returned error code 1603 [04/11/10,19:44:28] WapUI: [2] DepCheck indicates Microsoft .NET Framework 2.0a is not installed. [04/11/10,20:01:47] Microsoft .NET Framework 3.0a: [2] Error: Installation failed for component Microsoft .NET Framework 3.0a. MSI returned error code 1603 [04/11/10,20:02:08] WapUI: [2] DepCheck indicates Microsoft .NET Framework 3.0a is not installed. [04/11/10,21:13:34] Microsoft .NET Framework 2.0a: [2] Error: Installation failed for component Microsoft .NET Framework 2.0a. MSI returned error code 1603 [04/11/10,21:14:01] WapUI: [2] DepCheck indicates Microsoft .NET Framework 2.0a is not installed. [04/11/10,21:33:18] Microsoft .NET Framework 3.0a: [2] Error: Installation failed for component Microsoft .NET Framework 3.0a. MSI returned error code 1603 [04/11/10,21:33:42] WapUI: [2] DepCheck indicates Microsoft .NET Framework 3.0a is not installed.

SSIS Package Protection Level Errors - decrypt protected XML node "DTS:Password" with error 0x800900

Error 7 Error loading GetData.dtsx: Failed to decrypt protected XML node "DTS:Password" with error 0x8009000B "Key not valid for use in specified state.". You may not be authorized to access this information. This error occurs when there is a cryptographic error. Verify that the correct key is available.   c:\Packages\GetData.dtsx 1 1  Error 8 Validation error. Data Flow Task: OLEDB Source [5310]: The AcquireConnection method call to the connection manager "SourceServer" failed with error code 0xC0202009. GetData.dtsx 0 0 Environment I need to execute - BIDSHave Solution, with files linked with VSS. When I click on package, aforesaid errors show up and package opens in designed.Protection Level : Encrypt Sesitive with User KeyThis means it'd run only on machine and by user where and who created respectively.So I changed it to Encrypt Sesitive with Passoword and provided Passoword. No luckSo I changed it to Do not save sensitive, as anyways in the connection manager, it has Expression saying @Variablename (with appropriate correct syntax), and variable is mapped to config file. I tired with Config file and also by hardcoding the value in the connection manager's connection string after removing the variable name, also tried by hardcoding value in variable value and disabling config file.Nothing works. I read 3 threads discussing this issue by othe

Script error when opening document menu

Hello,   Two of our MOSS users found strange problem when they tried to open or edit document in document library. When they try to open document menu, IE gives error:   Internet Explorer Script Error Line: 578 Char: 1 Error: Object expected Code: 0 URL:  http://<servername>/<sitecollection>/<site>/<documentlibrary>/AllItems.aspx   Do you want to continue running scripts on this page? Yes / No   Can anyone help me what to do? Users cannot do anything with documents now.   Best Regards Toni

SSIS "Save copy of Package.dtsx as" is not available

Hello,I had previously upgraded my Visual Studios to 2008 Pro, and have just upgraded to SQL Management Studio 2008.  I can create/edit/upgrade packages using 2008, but when I attempt to put them on the server there is no File > "Save copy of Package.dtsx as" option available.  The only options are Save, Save as, and Save All.  Any ideas?

SSIS package is giving error when ran thru JOB...its running good when I execute in BI Studio or Exe

Friends I am getting weird issue...I built an SSIS package. In one variable I used express builder and built like this... RTRIM( (DT_STR, 2,1252)  (((DT_I4) ( (DT_WSTR, 3) (SUBSTRING( @[system::machineName] , 12, 16 ))) +1) /2)) when I run the package outside ie., with VStudio or execute utility it running absolutely with out any problem. But when I created a job just to execute that package in particular timings...the job is totally failing by throwing error....the error output is like the following: Started:  10:22:33 AM Error: 2010-02-27 10:23:06.23    Code: 0xC00470C2    Source: Rerun_MissingFiles    Description: Error code 0x80020005 occurred attempting to convert from data type DT_WSTR to data type DT_I4. Error: 2010-02-27 10:23:06.23    Code: 0xC00470C4    Source: Rerun_MissingFiles    Description: Casting expression "(SUBSTRING( @[system::machineName] , 12, 16 )))" from data type "DT_WSTR" to data type "DT_I4" failed with error code 0xC00470C2. End Error Can any one help me please? Thanks in advance.

The PerformUpgrade method failed opening SS2008R2 package on SS2008SP1

A colleague of mine developed a package with Visual Studio 2008 SP1 and SQL Server 2008 R2. When he handled the package to another colleague that had Visual Studio 2008 SP1 and SQL Server 2008 SP1 installed, the following error occurred for every ADO.NET Destination: Error 1 Validation error. Process File Detail: Process File Detail: The component metadata for "component "<component name>" (2135)" could not be upgraded to the newer version of the component. The PerformUpgrade method failed. <package name>.dtsx 0 0 Since I also have SQL Server 2008 R2 installed on my machine and the target environment is SQL Server 2008 SP1, do I need to downgrade my SQL Server installation, or is there a way for a developer with SQL Server 2008 SP1 to open and compile the packages?Paulo Morgado
ASP.NetWindows Application  .NET Framework  C#  VB.Net  ADO.Net  
Sql Server  SharePoint  Silverlight  Others  All   

Hall of Fame    Twitter   Terms of Service    Privacy Policy    Contact Us    Archives   Tell A Friend