SSIS: How to know if the installed Oracle Client is 32bit or 64bit on your SSIS machine

In your SSIS packages, if you need to read from or write to Oracle likely that you most probably hit some Oracle Client related configuration issues. ORACLE_HOME, PATH environmental variables etc. Sometimes you may see a machine needs to run SSIS packages and you see that an Oracle Client is installed but you don’t know…

2

Registration is now open for TechEd Middle East 2011

Registration is now open for TechEd Middle East 2011. Tech·Ed is Microsoft’s premier technical education event providing the most comprehensive technical training on Microsoft’s suite of products, technologies, solutions and services and takes place in Dubai, March 8 – 10, 2011. * Hear about the future of Microsoft’s products and technologies directly from the Microsoft…

0

Important: ASP.NET Security Vulnerability

On 17th of September 2010, we released a Microsoft Security Advisory about a security vulnerability in ASP.NET.  This vulnerability exists in all versions of ASP.NET. This vulnerability was publically disclosed late Friday at a security conference.  We recommend that all customers immediately apply a workaround (described in the Scott Guthrie’s blog post in http://weblogs.asp.net/scottgu/archive/2010/09/18/important-asp-net-security-vulnerability.aspx or in the…

0

Accessing Excel files on a x64 machine

In the old times while all the CPUs were 32bit, we were happily using JET OLEDB Provider reaching Excel or MDB files for long time without any issues. After we started using x64 CPUs and x64 Windows machines, we noticed that JET OLEDB Provider is not working. The reason for this was x64 Windows operating…

73

Why my 64bit adplus.vbs is failing with "Error: 76 – Path not found" ?

I haven’t touched much about debugging but I admit that sometimes you have no other chance than analyzing a post-mortem dump or live dump to troubleshoot a problem. Our “Debugging Tools for Windows” package comes with a very hand VBScript : “adplus.vbs”. It simplifies lots of things for us. I was working on a customer scenario….

6

Microsoft SQL Server JDBC Driver 3.0 is released :)

Our SQL Server JDBC Driver 3.0 is released recently. If you’re coming to SQL Server from Java, make sure that you’re using our newest JDBC Driver : http://www.microsoft.com/downloads/details.aspx?FamilyID=a737000d-68d0-4531-b65d-da0f2a735707&displaylang=en If you don’t know the current SQL Server JDBC Driver version you’re using, please compile my tiny little a few lines java console app below and run on…

0

Why the breakpoints that I set in my “Script Task” (not “Script Component” in the Data Flow *) never hits ?

  Why the breakpoints that I set in my “Script Task” (not “Script Component” in the Data Flow *) never hits ? On a Windows 2008 x64 machine, you’re running SQL Server 2008 x64. Let’s say you added a single “Script Task”; you wrote a very simple MessageBox.Show(“Hello World”); line and put a breakpoint to…

18