Visual Studio 2010 / SSIS 2012 [ Sql Server 2012 ] Toolbox ( “I can’t see my SSIS 2012 toolbox in VS 2010” )

יום חמישי, נובמבר 8, 2012

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 2010On 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 correctly .. I go out and do the following : Open a...

TSQL: Concatenate Column from Multiple Rows into String

יום שלישי, ינואר 24, 2012

Ok , So I had a problem related to concatenation of a single Column into one ( same ) column when using GROUP BY . The Problem came from a Reporting Services perspective and there might be other solutions ( like coding in VB.NET in the report ) I have found a very nice samples : Option 1: use Northwind declare @CategoryList varchar(1000) set @CategoryList ='' select @CategoryList = @CategoryList + ' , ' +...

T-SQL Israeli CardID Checker / ת.ז. ישראלית

יום שלישי, אוגוסט 24, 2010

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...
69 תגובות

Express 2010 RTM Download summary

יום חמישי, אפריל 29, 2010

Express 2010 RTM Download summary Any one who really knows me , knows that my 2nd passion is the Express toolset :) Now, that Visual Studio 2010 has RTM-ed a few days (weeks) a go I have decided to build a small collection of relevant URLs : from http://www.microsoft.com/express/Downloads/ Visual Basic 2010 Express Visual C# 2010 Express Visual C++ 2010 Express Visual Web Developer 2010 Express ( Part of the WebPI Toolkit ) All - Offline Install ISO image file And the SqlServer Express 2008 R2 – with the new 10GB support :) Microsoft SQL Server 2008 R2 RTM - Express with Advanced Services Microsoft SQL Server 2008 R2 RTM...

Exporting/Saving RDL files from http://server/reports

יום שלישי, אוגוסט 11, 2009

Exporting/Saving RDL files from http://server/reports Here are the steps: 1. Go to Report on Report Manager 2. Click "Show Details" 3. Click "Properties" of the report you need to Export 4. Under "Report Definition", click on "Edit". You will be able to either "Open" or "Save" the RDL file. … And in Pictures ;) That simple :)

SSIS on Excel 2007 Data Import & Moss2007 :"Excel Source Output" . The column status returned was: "Text was truncated or one or more characters had no match in the target code page."

יום חמישי, ינואר 8, 2009

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 &...

Try the installation again using a valid copy of the installation package 'sqlncli.msi'

יום שבת, ינואר 3, 2009

Problem: If SqlServer 2005 Setup fails and roll back with the following error message: "An installation package for the product Microsoft SQL Native Client cannot be found. Try the installation again using a valid copy of the installation package 'sqlncli.msi'." Reason: It’s probably due to the fact that you have installed .NET Framework 3.5 BEFORE you have installed SqlServer 2005 ;) Solution: To work around this problem, uninstall SQL Native Client by using Add or Remove Programs. On a cluster, uninstall SQL Native Client from all nodes. Then, run SQL Server...
3 תגובות

Report Viewer for Visual Web Developer Express

יום שבת, דצמבר 27, 2008

Report Viewer for Visual Web Developer Express The Visual Web Developer Express is one of my favorites , both the previous 2005 & 2008 versions as well as the new and shining all around fully functional – Visual Web Developer 2008 SP1 Express Edition ( which has support for ClassLibrary & Silverlight 2.0 projects as part of the Solution – Single Environment ! ) It seems that only a few days a go the Microsoft Report Viewer Add-on for Visual Web Developer 2008 Express has been released Microsoft Report Viewer Add-on for Visual Web Developer...

Move from Access 2007 to Sql2008

יום שבת, דצמבר 20, 2008

I was working on a small webcast on migration from Access to SqlServer Express edition and it seems that from the 2008 version , it’s no longer possible (by default) from the Access ribbon strip (Express & Developer edition were tested ). This option worked on SqlServer 2005 ( All versions , as far as I know ) On the other hand, we know that even the Express edition of SqlServer 2008 contains the Import/Export Wizard ( which in the SqlServer2005 Express was absent )
תגובה אחת