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


Top 5 Contributors of the Month
MarieAdela
Imran Ghani
Post New Web Links

lookup error o/p exel issue

Posted By:      Posted Date: September 12, 2010    Points: 0   Category :Sql Server
 
I created one ssis package ,I configure lookup error o/p and provided exel destination .When I am running package again and again ,the error row is adding in exel destination file .I want different exel file whenever I run the package.Thanks


View Complete Post


More Related Resource Links

IsapiModule Error 500 Issue

  

I am about exhausted trying to figure out this error:

HTTP Error 500.0 - Internal Server Error

Description: The page cannot be displayed because an internal server error has occurred.

Error Code: 0x8007007b

Notification: ExecuteRequestHandler

Module: IsapiModule

Requested URL: http://localhost:80/ReportServer

Physical Path: c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer

When I enable Failed Request Tracing Rules and view the log output I am supposing that the actual problem is in the 2nd call where there are 2 backslashes before the actual filename in the specified path:

ISAPI_START

CALL_ISAPI_EXTENSION DllName="C:\Windows\Microsoft.NET\Framework\v2.0.50727\\aspnet_isapi.dll"

 

Datasheet view lookup column issue

  

When a column that has a lookup is empty in datasheet view and I attempt to update a different column I get this message: the text entered for isn't an item from the list. select an item from the list, or enter text that matches one of the listed items.

I found this hotfix, but it did not apply.

http://support.microsoft.com/kb/948952

Any ideas how to get this resolved?


SSIS Lookup Transformation Issue

  
I am having a strange issue, In my data flow i have a Lookup Transformaton which will match on key columns of the fact and is followed by a condetional split that would deside if it should insert (old db destination) or go to update (oledb command) or ignore if no change. I have packages running for the last 1 year with the same logic. But in the recent packages I am experiencing a problem.  example: Key columns for join are - type_no (varchar 16) with all numeric values except one record wihh ' '(space) in it  and type_cd (decimal(18,0)) with values(0,1,2,3,4,5) It worked fine when I test the package. After couple of day running in schedule I get integrity violation and huge file with failed records which are supposed to be blocked at the condetional split as they are already in the fact. When i add a data viewer what i found is for all the llokup columns its having nulls (no match found). Workaround that is working for me for now is - I select full cash and say ok in the lookup transofrmation and again open it and set it back to no cash. Then it starts working as expected. Did anyone come accross this kind of issue? is the some standard that I have to follow to make sure this doesnot happen again  

"An error occurred during printing. (0x8000405)" eror - reporting services issue

  
We are getting this error: "An error occurred during printing. (0x8000405)" from time to time - 70% of the time when we are trying to use a printer button within report manager. It happens if we preview report or just print it. We noticed if we restart RS services, the error will stop for a little bit and then starts again. We don't print that much and it will come back after just a few reports printed. Let me know if you had a similar issue. thanks!

IsapiModule Error 500 Issue

  
I am exhausted for resources on trying to figure out this error: HTTP Error 500.0 - Internal Server Error Description: The page cannot be displayed because an internal server error has occurred. Error Code: 0x8007007b Notification: ExecuteRequestHandler Module: IsapiModule Requested URL: http://localhost:80/ReportServer Physical Path: c:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\ReportServer   When I enable Failed Request Tracing Rules and view the log output I am supposing that the actual problem is in the 2nd call where there are 2 backslashes before the actual filename in the specified path: ISAPI_START CALL_ISAPI_EXTENSION DllName="C:\Windows\Microsoft.NET\Framework\v2.0.50727 \\aspnet_isapi.dll"   MODULE_SET_RESPONSE_ERROR_STATUSWarning                                                                 ModuleName="IsapiModule", Notification="EXECUTE_REQUEST_HANDLER",   HttpStatus="500", HttpReason="Internal Server Error", HttpSubStatus="0", ErrorCode="The    filename, directory name, or volume label syntax is incorrect. (0x8007007b)", ConfigExceptionInfo="" ISAPI_END   Does anyone have any idea where I can go to correct the apparent flaw in the path? I have checked the web.config file and several other configuration files but can't find where this path is be

