Profile cover photo
Profile photo
Jatinder Singh
13 followers
13 followers
About
Jatinder's posts

Post has attachment
Error ‘Microsoft Office Excel cannot access the file’ while accessing Microsoft Office 11.0 Object Library from SSIS
When executing the Open function. I received the following exception: Microsoft Office Excel cannot access the file ‘e:\report\report.xls’ . There are several possible reasons: • The file name or path does not exist • The file is being used by another progr...

Post has attachment
Interop type 'Microsoft.Office.Interop.Excel.ApplicationClass' cannot be embedded. Use the applicable interface instead
.NET 4.0 allows primary interop assemblies (or rather, the bits of it that you need) to be embedded into your assembly so that you don't need to deploy them alongside your application. Reason: In most cases, this error is the result of code which tries to i...

Post has attachment
Long running SQL Agent job
We tried to launch an .exe from SQL Server Agent Job and job keeps on running, it need to be stopped manually. Steps to troubleshoot #1 . Any program that has windows interaction i.e. opens any type of window e.g. Notepad, ms-paint or excel etc. #2 . So it ...

Post has attachment

Post has attachment
Unable to generate a temporary class (result=1)
While trying to Invoke Web Services we faced following error: Error: Unable to generate a temporary class (result=1). error CS0029:
Cannot implicitly convert type
' WebServices.Proxy.CustomType ' to
'WebServices.Proxy.CustomType[]' error CS0030: Cannot
...

Post has attachment
Task failed because 'sgen.exe' was not found
In one of SSIS package we were trying to build the SSIS script task and it was failing with following  message: Task failed because "sgen.exe" was not found, or the correct Microsoft
Windows SDK is not installed. The task is looking for "sgen.exe" in the
...

Post has attachment

Post has attachment
Error 13005 : Error translating SQL statement: line dbAMp
We started receiving error 13005 while executing sf_replicate. The error was due to xp_cmdshell which is making call to dbAmp.exe. We also noted that sf_replicate3 was working fine, a peek into procedure revealed that it uses "Select * into XYZ from salesfo...

Post has attachment
Elance test

Post has attachment
Performance Improvement
  Update Statistics : Let's look at following query. SELECT * FROM customer WHERE city = 'Pune' AND phone = '2020666666' -- dummy Number     Above query contain two fields in the "WHERE" clause and suppose there are two indexes defined, each containing one ...
Wait while more posts are being loaded