I am getting an error stating the parameter is incorrect when I open a package on my laptap. If I do it on the server it works fine. I even tried recreating my ODBC connection on my laptop thinking that might be it. Any suggestions would be appreciated.
View 2 RepliesI am getting the following error when I try to open my SSIS package
Error 1 Error loading CCTAdvocateList.dtsx: The connection "DestinationConnectionOLEDB" is not found. This error is thrown by Connections collection when the specific connection element is not found. j:cct db migrationcodecct db migrationCCTAdvocateList.dtsx 1 1
Error 4 Error loading CCTAdvocateList.dtsx: The connection "SourceConnectionOLEDB" is not found. This error is thrown by Connections collection when the specific connection element is not found. j:cct db migrationcodecct db migrationCCTAdvocateList.dtsx 1 1
The connections which BIDS is complaining about are not even there in the package. I had created these two connections some time ago but then I had removed them from the package and it was working ever since.
Suddenly I have started to get these error messages.
regards,
Abhishek.
Hi all,
the SQL Management Studio keeps crashing out on me everytime i try to open a Lookup in one of my DTS packages i am using in the Legacy section.
I am copying the DTS package across and need to change the server connections (which i do), but then i was getting a permissions based error when the package ran when it tries to access the Lookup.
I tried to open the Lookup and the SQL Management Studio hanged when it tried to display the details for the lookup. It's done this many times and i have tried different files incase one was corrupted to no avail.
Anyone have any ideas of what i can try?
Thanks
Jordan
Hi,
I got a .dts package via email. But I am not able to open it in my sql server.
Could some one pls help me know, how to open .dts packeges in the designer.
Thanks
Cheriyan.
Is there a way you can open an SSIS package without validating it?
The reason is - when I take a package from PROD and open it in DEV - initially all settings-variables are wrong - and the validation takes heck of long time in that case. And then I need to change the variables and reload the package. And bloody hell - if I forgot to change a variable - I sometimes have to validate package 3 times. And sometimes - I only need to get visual look of package - so why do I always need to wait for validation...
Hello,
We need duplicate a large number of SSIS packages , changing only server connection and database name inside the OLE DB Source sql command. Is there any easy way to do it , I mean without opening every package individually?
Thanks,
BeginnerInBiztalk
Hallo,
I'am relatively new to SSIS-programming and experiencing a serious problem with a package (6618 KB large) containing 5 dataflows. These dataflows all start from a datareader-origin and flow trough multiple transformations. While editing the fifth dataflow the developmentenvironment suddenly became unworkably slow. After any modification made to the dataflow it takes several minutes before I can continue editing. Meanwhile in the task manager the process devenv takes a very large portion (50 to 100%) of CPU.
Building the package,shutting down SSIS and even rebooting the PC don't make any difference. When you close the package ands reopen it, this takes at least 10 minutes.
We work with Microsoft SQL Server Integration Services Designer
Version 9.00.1399.00.
Does anyone know if there is a limit to the number of transformations in a flow or the size of a package? Could that be the problem?
Before this problem occured I was multiplying transformations by copying ,renaming and altering them within a dataflow. Could SSIS have some problem with that?
Any suggestion for solving this problem, other than chucking it all away an restarting, will be gratefully accepted.
With kind regards,
Paul Baudouin
I created a package using the ImportExport wizard and saved it to the local Sql server. Under Management Studio I can see the package, can run in, import it, export it BUT how am I supposed to edit (modify the thing) it?
TIA,
barkingdog
I have been handed a datawarehouse environment to look at however I cannot find the ssis packages (.dtsx).
I see that the packages have been deployed to SSISDB but I can't find the files to load into Datatools.
Once the files have been deployed is it possible to remove the package files? Is there a way of retro'ing the deployed packages out of SQL so I can view them in Datatools?
I have an IS package containing approx. 10 tasks in the control flow - one of these tasks is a rather large data flow containing around 50 transformations plus 3 sources and two destinations. Around 10 of these are script components and another 10 are Union All transformations. The rest are primarily lookups, conditional splits and derived column transformation.
The XML file containing the package is approx. 4.5 MB. As I am developing the package, it is becoming increasingly slow to work with as more transformations are added to the data flow. Now, it takes 8 minutes every time I have to open the package for development (DelayValidation is even set to true) and DTExec (not the debugger) uses the same amount of time before it starts executing the package. It also takes a very long time to edit the data flow, as I typically have to wait 1-2 minutes every time the designer has to "commit" a change.
Does anyone have any idea what can be done to speed up the package - both with regard to development and execution?
I am using Excel VBA to run a stored procedure which executes a package using the built-in SQL Server stored procedures. The VBA passes two values from excel to the stored proc., which is then supposed to pass these "parameters" to the package to use as a variable within the package.
@Cycle sql_variant = 2
WITH EXECUTE AS 'USER_ACCOUNT' - account that signs on using windows authentication
AS
BEGIN
SET NOCOUNT ON;
declare @execution_id bigint
[code]....
When I try to execute the package, from SQL Server or Excel using the Macro I built, I get the following error:"The parameter '[User::Cycle]' does not exist or you do not have sufficient permissions." I have given the USER_ACCOUNT that runs executes the stored procedure permission to read/write to the database and the SSIS project folder.
I'm pretty sure this problem started after applying Windows 2000 SP2 on machines running SQL 7 SP3. It may be that I only started manipulating these particular DTS jobs since that upgrade.
Problem: In EM I open a DTS package and it causes the server machine to crash to a blue screen. This has happened from a Windows 98 workstation running against a Windows 2000 Server SP2 running SQL7 SP3 and on a standalone laptop running Windows 2000 SP2 running SQL7 desktop edition SP3
Can anyone point me to more information on why this is happening?
Thanks
Doug
I recently installed SQL Server 2005 Enterprise on a machine running Server 2003. I have successfully configured Reporting Services (see below for summary of settings)
- Used the defaults for the Repor tServer and Report Manager Virtual Directories
- Windows Service Identity set to domain user. The domain user is part of the administrator group on the machine and has sysadmin rights to the database
- Web Service Identity set to NT AuthorityNetworkService
When I open http://localhost/reports/, I get the following error:
I have check a bunch of forums, but have no success. Any advise would be greatly appreciated!!
Server Error in '/Reports' Application.
Compilation Error
Description: An error occurred during the compilation of a resource required to service this request. Please review the following specific error details and modify your source code appropriately.
Compiler Error Message: CS0016: Could not write to output file 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.dll' -- 'The directory name is invalid. '
Source Error:
[No relevant source lines]
Source File: Line: 0
Show Detailed Compiler Output:
c:windowssystem32inetsrv> "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727csc.exe" /t:library /utf8output /R:"C:WINDOWSassemblyGAC_32System.Web2.0.0.0__b03f5f7f11d50a3aSystem.Web.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3a890e9c0 068591f_f54cc701ReportingServicesFileShareDeliveryProvider.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Web.Mobile2.0.0.0__b03f5f7f11d50a3aSystem.Web.Mobile.dll" /R:"C:WINDOWSassemblyGAC_32System.Data2.0.0.0__b77a5c561934e089System.Data.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.Web.Services2.0.0.0__b03f5f7f11d50a3aSystem.Web.Services.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.Configuration2.0.0.0__b03f5f7f11d50a3aSystem.Configuration.dll" /R:"C:WINDOWSassemblyGAC_32System.EnterpriseServices2.0.0.0__b03f5f7f11d50a3aSystem.EnterpriseServices.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.IdentityModel3.0.0.0__b77a5c561934e089System.IdentityModel.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.ServiceModel3.0.0.0__b77a5c561934e089System.ServiceModel.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem2.0.0.0__b77a5c561934e089System.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl34a099978 068591f_f54cc701ReportingServicesEmailDeliveryProvider.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727mscorlib.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3de5a2332 0958a20_f54cc701ReportingServicesWebUserInterface.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Xml2.0.0.0__b77a5c561934e089System.Xml.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3498aee86 042473c_93d0c501ReportingServicesCDOInterop.DLL" /R:"C:WINDOWSassemblyGAC_MSILSystem.Runtime.Serialization3.0.0.0__b77a5c561934e089System.Runtime.Serialization.dll" /R:"C:WINDOWSassemblyGAC_MSILSystem.Drawing2.0.0.0__b03f5f7f11d50a3aSystem.Drawing.dll" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3cd47089b 0f2a80e_f54cc701Microsoft.ReportingServices.Interfaces.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl3f180608d 0083daf_b16dc701Microsoft.ReportingServices.Diagnostics.DLL" /R:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628assemblydl323449648 068591f_f54cc701ReportingServicesNativeClient.DLL" /out:"C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.dll" /debug- /optimize+ /w:4 /nowarn:1659;1699;1701 "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.0.cs" "C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.1.cs"
Microsoft (R) Visual C# 2005 Compiler version 8.00.50727.1433
for Microsoft (R) Windows (R) 2005 Framework version 2.0.50727
Copyright (C) Microsoft Corporation 2001-2005. All rights reserved.
error CS0016: Could not write to output file 'c:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files
eports2cbaf422c4330628App_global.asax.th5hkjqv.dll' -- 'The directory name is invalid. '
Version Information: Microsoft .NET Framework Version:2.0.50727.1433; ASP.NET Version:2.0.50727.1433
We're experiencing a problem where intermittently our SSIS packages will hang. There are no log errors or events in the event viewer. It will happen whether the package is executed from the SQL Job Agent or run from BIDs. When running from BIDs it appears to hang inside one of the data flows (several parallel pipes with sorts, merge joins etc...). It appears to hang in multiple pipes within the data flow component. The problem is reproducable, we just kill it and re-run, and it appears to hang in the same places.
Now here's the odd thing: as we simply open and close some of the components in the pipe line after the place it hangs, a subsequent run will go further in the pipeline before hanging. If we open and close all the components after the point it initially hung, the data flow will run fine, from there on out. When I say "open and close" I mean no changes are made, we simply double-click the component, like a merge join, then click 'close.'
To me this does not seem like a memory problem but likely something is wrong with the metadata, where opening a component and closing it somehow alters the metadata to "right it".
This seems to occur intermittently after we make modifications to the package. It's like if you make any mod, even unrelated to the data flow, you then have to go through and open and close every component in your package to ensure it will work. Again, no errors or warnings are fired.
Has anyone seen this type of problem?
Hi,
I am planning to develop a single package that will download files from ftp server, move the files to internal file server and upload it in the database. But I want to run this package for multiple ftp file providers. For each provider the ftp server might be different and the transformation to upload the files into a database table might be different.
So can I create a single package and then multiple configuration files (xml), which will contain the details fo the ftp file providers and then pass the xml file as a parameter while executing the package. The reason being that the timings of fetching the files is different for each ftp file provider and hence cannot be combined into one.
Is this possible?
Thanks for your help.
$wapnil
I have created my query to do what it needs to do but i'm getting error when i click the button, it says there is an error opening my connectiong....
I.E.
Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code. Exception Details: System.Data.SqlClient.SqlException: Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.Source Error:
Line 28:
Line 29: //open the connection
Line 30: myConnection.Open();
Line 31:
Line 32: //create a commandSource File: c:Documents and SettingsplanPlanDatabaseBZAvuAdd.aspx.cs Line: 30 Stack Trace:
[SqlException (0x80131904): Login failed for user '(null)'. Reason: Not associated with a trusted SQL Server connection.]
System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection) +171
System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj) +199
System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj) +2305
System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK) +34
System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance) +606
System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance) +193
System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection) +502
System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options) +28
System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject) +429
System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject) +70
System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject) +512
System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection) +85
System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory) +89
System.Data.SqlClient.SqlConnection.Open() +160
_Default.insertIntoVU() in c:Documents and SettingsplanPlanDatabaseBZAvuAdd.aspx.cs:30
_Default.addAppButton_Click(Object sender, EventArgs e) in c:Documents and SettingsplanPlanDatabaseBZAvuAdd.aspx.cs:127
System.Web.UI.WebControls.Button.OnClick(EventArgs e) +75
System.Web.UI.WebControls.Button.RaisePostBackEvent(String eventArgument) +98
System.Web.UI.WebControls.Button.System.Web.UI.IPostBackEventHandler.RaisePostBackEvent(String eventArgument) +7
System.Web.UI.Page.RaisePostBackEvent(IPostBackEventHandler sourceControl, String eventArgument) +11
System.Web.UI.Page.RaisePostBackEvent(NameValueCollection postData) +33
System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint) +4919
therefor is this saying that I have to login before even testing this thing or what??
Hello,
I put my stored procedure in my class and try to execute it but get this error
1st here is my class
1 public signup_data_entry()
2 {
3 SqlConnection con = new SqlConnection("cellulant_ConnectionString");
4
5
6 SqlCommand command = new SqlCommand("Cellulant_Users_registration", con);
7 command.CommandType = CommandType.StoredProcedure;
8
9 con.open();
10
11 command.Parameters.Add(new SqlParameter("@RegionID", SqlDbType.Int, 0, "RegionID"));
12 command.Parameters.Add(new SqlParameter("@RegionDescription", SqlDbType.NChar, 50, "RegionDescription"));
13
14 command.Parameters[0].Value = 4;
15 command.Parameters[1].Value = "SouthEast";
16
17 int i = command.ExecuteNonQuery();
18
19
20 }
and here is the error message on the testing server. Error line is line 27 below
Source Error:
Line 25: command.CommandType = CommandType.StoredProcedure;
Line 26:
Error >>> Line 27: con.open();
Line 28:
Line 29: command.Parameters.Add(new SqlParameter("@RegionID", SqlDbType.Int, 0, "RegionID"));
Source File: c:inetpubwwwrootcellulant1App_Codesignup_data-entry.cs Line: 27
Hi,I am getting this error when i am connecting sql database.Error = "SQL Server does not exist or access denied."Can you please suggest me where i am going wrong.RegardsNaveen
View 2 Replies View RelatedWhen using Enterprise Manager, Right Clicking on any table in the db, selecting OPEN TABLE, and choosing either Return all rows or Return Top... I recieve this error "The query cannot be executed because some files are missing or not registered. Run setup again to make sure the required files are registered."
I am running: SQL Server 7.0 Client with Windows 2000.
I have run setup again and the same thing still happenes. I even uninstalled and reinstalled SQL Server, still the same thing occures.
I first installed SQL Server7.0 on my machine about a month and a half ago and all was fine until two weeks ago, then this started happening. SQL Server was the last thing I have installed on this machine so it cannot be a new install conflict. I can't think of any reason for this to be happening out of the blue like it did.
Does anyone have any insight???
Hi all,
I am having one problem about the processing cube in SQL 2005 AS.
when cube runs i get this error in log file:
File system error: Error opening file; Program Files (x86)Microsoft SQL Server90SharedASConfigmsmdredir.ini is not a disk file or file is not accessible.
Hello, I get this error:
Could not allocate ancillary table for view or function resolution
When I try to open a view that has never had a problem before today. I called Microsoft support and got a hot fix sent to me but unfortunatly it didnt install at all. I get an error:
You do not have any instance of SQL installed on this computer that qualifies for this hotfix.
Please check version and service pack requirements for this hotfix
And according to KB articles this problem should have been fixed by SP4 (which I have). So I dont know what to do. Could someone please help me??
Thanks
Mark
When I try to open the designer (with exiting, e.g. tutorial or new project/package) I get the following error message:
Microsoft Visual Studio is unable to load this document:
Index (zero based) must be greater than or equal to zero and less than the size of the argument list.
After closing the project I have the following application event log error:
Faulting application devenv.exe, version 8.0.50727.42, stamp 4333e699, faulting module unknown, version 0.0.0.0, stamp 00000000, debug? 0, fault address 0x014fb87c.
I am trying to open the solution and it is giving me error
"The application for the project \.... est.dtproj is not installed
Make sure application for the project type(.dtproj) is installed."
I tried to open any SSIS solution and it is giving me same error.
Anybody has any ideas how to resolve this problem?
I am getting the following error when I try to double click on an Execute Sql Task to open it using VS2005:
===================================
Cannot show the editor for this task. (Microsoft Visual Studio)
===================================
Method 'get_ParameterSize' in type 'GridRow' from assembly 'Microsoft.SqlServer.SQLTaskUI, Version=9.0.242.0, Culture=neutral, PublicKeyToken=89845dcd8080cc91' does not have an implementation. (Microsoft.SqlServer.SQLTaskUI)
Please help!!
Hi All
i am very new to using sql reporting services. After installation of reporting services and configuration i get this error on the browser.
Can anyone highlight the problem in the configuration?
my system is configured as
Windows 2003 SP1 server
MSSQL 2005 sp1
Server Error in '/Reports' Application.
--------------------------------------------------------------------------------
The current identity (NT AUTHORITYNETWORK SERVICE) does not have write access to 'C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files'.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.HttpException: The current identity (NT AUTHORITYNETWORK SERVICE) does not have write access to 'C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files'.
Source Error:
An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.
Stack Trace:
[HttpException (0x80004005): The current identity (NT AUTHORITYNETWORK SERVICE) does not have write access to 'C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files'.]
System.Web.HttpRuntime.SetUpCodegenDirectory(CompilationSection compilationSection) +3474107
System.Web.HttpRuntime.HostingInit(HostingEnvironmentFlags hostingFlags) +226
[HttpException (0x80004005): The current identity (NT AUTHORITYNETWORK SERVICE) does not have write access to 'C:WINDOWSMicrosoft.NETFrameworkv2.0.50727Temporary ASP.NET Files'.]
System.Web.HttpRuntime.FirstRequestInit(HttpContext context) +3426839
System.Web.HttpRuntime.EnsureFirstRequestInit(HttpContext context) +88
System.Web.HttpRuntime.ProcessRequestInternal(HttpWorkerRequest wr) +149
--------------------------------------------------------------------------------
Version Information: Microsoft .NET Framework Version:2.0.50727.42; ASP.NET Version:2.0.50727.42
thanks
ga
everytime i go to open tables in enterprise manager, i right click the table and then select open all of it. however, i was gone from work for a week, and when i came back i got an error message when i did this. it is as follows:
An unexpected error happened during this operation.
[Query]-Query Designer encountered a Query error:
Unspecified error.
I dont know what to do. all i can think of is rebooting the computer, but it is the LIVE databases for webpages. please help me!
Hi
I am getting an error when i try to open MSEM. I have also tried to open this via mmc and get the same.
I have an attached a screen shot of the error. I tried re-installing SP4, but this did not fix it. Please help. We need to move our SQL to a new server and since I can't see any of it, I can't really manage it before the move.
I would appreciate any help.
Thanks
Jimmy
Hi,
I installed IE7 recently and it is giving me problems when I open Infopath forms to edit documents. I have a sharepoint website which contain links to these forms, when I click on the link it opens the infopath form. It was working absolutely fine when I used IE6. But now when I open the infopath form it gives me an error saying that
A Runtime error has occured
Line: 38
Error: Object Expected
When I open it in the debugger it shows me an error at <body onLoad="onLoad()">. Could someone please advice!
I appreciate a quick response.
Thanks
We've been opening pdf reports using SOAP for some time now and all of the sudden we're getting errors when the user is on IE6. IE7 is fine.
The error we're getting is from the Acrobat reader is:
"There was an error opening the document. The file cannot be found"
Here's the code that opens the report:
Dim report As Byte() = Nothing
Dim rs As report_engine2.ReportExecutionService = New report_engine2.ReportExecutionService
'credentials
rs.Credentials = New System.Net.NetworkCredential(rs_login, rs_password)
rs.PreAuthenticate = True
Dim reportpath As String = rs_folder & report_name
Dim zoom As String = "False"
Dim deviceInfo As String = Nothing
Select Case format
Case "HTML4.0", "HTML3.2"
deviceInfo = "<DeviceInfo>"
deviceInfo &= "<Toolbar>False</Toolbar>"
deviceInfo &= "<Parameters>False</Parameters>"
deviceInfo &= "<HTMLFragment>True</HTMLFragment>"
deviceInfo &= "<StyleStream>False</StyleStream>"
deviceInfo &= "<Section>0</Section>"
deviceInfo &= "<Zoom>" & zoom & "</Zoom>"
deviceInfo &= "</DeviceInfo>"
Case Else
deviceInfo = "<DeviceInfo></DeviceInfo>"
End Select
'array of parameters
Dim parameters(0) As report_engine2.ParameterValue '0 means one parameter in the report
Dim paramValue As report_engine2.ParameterValue = New report_engine2.ParameterValue
paramValue.Name = param1_name
paramValue.Value = param1_value
parameters(0) = paramValue
'variables for the remaining paramters
Dim historyID As String = Nothing
Dim credentials As report_engine2.DataSourceCredentials = Nothing
Dim showHideToggle As String = Nothing
Dim extension As String = GetExtension(mimeType)
Dim warnings() As report_engine2.Warning = Nothing
Dim reportHistoryParameters() As report_engine2.ParameterValue = Nothing
Dim streamIDS() As String = Nothing
Dim execInfo As New report_engine2.ExecutionInfo
Dim execHeader As New report_engine2.ExecutionHeader
rs.ExecutionHeaderValue = execHeader
execInfo = rs.LoadReport(reportpath, historyID)
rs.SetExecutionParameters(parameters, "en-us")
Try
'execute the report
report = rs.Render(format, deviceInfo, "", mimeType, "", warnings, streamIDS)
'set the filename
Dim fileName As String = savefilename & "." & extension
'write the report back to the response object
response.Clear()
response.ContentType = mimeType
'add the file name to the response if it is not a web browser format.
If mimeType <> "text/html" Then
response.AddHeader("Content-Disposition", "attachment; filename=" & fileName)
End If
'send the byte array containing the report
HttpContext.Current.Response.BinaryWrite(report)
HttpContext.Current.Response.End()
Catch ex As Exception
End Try
This used to work just fine until about a week ago. We're not sure if there was a MS update that caused this behavior. If the user saves the report to a local disk instead of opening it, they can save it successfully and open it later.
Any thoughts on where to go with this one?
Regards
I had just installed SQL 2005 dev on my laptop and got an error message when I tried to create a package using the BI IDE. I received the same error using VS2005 IDE. But the project was created regardless without any packages. When I tried to create a new package in the project, I received the same error again, but with an option to view the error details.
Following is the text of the error details:
TITLE: Microsoft Visual Studio
------------------------------
Error creating package
------------------------------
ADDITIONAL INFORMATION:
Failed to save package file "C:Documents and SettingsmyoungbloodLocal SettingsTemp mpD4B.tmp" with error 0x80040154 "Class not registered".
------------------------------
Failed to save package file "C:Documents and SettingsmyoungbloodLocal SettingsTemp mpD4B.tmp" with error 0x80040154 "Class not registered".
------------------------------
BUTTONS:
OK
------------------------------
I found a similar post that suggested that they try the following:
regsvr32 msxml3.dll
regsvr32 msxml4.dll
regsvr32 msxml6.dll
But msxml6.dll could not be found.
I did get a copy of this file from a coworker, and after copying it and registering it, I was able to add a package to the project.
My concern now is what is the likelyhood of this being the only file missing from the installation.
I'm wondering if I should reinstall, or (if it exists) do a repair on the installation.
Thanks.
Marshall
Hi,
I am trying to call a stored procedure to insert into my database. After I called Open(), it crashed on ExecuteNonQuery(). I get the following message.
Object must implement IConvertible.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.InvalidCastException: Object must implement IConvertible.
Source Error:
Line 160:Try
Line 161:myConnection.Open()
Line 162:myCommand.ExecuteNonQuery()
Line 163:myConnection.Close()
What does this mean? If anyone encountered this error before, please let me know how to trace the error and fix it.
Thanks Gurus,
John
Greetings:
We have a database with approximately 15-20 tables. Last week, using Enterprise Manager, we were able to open any of these tables and return all rows. Yesterday, when we tried to do this, we got the following message:
An Unexpected Error happened during this operation.
[Query] - Query Designer encountered a Query Error: Unspecified Error
Can anyone tell me what might be causing this and how to fix it? Barring that, can anyone suggest some general steps I might take to possibly eliminate this problem without knowing the cause? Last, can you point me to a good resource for investigating problems of this kind, such as a knowledge base (other than Microsoft's TechNet)?
Many, many thanks.
I am trying to deploy my mobile app to treo 700wx, but when i test the app, the application gives me an error message:
sql mobile encountered problems when opening the database
It happens when I sync data.
However, when I sync data users and customer info, it doesn't give this message, But when I sync (third time) order info, this message comes out.
--when i run on my PPC (HP ra1950), there is no this error message.
I think it is a bug?
BTW, which cabs file should I install on the Treo phone? (.Net ce, sql ce mobile30 ???)
Please help me out. Thanks
James