Directory lookup for the file failed with the operating system error 5

  
Hi I have a Windows desktop application that uses a SQLServer Express database.  The database files are downloaded from my website, followed by the application download (written in VBE).  The first procedure is to attach the database to the SQLServer instance from within the application. I have two test machines one runs Windows XP x84, the other Windows 7 x64.  I never have issues on attaching the database files in my test envirnoment but twice now other people downloading have got the following error System.Data.Sqlclient.sqlexception (ox 80131904) Directory lookup for the file C:\Documtents and Settings\Administrator\Desktop\Tem1.mdf failed with the operating system error 5 (failed to retrieve text for this error. Reason 1815) changed database context to 'master'. I'm not sure what the problem is and therefore how to correct the issue.  I attach the database in code using the create statement e.g. cmd7.CommandText = "USE Master CREATE DATABASE Tem1 ON PRIMARY (FILENAME = '" & DBFullPath & "') LOG ON (FILENAME = '" & DbLogPath & "') FOR ATTACH" Any help or suggestions would be very much appreciated. Chris    

Creating Database gives error : "Directory lookup for the file "xxxxx.mdf" failed with the operating

  
Hello FriendsI am creating Database using SQLDMOcode is as follows... Code Snippet SQLServer2Class server = new SQLServer2Class();server.EnableBcp = true;server.Connect(WebConfigurationManager.AppSettings["ServerName"] ,WebConfigurationManager.AppSettings["UserName"],WebConfigurationManager.AppSettings["Password"]);DBFileClass dbFile = new DBFileClass();           dbFile.Name = dbName;          dbFile.PhysicalName = "C:\\" + dbName + ".mdf";          dbFile.Size = 300;          dbFile.FileGrowthType = SQLDMO_GROWTH_TYPE.SQLDMOGrowth_MB;          dbFile.FileGrowth = 25;          dbFile.PrimaryFile = true;          LogFile2Class dbLogFile = new LogFile2Class();          dbLogFile.Name = dbName + "_log";          dbLogFile.PhysicalName = "C:\\" + dbName + "_log.ldf";          dbLogFile.FileGrowthType = SQLDMO_GROWTH_TYPE.SQLDMOGrowth_Percent;          dbLogFile.FileGrowth = 10;          Database2Class newDb = new Database2Class();          newDb.Name = dbName;          newDb.FileGroups.Item("PRIMARY").DBFiles.Add((DBFile)dbFile);          newDb.TransactionLog.LogFiles.Add((_LogFile)dbLogFile);          server.Databases.Add((_Database)newDb); This Code Generates Following Error !!]Microsoft][ODBC SQL Server Driver][SQL Server]Directory lookup for the file "D:\Projects\my_system\mySys

Lookup field issue after restore

  
After restoring a site collection in MOSS 2007, lookup fields cannot link up with the parent list. May I know if this problem fixed in MOSS 2010? Besides, the list item GUID in MOSS 2007 are changed after restoring. Does this case still appear in MOSS 2010? Thanks!

Issue Adding a new Lookup Field to an existing List Instance

  
I have a code base that houses all of the column, content types, template, and list instance definitions. Am using the Update functionlaity a lot from version to version. Has been working well to this point. I just added two new columns (fields), one a Lookup and the other a Multi-Lookup. The fields are added fine on the update, columns look correct and the content type to which these were added also look fine. I can create a new List instance from the content type, and the new lookup columns are fine. The problem is this. Any existing list instances that were created from this same content type, now blow up when I try and access list items via the SP GUI. Something about a valid GUID, I dont't have the exect error anymore, but will repost it when I recreate the issue for the tenth time. I tried deleting the new lookup fields from this new list instance, thinking that I might be able to re-add them to fix the problem, but I get a new stack trace when I try and re-add them. Any hints on where I can start digging would be appreciated. I think I'll start with comparing the list instance schemas between an existing list and a newly created one.  

Relation List Lookup Issue

  
Hi, I have 2 lists that are related. List 1 - costs ----- cost - Number quarter - Drop Down Created By - Default SP Field List 2 - people ----- person - User/Group AD Lookup team - drop down I am trying to link these 2 lists so I can retrieve the users team from the people list in a view for the costs. I have tried making it so the user has manually select their name for each cost (instead of using the Created By field), but when I try to make this value a lookup it doesn't allow me to select the person or team field from the people list? Does a lookup only allow you to lookup text values and is there a work around? Many Thanks, Michael

New column issue - Error number: MSSQL_REPL-2147199478

  

Hi,

In merge replication we have following issue which appears from time to time in few subscriptions.

When I added new column to table by using following procedure:

 

sp_repladdcolumn @source_object = N'TABLE_NAME'

,@column = N'NEW_COLUMN_NAME'

, @typetext =N'tinyint null'  

, @publication_to_add = N'PUBLICATION_NAME'

, @from_agent = 0

, @schema_change_script = null

, @force_invalidate_snapshot = 0 

, @force_reinit_subscription = 0

 

replication for few subscriptions gets following error:

The schema definition of the destination table 'dbo'.'TABLE_NAME' in the subscription database does not match the schema definition of the source table in the publication database. Reinitialize the subscription without a snapshot

Input-validation-Error issue when Model has complex types

  

Hi,

I have implemented aps.net mvc validation and it is working fine. Only issue I have "Input-validation-error" css class is not getting applied if model has complex types.

I am using my own data annotations for validation.

Any idea how to resolve  this.

Thanks

 


18456 error (severity 14) with a state of 38 issue

  

Hello, everybody,

I have a 18456 error (severity 14) with a state of 38 when trying to install CA Unicenter ServiceDesk application on my computer with SQl Server 2008 Express installed.

The user seems to be granted all required permissions, but the application shows the specified error and installation finishes.

So, the application tries to login to server and create a new database on it.

As far as I know. the 38 state means "Login successful, but database unavailable (or login not permissioned" .

Please help!


MCP

Error 1 Cannot publish because a project failed to build ? Click Once Deployment issue while publis

  

H! friends

Error  1 Cannot publish because a project failed to build ? Click Once Deployment issue while publishing the application ?

Can anyone tell me how to fix this problem? gone trhough many posts on net but didnt get the right solution for this ? If yu know how to fix this problem tell me plz? or any resource which can guide me to sucessful publishing

 

Pleas reply

 

Thanks

Regards

Vijay Gaur

 


Flat File Loading Problem -> Messed Up Delimiters and Error Logging Issue

  
Hey Everyone,

I have a Data-Flow task embedded in a Sequence Container (does not fail component on error) on the Control Flow panel of the SSIS designer.  This data flow task contains a connection to a Flat File Source -> A Data Transformation -> Into an OLE Db Destination.

The problem is that the Flat File isn't always delimited properly -> the client cannot be relied on to do this.

My question is when the delimiters are messed up, how can I capture the offending error row(s) from the Flat File Source?

What I've tried:
1) Set every column in the source flat file on error to: Redirect Row
2) Added a Script Transformation to pull the description and the record id out of the offending row
3) Added an Error file flat file destination to the end of the flow.

The package always fails on the Flat File Source and never Redirects the offending Row to the error output - I never see my onError Script Transformation go Green, Red, or Yellow - SSIS doesn't let it get there.

I'm really new to SSIS so sorry if this is a super basic question.

Here is the Error Text:

[Source - InventTable_csv [1]] Error: The column delimiter for column "RECID" was not found.
[Source - InventTable_csv [1]] Error: An error occurred while processing file "C:\------InventTable.csv" on data row 15228.
[DTS.Pipe

Upgrade to 4.0 - "Arithmetic operation resulted in an overflow Error" - MySQL driver issue

  

I upgraded to 4.0 and I'm now getting "Arithmetic operation resulted in an overflow Error" whenever I try to call information from the database. I'm using MySQL ODBC 5.1 for the site.

When I first started getting the error I could only return integer values and was using the connection string:

Driver={MySQL ODBC 5.1 Driver};Server=localhost;Database=myDataBase;User=myUsername;Password=myPassword;Option=

Error: 29528 -performance counters issue

  

Summary
=============================
you may get the following error while trying to install hotfix:

On setup log:
==============================================
Error Number : 29528
Error Description : MSP Error: 29528 The setup has encountered an
unexpected error while Installing performance counters.
 The error is: The configuration registry key is invalid.

Resolution:
==============
Check this key

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Servic es\Tcpip\Performance\Disable Performance Counters

It should be 0.

Open a command prompt window.
At the command prompt, type cd %Systemroot%\System32, and then press ENTER.

At the command prompt, type the following line, and then press ENTER:

unlodctr.exe MSSQLServer
lodctr.exe <SQL Server path>\binn\sqlctr.ini


Microsoft Online Community Support
Categories: 
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