Another BI & Programming Blog - Jason Yousef

Hello, Just a quick note on formatting SSIS date expression to display leading zeros for single digits days and months. With refeence to this article ... http://codingstuffs.blogspot.com/2007/03/pgp-inside-ssis-package.html The mentioned date variable can be done in a different way.. (DT_WSTR,4)YEAR(GETDATE()) + SUBSTRING("0" +   (DT_STR, 2, 1252) DATEPART( "MM", GETDATE()) , LEN( "0" +   (DT_STR, 2, 1252) DATEPART( "MM", GETDATE()) ) - 1, 2 ) + SUBSTRING("0" +   (DT_STR, 2, 1252) DATEPART( "DD", GETDATE()) , LEN( "0" +   (DT_STR, 2, 1252) DATEPART( "DD", GETDATE()) ) - 1, 2 ) or even using a smaller expression Right( "0" + (DT_WSTR, 2 ) MONTH(Getdate()),2)  + "-" + Right( "0" + (DT_WSTR, 2 ) DAY(Getdate()),2)  + "-" + (DT_WSTR,4)YEAR(GETDATE()) Hope that helps.

Today while I was updating a SSIS package and was ready to upload it to the MSDB, I noticed that "Save a copy as" is not an option under the FILE menu, Referring to my earlier post: Server Explorer not showing up on Visual Studio 2008 , looks like the settings reset must have erased it. the fix is to add it back on the menu!

SELECT CHAR([number]) AS [ALBHABET] FROM master..spt_values WHERE number BETWEEN  65 and 90

There are many ways to do it and it's perfectly done at MS website http://msdn.microsoft.com/en-us/library/aa337301%28v=sql.90%29.aspx Hope that helps someone...

The first step to start learning SSIS is to download the 'Adventureworks' Database from http://msftdbprodsamples.codeplex.com/ and download the sample packages from http://msftisprodsamples.codeplex.com/ Also more advanced resources that could help: http://technet.microsoft.com/en-us/library/cc966529.aspx http://www.microsoft.com/downloads/en/details.aspx?FamilyID=b1145e7a-a4e3-4d14-b1e7-d1d823b6a447 http://www.microsoft.com/downloads/en/details.aspx?FamilyID=705B03F3-1BBF-417F-9E63-92A00A4744E6

Therse tutorials will help you get your feet wet with SQL 2008 R2, introduced to the new featues. http://msdn.microsoft.com/en-us/library/ms167593.aspx

Hi, ever tried to read or write to an excel file and got that error?  "The 'Microsoft.ACE.OLEDB.12.0' provider is not registered on the local machine." Well it just happened to me today, I just got a freshly built machine, windows 7 ultimate 64BIT, 12 GB RAM, and Office 2010 installed. Anyway after investigating the issue, just make sure and load the 2007 Office System Driver: Data Connectivity Components from: http://www.microsoft.com/downloads/en/details.aspx?FamilyID=7554F536-8C28-4598-9B72-EF94E038C891&displaylang=en That solved the issue for me..