For some reason , you can’t develop SSIS 2012 Packages on Visual Studio 2012 , the Business Intelligence Projects of the Sql Server 2012 resides on Visual Studio 2010 On the other hand I have problem updating SqlServer 2012 Stored Procedures on the Visual Studio 2010 … but that’s another story Problem : I can’t see my SSIS 2012 toolbox in Visual Studio 2010 lets’ show it visually – there is no SSIS toolbox , all you see is “GENERAL” Solution : Usually when the Visual Studio Toolbox doesn’t appear...
T-SQL Israeli CardID Checker / ת.ז. ישראלית Once in a while I come across code that I didn’t fins in the internet … mainly because it’s for local use ;) This is one of these times :) This code is the T-SQL version of the algorithm that checks the given Israeli CardID , and adds a leading Zero , if need one ( like in my personal case ) , and calculates the “Check Number” ( SIFRAT BIKORET ) , if it’s missing. I needed this for an SSIS Package that loaded monthly information needed for my SharePoint...
SSIS on Excel 2007 Data Import & Moss2007 One of the crucial stages in moving managers from the “Simple all I want I get from Excel” to a more centralized platform like Sharepoint is moving their data ! Well lately not only have I been a : “HTML” “SharePoint Designer 2007” “Adobe Photoshop CS2” & “Paint.Net” Graphics “General Specific Site Collection Moss2007 Admin” “InfoPath 2007 Browser Compatible Developer” (including InfoPath C# Code) “General Web Service & WCF Programmer” “Camtasia...
SQL Server 2008 Server Service Configuration Due to the fact that the SQL Server 2008 February CTP Is Now Available is the closest thing that there is to the SQL 2008 RTM, counting the seconds . I have decided to install this CTP. But, each time I have installed I've chosen all possible options which is the DatabaseEngine AND the AnalysisServices AND the ReportingServices ... and EACH TIME the DatabaseEngine and ReportingServices would fail or if i've didn't check the SSAS then it would...
SQL 2008 RTM, counting the seconds need I say more ? The picture says all - from here : https://www.microsoft.com/sqlserver/2008/en/us/default.aspx Download from here : https://www.microsoft.com/sqlserver/2008/en/us/trial-software.aspx