ReportingService2005.CreateReport() Warning...

May 19, 2006

I am using Reporting Services 2005 on SQL Express with Advanced Services...

I am dipping into the SOAP API and trying to add DataSources and Reports dynamically, as is how I would like to be able to deploy them...

My problem is this:

I have a shared datasource and a report that were deployed to the server via the 'Deploy' method in VSTS...I can access that report just fine, and it obviously uses the shared datasource...

Next, I copy the .rdl file of the report I already deployed and give it another name ("NewReport.rdl"). What I want to do is add this report to the server (it's an exact copy of the functioning report with a different report name). This report should use the same shared datasource as the other report.

Here is my code:

ReportingService2005 rs = new ReportingService2005();
rs.Credentials = System.Net.CredentialCache.DefaultCredentials;

Byte [] reportDefinition = /* read in the rdl file and create byte array out of it (didn't want to paste this code, cuz you don't care...trust me, it's correct */

ReportingTest.localhost.Warning [] warnings = rs.CreateReport("NewReport", "/ReportServerTest", true, reportDefinition, null);

foreach (ReportingTest.localhost.Warning warning in warnings)
{
Console.WriteLine(warning.Message);
}


The report is added to the server just fine, but I receive this 1 warning:

Code: "rsDataSourceReferenceNotPublished"
Message: "The data set €˜AdventureWorksTestDataSource€™ refers to the shared data source €˜AdventureWorksTestDataSource€™, which is not published on the report server."

And then when I try to view the report, I get this exception:

"The report server cannot process the report. The data source connection information has been deleted. (rsInvalidDataSourceReference)"

I know that the datasource is there, because the other report still works just fine...and I am adding an exact COPY of that report's RDL to the server, so it SHOULD work, IMO...

Any word on this?...I haven't been able to find much on this error...they say that an 'rsInvalidDataSourceReference' is usually caused when the datasource doesn't exist on the server when the report is deployed...or the datasource is deleted after the report has been deployed, but this is not true in my case...

Thanks for any feedback!!

Russ

View 9 Replies


ADVERTISEMENT

Rs.CreateReport() With Overwrite Set To True Fails To Update Report Description

Jan 3, 2007

When calling the RS SOAP API's CreateReport method, it doesn't seem like the report description is updated, unless I first delete the report and then recreate it.

Here's what my call looks like -
Warning[] warnings = rs.CreateReport(reportName, "/" + folder, true, buffer, null);

Is this a known issue?

View 9 Replies View Related

ReportingService2005 Class

Nov 14, 2007

Hi, I'm having trouble with the ReportingService2005 object

I'm trying to use the Get and SetPolicies methods and have used ideas from other snippets in order to get this:

...
Microsoft.SqlServer.ReportingServices2005.ReportingService2005 RS = new Microsoft.SqlServer.ReportingServices2005.ReportingService2005();


RS.Credentials = System.Net.CredentialCache.DefaultCredentials;

RS.Url = http://www.MyServer.co.uk/ReportServer/ReportService2005.asmx;


bool ip;

Policies = RS.GetPolicies("/", out ip);




RS.SetPolicies("/", Policies);

...

Does anyone have any experience with this object, or any working examples, I suspect I'm still missing some permissions thing but at the moment all I get is this annoyingly unhelpful message:

Client found response content type of 'text/html; charset=utf-8', but expected 'text/xml'. The request failed with the error message: --





BODY
{font-family:Verdana;font-weight:normal;font-size:8pt;color:black;}
H1
{font-family:Verdana;font-weight:700;font-size:15pt;}
LI
{font-family:Verdana;font-weight:normal;font-size:8pt;display:inline;}
.ProductInfo
{font-family:Verdana;font-weight:bold;font-size:8pt;color:gray;}
A:link
{font-size:8pt;font-family:Verdana;color:#3366CC;text-decoration:none;}
A:hover
{font-size:8pt;font-family:Verdana;color:#FF3300;text-decoration:underline;}
A:visited
{font-size:8pt;font-family:Verdana;color:#3366CC;text-decoration:none;}


Reporting Services Error



An internal error occurred on the report server. See the error log for more details. (rsInternalError) Get Online Help

For more information about this error navigate to the report server on the local server machine, or enable remote errors

SQL Server Reporting Services
--.


Thanks for your help,

Sean.

View 2 Replies View Related

ReportingService2005 API / CreateSubscription Permission

Oct 16, 2007

I have successfully used the ReportService2005 services to create a subscription. The problem I am running into is I need to create subscriptions on behalf of other people. This would mean that they would be owners of these subscriptions. The CreateSubscription web service does not take the owner as a paramter. This leads to a problem where someone would not be able to unsubscribe if I programmatically subscribed them. I need the subscription to show up in the "My Subscriptions" section.

Any help is greatly appreciated.
Thanks,
Lee

View 4 Replies View Related

The Request Failed With HTTP Status 401: Unauthorized. ReportingService2005

Jul 21, 2006

I have programmatically deploy SQL server Reporting Services 2005 reports via msi file. The installation was success, I was able to run the reports on localhostReports at the target machine. But I get error "The request failed with HTTP status 401: Unauthorized." when I try to access it from the ASP.NET app report menu in the target machine.

It is Windows Server 2003 standard edition, it uses Windows Authentication. I have tried setting any combination below and still doesn't work. Anybody has any other ideas?

ReportingService2005 rs = new ReportingService2005();

rs.UseDefaultCredentials = true;
rs.PreAuthenticate = true;
rs.Credentials = System.Net.CredentialCache.DefaultCredentials; or
rs.Credentials = new System.Net.NetworkCredential("Admin", "psw");

View 5 Replies View Related

What Permissions Are Required To Call The ReportingService2005.CancelJob Method?

Apr 14, 2008

I'd like to cancel my long running Reports via ReportingService2005.CancelJob(). It seems, while I'm able to start a job I don't have the permission to cancel it. I always get the error message:

The permissions granted to user '<my-account>' are insufficient for performing this operation.


Do I have the be a member of a special group on the server running the Reporting Services?

werner

View 3 Replies View Related

Issue With ReportingService2005.FireEvent Method -- Insufficient Permission!!!

Jul 19, 2007

Hi All,



In my app, whenever ReportingService2005.FireEvent method gets called, app threw me an exception said

"Insufficient permission for performing this operation". No idea how to fix it.



Thanks in advance.



Alex

View 6 Replies View Related

The Request Failed With HTTP Status 401: Unauthorized. - ReportingService2005 Webservice

Dec 11, 2007


Hello, I am trying to schedule a report using the ReportingService2005 web service. It works in my local machine, but as soon as I deploy my web app to a server I get this exception:

System.Net.WebException: The request failed with HTTP status 401: Unauthorized.
at System.Web.Services.Protocols.SoapHttpClientProtocol.ReadResponse(SoapClientMessage message, WebResponse response, Stream responseStream, Boolean asyncCall)
at System.Web.Services.Protocols.SoapHttpClientProtocol.Invoke(String methodName, Object[] parameters)
at ReportService.ReportingService2005.GetSubscriptionProperties(String SubscriptionID, ExtensionSettings& ExtensionSettings, String& Description, ActiveState& Active, String& Status, String& EventType, String& MatchData, ParameterValue[]& Parameters)
at ReportScheduling.SaveSubscription(String SubscriptionID, String ReportName, Int32 ReportID)
at ReportScheduling.ScheduleReport()

I see that a lot of people are having the same problem but no solutions are given, Answers like "use the default credentials" . Or "pass a user name and a password" are not doing anything. This has got to be a machine setting. Can anyone share the specific fix? Sad that this is not in Microsoft's standard documentation or MSDN. Very frustating.


View 4 Replies View Related

Can I Use The ReportingService2005.SetPolicies Method To Set The User Of The Form Authentication To The Role?

Oct 5, 2007



Hi,

Can I use the ReportingService2005.SetPolicies method to set the user of the form authentication to the role?

I mean the user name doesn't exist in the reporting service own table, only store in the our web system.


Thanks a lot

koukai

View 1 Replies View Related

Sqlserver 7 Warning

Jul 17, 2001

Whats the cause for this warning, after I query a sqlserver 7 table,
'warning: Null value eliminated from aggregate' ?

Thanks,
Scott

View 1 Replies View Related

W32time Warning

Nov 12, 2002

I keep getting this warning, any ideas on how to fix this? Thank you.

View 1 Replies View Related

Warning By Sqlserveragent

Aug 17, 2004

Hello,

I am getting the following warning message in the event viewer. I have only one schedule in sql. there is no other schedules in task scheduler or database management.

Event Type:Warning
Event Source:SQLSERVERAGENT
Event Category:Job Engine
Event ID:208
Description:
SQL Server Scheduled Job 'Transaction Log Backup Job for DB Maintenance Plan 'DB Maintenance Plan1'' (0xD25A4CDDD1C59E48B4D28F61F0A411B8) - Status: Failed - Invoked on: 2004-08-16 02:30:00 - Message: The job failed. The Job was invoked by Schedule 2 (Schedule 1). The last step to run was step 1 (Step 1).

Kindly give the suggestions at earliest.

View 1 Replies View Related

Warning...newbie Here!

Jan 26, 2004

Hey guys....I have a quick question. I am having a problem with a certain app which connects to my SQL 2000 SP3a Database. It only occurs when I have a ^ in the password, both using SQL and NT authentication.

I have checked on MSDN and they do not list that character as one to avoid. I did find in the books online documentation that the ^ performs a bitwise exclusive OR operation....has anyone tested using ^ as part of a password to authenticate to a SQL db?

View 1 Replies View Related

Warning Sign: What Does It Mean???

Jan 6, 2006

I typed the following query

ALTER TABLE [konnik].[PORTAL_CONFIG]
ADD CONSTRAINT [DF_PORTAL_CONFIG_AUTOPM_ON]
DEFAULT (1) FOR [AUTOPM_ON]

and i received the following warning

Warning: The table 'PORTAL_CONFIG' has been created but its maximum row size (12068) exceeds the maximum number of bytes per row (8060). INSERT or UPDATE of a row in this table will fail if the resulting row length exceeds 8060 bytes.

Bear in mind that this table come from Access through the Dts. Could anyone translate this for me? How can i overcome this???

View 10 Replies View Related

Warning Error

May 7, 2007

hi all..

i have this error and fail to resolve it :-
Warning: Null value is eliminated by an aggregate or other SET operation.
what does that means? my code :-

SELECT
@BookQtyIN = ISNULL(SUM(x.pickqty), 0),
@PickQtyIN = CASE WHEN ISNULL(SUM(x.pickqty), 0) >0 THEN
ISNULL(SUM(d.PickQty), 0) - ISNULL(SUM(x.pickqty), 0)
ELSE ISNULL(SUM(d.PickQty), 0)END,

FROMtblItemDetail d

LEFT JOIN (SELECT p.PickQty AS PickQty,
j.PickComplete AS PickComplete,
p.ItemStorageID AS ItemStorageID
FROM tblItempicked p
LEFT JOIn tblJobDocuments j
ON j.Docrefid=p.Docrefid AND j.JobID=p.JobID
WHERE j.PickComplete='N'
)AS x ON x.ItemStorageID=d.ItemStorageID

WHERE d.ItemID = @ItemID
AND d.Ownership = @ClientID
AND d.CustomLotNo = @CustomLotNo

View 2 Replies View Related

Should This Be An Error Rather Than A Warning?

May 25, 2006

If you have a package that uses an environment variable for an indirect configuration and the environment variable is not present when the package runs you get the following warning:

The configuration environment variable was not found.  The environment variable was: "Seer.ConnectionManager.CUECommonReference". This occurs when a package specifies an environment variable for a configuration setting but it cannot be found. Check the configurations collection in the package and verify that the specified environment variable is available and valid. 

IMO, if the package is expecting to find something and cannot find it then it should cause an error, not a warning. I'm happy for people to disagree tho :)

Any comments???

 

-Jamie

 

View 17 Replies View Related

Installation Warning Help!....

Jan 17, 2008



Install on 2003 Server R2 x64 I get this warning and need to now how to fix this:


- ASP.Net Version Registration Requirement (Warning)



Messages

ASP.Net Version Registration Requirement



64-bit ASP.Net is Registered. Required 32-bit ASP.Net to install Microsoft Reporting Services 2005(32-bit).

Can the 32-bit version co-exist with the 64-bit version APS.Net?

View 3 Replies View Related

Truncation Warning

May 24, 2007

Hello,



I'm having a problem with one of my packages due to a truncation warning that I can't get rid of. It's not the end of the world, because the package still works. It's just extremely frustrating.



The problem arises in a derived column item in a data flow task. There is a postcode field in the data flow which has space for 20 characters. I create a derived column from this which simply removes any spaces:



Derived Column Name: Postcode

Derived Column: Replace 'Postcode'

Expression: REPLACE(" ",Postcode,"")

Data Type: string [DT_STR]

Length: 20

Code Page: 1252 (ANSI - Latin I)



However when I use this expression, or anything else which uses the replace function, I end up with the warning message:



Warning 1 Validation warning. Create Staging Tables: Derived Column [20555]: The result string for expression "REPLACE(" ",Postcode,"")" may be truncated if it exceeds the maximum length of 4000 characters. The expression could have a result value that exceeds the maximum size of a DT_WSTR.



I have tried everything I can think of to get rid of the warning. Is there some way I can use the replace function, but not have the system convinced that I'm about to go over the maximum size limit?



Many thanks

View 5 Replies View Related

WARNING:LRU List Is Empty

Feb 14, 1999

Can some one please help.
Lately I am getting an error:
LAZY WRITER WARNING: LRU List is Empty

Than the system locks!
can anyone help. This is driving us crazy.
There is no reference in the KB. We are trying to insert records into a table by a SP.

Thanks,
John

View 2 Replies View Related

Task Engine Warning

May 20, 1999

I'm running SQL Server 6.5, with the latest Service pack on NT 4.0 with SP4. A couple of days ago I started getting a warning message in my event log right after a scheduled task ran. The scheduled task calls three stored procedures (data dumps for master, msdb, and a production database) it also runs a consistency check on each before dumping them. I can interactively run each stored procedure and get NO error messages. Prior to getting the warning message (which occurs after the scheduled task runs) I get normal informational entries that the dumps occurred without a problem and the files are written to the proper area. The error is in the Task Engine category and are Warning type messages. Here is the text:

SQL Server Scheduled Task: 27, 'Proddata Dump' -- Status: Failed
-- Task Invoked on: 5/20/99 5:00:00 AM -- Message: Database 'ASSMTCTRPROD' (116647 pages) dumped to file <1> on device 'D:DATDUMPASSMTCTRPROD_990520_DATA.DMP'. (Message 4035)

Any help that anyone could give would be greatly appreciated. Thanks

View 1 Replies View Related

SQL Server Agent Warning

Jul 23, 2002

Hi

I'm getting a strange sql server agent warning in my server's event log (not in the sql server log). Its occurring after each agent job runs and says:

"Unable to determine if the owner (sa) of job Trans Backup has server access (reason: Unable to connect to server - check SQL Server and SQL Agent errorlogs)."

I have checked the errorlogs - nothing.
My job completes OK, but I get this warning.

I'm running SQL Server 2000 SP2.
I'm running in a cluster.
The problem has only occurred since a reboot yesterday.

Any Ideas?

Thanks in advance.

Andy

View 2 Replies View Related

Database Recovery Warning

Feb 8, 2008

Hi All,

I've recently restored one of my development databases from it's production backup. The restore completed successfully, users were able to connect to the database without any problems. However, when I checked the error log I found the following message:

Bypassing recovery for database 'Test' because it is marked IN LOAD.

I could not find anything on the web or in BOL. Any ideas?

Thanks.

View 3 Replies View Related

Warning Msg In Application Log Urgent

Feb 10, 2004

Hi all,
Sql server 7.

Under event viewer->application log i am getting the below error continously. Pls help

Regards,Event Type: Warning
Event Source: SQLServerAgent$abc
Event Category: Printers
Event ID: 208
Date: 2/9/2004
Time: 9:23:03 PM
User: N/A
Computer: abc1
Description:
The description for Event ID ( 208 ) in Source ( SQLServerAgent$abc ) cannot be found. The local computer may not have the necessary registry information or message DLL files to display messages from a remote computer. The following information is part of the event: SQL Check, 0xAF04DFE7917DEA489F33D8A38E8A0793, Failed, 2/9/2004 9:23:00 PM, The job failed. The Job was invoked by Schedule 31 (6.x schedule). The last step to run was step 1 (Step 1)..


Waiting for ur reply
TIA
aadil

View 3 Replies View Related

Warning Message 1708

Feb 25, 2004

I use VB 6.0 with ADO 2.6 to access an SQL-server.
I know that the table I wish to create generates this warning.

But from today ( without any changes to the SQL-server ) , this warning is reported as an error to the client instead of continuing.
So my error trap routine traps this as an error now.

I have a workaround that I would to avoid and that's reinstalling the SQL-server ( Only the MSSQL ).

Does anybody know a better solution.

PS : Changing the table structure is not possible in this case.

Thnx in advance,

Sven Peeters
Belgium

View 2 Replies View Related

IIS Feature Requirement (Warning

Sep 18, 2007

Hello there

I installed sql server 2005 developer edition

and the only error message i got was.

- IIS Feature Requirement (Warning)
Messages
IIS Feature Requirement

Microsoft Internet Information Services (IIS) is either not installed or is disabled. IIS is required by some SQL Server features. Without IIS, some SQL Server features will not be available for installation. To install all SQL Server features, install IIS from Add or Remove Programs in Control Panel or enable the IIS service through the Control Panel if it is already installed, and then run SQL Server Setup again. For a list of features that depend on IIS, see Features Supported by Editions of SQL Server in Books Online.

how do i get hold of Internet Information Services
I installed it on vista premium.

Please help

Regards
ROB

View 3 Replies View Related

IIS Warning On SQL 2005 X64 Install

Nov 30, 2007

While intalling SQL 2005 on an x64 machine, I got an error message that warned that some functions of SQL would not install unless IIS was installed (and enabled) on the machine. It did not say what would not install, but I gather it is Reporting Services. I don't recall getting these warnings in previous (32 bit) installations of SQL 2005.

On the other hand, when I go into the BI Intelligence Studio on
a (32 bit) server that does not have IIS, I seem to be able to create
a report anyway (Not really my area of expertise ). Does that mean that Report Services is working without IIS?

View 1 Replies View Related

How To Disable A Warning Message ?

Jul 23, 2005

Hi,I have a few create table statements which create temporary tablesthat has row definitions which exceeds the 8060 size limit, this causesa warning message being generated (Message 1708).Is there a way I can disable/avoid the warning message from beingprinted ?Thanks,joe

View 2 Replies View Related

Warning Re ADO .UpdateBatch Method

Jul 20, 2005

Awhile back there was some discussion about ways of sending multiplerows of data to SQL Server. The ADO .UpdateBatch method was one ofthe possibilities mentioned, and Erland said he thought that probablyonce the data get to SQL Server they are probably actually insertedone row at a time. I just want to say that based on an experience Ihad a couple of days ago I am now sure that is the case. I was using..UpdateBatch for something quick and dirty I had to do just once andwas too lazy to use XML for. An error was generated during the..UpdateBatch process because of invalid data in one row. However, alarge number of the rows in the batch WERE written to the database.Until now I haven't used .UpdateBatch in a production environment onlybecause this implies granting INSERT or UPDATE privileges to the user.But based on this experience I would NEVER use .UpdateBatch in aproduction environment, even for a user like a batch job where thepermissions would not be an issue.FWIW.

View 11 Replies View Related

Suppress Warning Messageboxes

Apr 8, 2008

Hello All,

I have an SSIS package which uses a third party RMS driver. It is not licensed and so it throws a warning messagebox when the package is run and every time the connection is used. Is there a way to suppress these messages so that the package can be scheduled and run without user interaction?

Thanks
Arun

View 10 Replies View Related

Unknown,LazyWriter: Warning

Aug 23, 2007

I don€™t know if this is the case but I need some help. We have itanium server with Microsoft SQL Server 2005 - 9.00.3054.00 (Intel IA-64) Mar 23 2007 18:42:19 Copyright (c) 1988-2005 Microsoft Corporation Standard Edition (64-bit) on Windows NT 5.2 (Build 3790: Service Pack 2).


We has had lot of problem with that the sqlserver.exe process hangs 100% cpu. It€™s totally non responsive I€™m not even able to contact the server with DAC. The general solution has been just kill the process. Not nice.


https://forums.microsoft.com/TechNet/ShowPost.aspx?PostID=440746&SiteID=17


The log is full of those
Date,Source,Severity,Message
08/16/2007 09:00:38,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/16/2007 08:55:17,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/15/2007 13:06:09,spid4s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/14/2007 10:07:08,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/09/2007 11:07:29,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/06/2007 09:41:13,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/06/2007 09:14:50,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/06/2007 08:54:38,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/06/2007 08:24:59,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/03/2007 11:09:54,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
08/01/2007 12:30:56,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/31/2007 10:16:45,spid2s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/30/2007 10:44:22,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/24/2007 01:03:36,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/23/2007 01:02:33,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/16/2007 12:27:52,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/16/2007 12:25:12,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/16/2007 11:54:07,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/16/2007 11:44:16,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/14/2007 01:04:15,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/12/2007 06:18:51,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/12/2007 06:06:49,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/10/2007 13:20:08,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/10/2007 13:10:43,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/09/2007 10:36:27,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/09/2007 10:28:46,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/06/2007 10:12:20,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/06/2007 10:09:39,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/06/2007 10:06:19,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/06/2007 10:01:28,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/06/2007 01:17:08,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/06/2007 01:13:47,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/04/2007 10:41:06,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/03/2007 10:24:24,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
07/03/2007 01:22:44,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.
06/28/2007 01:03:03,spid3s,Unknown,LazyWriter: warning<c/> no free buffers found.


LazyWriter: warning, no free buffers found.



We used to solution to set a fixed as told in the post above and after that the problem went away. At least for the last 4 days.


Is this LazyWriter not fixed in SP2 for itanium or what?

View 5 Replies View Related

Warning When Registering Stdole.dll

Apr 30, 2008

All,

I am able to "CREATE ASSEMBLY" for the stdole.dll without issue, however, I receive the warning:

Warning: Assembly "stdole" was built using version v1.0.3705 of the
.NET Framework. SQL Server currently uses version v2.0.50727.
(Microsoft SQL Server, Error: 6215)

I am unable to find a PIA for stdole that is .NET 2.0. Has anyone resolved this warning? Can I create a 2.0 PIA myself without causing other problems?

Thanks in advance for your thoughts.

View 3 Replies View Related

SSIS Execution Warning

Sep 21, 2006

Hi,

when using lookup i am geting the following warning.our OLEDB connection is Oracle.how to resolve this will this have any performance impact.

[Lookup [14342]] Warning: Cannot retrieve the column code page info from the OLE DB provider. If the component supports the "DefaultCodePage" property, the code page from that property will be used. Change the value of the property if the current string code page values are incorrect. If the component does not support the property, the code page from the component's locale ID will be used.

Thanks

Jegan

View 5 Replies View Related

Is It Possible To Disable A Specific Warning ?

Nov 2, 2006

Hi!

I'm running dtexec with the /WarnAsErrors flag, to be sure to detect any configuration warning (configuration errors are actually throwed as warning, which is not sufficient) or any other important warning.

I only get one warning (0x80047076, optimisation warning). Is there a way to disable this specific warning ?

thanks

Thibaut

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved