Another BI & Programming Blog - Jason Yousef

A recent question on SQL Server Central  was asking about how to process the last hour downloaded files. I think it's fairly simple using a script task to get the files creation date property, and then added a constant constraint to check the difference between now and the creation date, then pass through to the data flow task to process the file. I've created 6 variables, I'm here getting more usable file properties, but you don't have to do that, I'm just here showing the concept more than doing the exact time difference. Add a "foreachloop Container" and a "script task" inside. edit the "Foreachloop Container" location to your file system location. (the one that has your files). Map the 'FilePath' variable to the output of the "foreachloop" Edit the "Script Task" ,I'm using VB.net language here. Imports System Imports System.Data Imports System.Math Imports Microsoft.SqlServer....

Like the title is saying, when you attempt to create a data-driven subscription in SSRS, E-mail is not one of the listed options. That means you've not configured a SMTP server yet ! Start -> All Program -> Microsoft SQL Server 2008 / R2 -> Configuration Tools -> Reporting Service Configuration Manager Then the option will be Appear as normal. Hope that helps.

Recently I bought a Toshiba laptop from best buy and that was my biggest mistake, everybody warned me from Toshiba but I didn't listen....  the hard drive crashed after 3 months and it was a nightmare over the phone with them for hours so they can understand what I'm trying to say !!!!! and the guy over the phone kept asking "did you pack your data before shipping the laptop" and he's processing a repair for a crashed hard drive... Also to mention that you'll have to pay $25 so they can provide you with a UPS box and pre-paid shipping label. The whole process took 2 weeks to call, send and receive..... The bottom line that they're cheap company that doesn't stand by their product and by their customers, they dont' care about the customer to leave them without a laptop for 3 weeks!! and you pay to get your stuff fixed while it's still under the warranty !! That's only my personal experience and I'm sharing it for knowledge......