Another BI & Programming Blog - Jason Yousef

Pinal Dave has a huge list of qestions for the DBA interview questions. http://blog.sqlauthority.com/2011/07/01/sql-server-interview-questions-and-answers-frequently-asked-questions-complete-downloadable-list-day-0-of-31/

How to control the success and failure of the package and execute it successfully?  Sometimes the requirement is to continue the execution even if an error has raised, might be a package that has nondependent tasks. There are 3 ways to do that… 1- Setting up ‘MaximumErrorCount’ property of the container as ‘0’ instead of the default ‘1’. 2- Setting up ‘ForceExecutionResult’ property to ‘success’ for the task properties instead of the default ‘None’. 3- In tasks sequence, we can set ‘On Completion’ precedence constraint instead of ‘Success’. Hope that helps.

Hi, I was getting that nasty error message, although you could test the OLEDB connection from the Sybase “data source configuration” and gets a success notification!! [IM002] [Native Code: 30136] [ASEOLEDB]Data source not found and no default driver specified   I also made sure that the OLEDB connection are there and configured well under 32 BIT and 64BIT, and the Sybase “data source configuration”  gives a success message when I test them.   So I thought the error is relevant to SSIS and it’s permuissions, not the Sybase, I started investigating the service account that SSIS is running under and if it got access to the C:\Sybase\DataAccess64\OLEDB\DataSources As Sybase ASE 15.5 was installed on my root drive C:\ and I’m using win & 64 BIT. I'd the same setup and configuration working on a vista 64 bit, but found other posts online about the driver and it is working well on windows 7. The full error message is:   TITLE: Microsoft Visual Studio -------...

Package Configurations http://msdn.microsoft.com/en-us/library/cc895212.aspx Pass Variables from child to parent back http://vsteamsystemcentral.com/cs21/blogs/steve_fibich/archive/2007/09/29/passing-a-value-back-and-forth-from-a-parent-package-to-a-child-package-in-ssis.aspx

Today I came across a requirement to get all the files and folders list from a FTP server, The only way to get that will be through a script task that will loop through the files and get it into a SQL table. Here's the question. and here's my proposed solution.... I’ll be using a free test server ftp.secureftp-test.com User/Pass: test We'll need to create a table to hold our results: CREATE TABLE [dbo].[FTPList](     [ListID] [int] IDENTITY(1,1) NOT NULL,     [DateTime] [datetime] NOT NULL ,     [Folder] [varchar](100) NOT NULL,     [FileName] [varchar](100) NOT NULL) Now let's start.... •    Drag a “Script Task”. •    2-edit the code as shown here: Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer.Dts.Runtime Imports System.Data.SqlClient Imports System.Collections.Generic Imports System.Text Imports System.Net Imports System.IO ...

Today's post is short and sweet, I just couldn't resist to share this cool option !!Never heard about this trick before, so cool, gets you a better broad [control panel] over you PC!! check it here http://www.bleepingcomputer.com/tutorials/tutorial158.html

I do some webdesigning in my own side business, and was installing some fonts, then this crazy idea came to my mind about using the default fonts that comes installed in windows to produce shapes in SSRS. The various fonts are called " Webdings, Wingdings, Wingdings2 and Wingdings3 " Basically you'll use IIF or SWITCH to set your desired shape, you'll need to use capital letters, small letter or numbers. The list of the shapes and the corespondent key could be found here http://www.purplehell.com/riddletools/wingdingschart.htm P.S. Use IE to view that page, firefox doesn't display that font correctly!! Examples: Hope that helps someone.....