Another BI & Programming Blog - Jason Yousef

Greetings....as I mentioned before sometimes I use my blog posts as a way to remind myself of the stuff that I need frequently and never keep to memory. I needed to add a link in a new SSRS report and the link has to open in a new browser's window. Just Right click on your report field, select "Text Box Properties", select "Action", click on the "FX" sign to write that special expression. ="javascript:void(window.open('" + Fields!URL.Value + "','_blank'))" Assuming that your URL is dynamic and the column name is "URL" in your dataset SSRS Link in  new Browser's Window Hope that helps...

Today I was checking a question on one of the forums about trimming a leading zero from a string, and the string has characters, also has middle and ending zeros, so the methods that comes to your mind quickly won't work !!  If you're thinking about converting to INT then to a string again ! so I thought about a script component that uses the .NET (String.TrimStart Method) you can read about it more here : http://msdn.microsoft.com/en-us/library/system.string.trimstart.aspx here's the input scenarios that I came with and the output results.... Steps: 1-I created a flat file (TXT) with punch of rows to test 2-Only one output from my flat file for simplicity, named Col0 3-script component (transformation Type), using Col0 as input. 4-created an output column Col0Cleaned   5-added the above highlighted line... and that's' it!   Please let me know if you have any scenarios that this solutions couldn't fix! package and solution can be do...

SSIS stored the packages on 2 locations, on MSDB DB and on the file system. If you're using the file system, it's very important to make sure that your package store location points to the location of your packages. The default packages location is: C:\Program Files\Microsoft SQL Server\90\DTS\Packages C:\Program Files\Microsoft SQL Server\100\DTS\Packages C:\Program Files\Microsoft SQL Server\110\DTS\Packages and the file that needs to be edited, by default located at : (2005) C:\Program Files\Microsoft SQL Server\90\DTS\Binn\MsDtsSrvr.ini.xml (2008) C:\Program Files\Microsoft SQL Server\100\DTS\Binn\MsDtsSrvr.ini.xml (2012) C:\Program Files\Microsoft SQL Server\110\DTS\Binn\MsDtsSrvr.ini.xml Just make sure to search for "MsDtsSrvr.ini.xml", you might have installed SQL server on a different drive or location. Edit that XML file to point to your current location.... After you modify the service configuration file, you must restart the se...

If you need to check if the SSIS service is installed or if whether it's running or not. If you need to know more about the SSIS service, let me refer you to this post... http://www.ssistalk.com/2009/11/04/ssis-what-does-the-ssis-service-actually-do-anyway/ Anyway... You can pull the RUN command and type SERVICES.MSC and you'll get to the list of the locally installed services, or go to : CONTROL PANEL --> ADMINISTRATIVE TOOLS --> SERVICES Search for SQL server Integration Services, by clicking on S or scrolling down.   right click and you'll get all the options like START/RESTART/STOP. Hope that helps!

Hi, Today I will be talking about the SQL Server Import and Export Wizard, which is one of the easiest ways to develop your first SQL Server Integration Services (SSIS)  package, and it so useful to export and import data from multiple sources to a various destinations, varies from relational database tables to text files. Through the demo I will be using SQL Server 2012 on top of a Windows 2008 Sever, but the wizard is exactly the same as it was in erlier versions. You start by learning the different ways to get the wizard up, and it is straight forward and can be launched from various locations 1-from the run commend or the command prompt, you might type "DTSWizard.exe" and hit enter, which will get the wizard up and running..  2-By right click on your database---> Tasks--->"Import Data" or "Export Data"  3-From SQL Server Data Tools (SSDT) , right click on "SSIS Packages" and select "SSIS Import and Export Wizard...

Today I saw an interesting question in EE about how to create a RowNumber in the data flow task but partitioned by an ID column. Row Number is easy and could be done using a script task in the control flow or inside a script component in the data flow task, there is also a Row Number transformation, a free community extension. But the partition by is the problem here, which just need a custom script to do it, and the answer to that is by using a synchronous script component as follows: Our Input: Add your flat file source, I'm not going to go into details about the flat file source, you could use any source and configure it the way you want, the point here is our input is 2 columns and we need to create the row number column partitioned by the ID column. I'm assuming that the input is sorted on the ID< if not, so you need to add a sort transformation to the flow before the script component. and thanks to Valentino ( B | T ) for reminding me!  The...

I often see that simple question in forums and some people get confused over it, so I'll try to shed some light about it. BIDS stands for (Business intelligence development studio) it's a small subset of Microsoft's Visual Studio product, using the visual studio 2005,2008, or 2010 shell based on your SQL server installation version. Comes for free as part of your SQL server installation. As it's not the full Microsoft Visual Studio Product, it only allows you to develop business intelligence solutions (BI) for SQL server, such as Reporting services ( SSRS ), integration services ( SSIS ), and Analysis Services ( SSAS ). In SQL 2012 it is not called BIDS any more, it is yes using the Visual Studio 2010 shell, but now it is called SQL Server Data Tools, or SSDT for short. Where is it in my computer?  SQL 2008 R2 BIDS 2008 SQL 2012 SQL Server Data Tools - SSDT in SQL Server 2012 Hope that helps someone.... More about it? Check http://m...