Another BI & Programming Blog - Jason Yousef

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

This might be helpful to someone while troubleshooting your SSIS packages. http://msdn.microsoft.com/en-us/library/ms345164.aspx

I recently came across an interesting   Question In EE   and was puzzled about how to achieve that using SSIS out of the box tasks, which was impossible as SSIS can;t use on the fly columns in the source or the destination. SO definitely only could be done using a script task, but that wasn't really my favorite part, I'm the worst when it comes to that. Anyway because I had some past experience as developing ASP pages using vb.net, so quickly came to my mind to build a DataGrid   using a SQL query, then export the grid to a text file, which worked fine, The I came across the   DataReader   which is a neater and easier way. So here I'm going to demonstrate how to Iterate over a list of   views   which has different structure to flat file using Script Task. I'll be using the famous "AdventureWorksDW2008R2" DB for SQL 2008 and  "AdventureWorks" for SQL 2005 which could be downloaded for free   here , The demo is being done on a windows Vista 64B...