How do I format date value as yyyymmdd or any specific using SSIS expression builder?

I have a scenario where I need to create a folder on fly with current date in YYYYMMDD format.

Here is simple solution how we can achieve using Expression Builder in SSIS packages. Pick the variable that’s needs to be configured.

Go to properties of the variable you want to configure and click expression.

A Popup window will appear where you can select the variable you want to configure

Select the property you want to override. For me its Destination path property of the Source folder variable I am using in my package.

C:\Development\XXXXX\XXXXX\20130516\

Here is code that needs to append to the variable. So here is what I have used to get this in below format. 

(DT_STR,4,1252)DATEPART( "yyyy" , getdate() ) + 
RIGHT("0" + (DT_STR,4,1252)DATEPART( "mm" , getdate() ), 2) +
RIGHT("0" + (DT_STR,4,1252)DATEPART( "dd" , getdate() ), 2)

 For me its yyyymmdd format if you want some other format just change the interval one of the following this as per your requirement

• yyyy – Year
• q – Quarter
• m – Month
• y - Day of year
• d – Day
• w – Weekday
• ww - Week of year
• h – Hour
• n – Minute
• s - Second

Hope this helps!!!

Free eBook: Programming Windows 8 Apps with HTML, CSS and JavaScript

You can download the eBook in PDF format here: http://go.microsoft.com/FWLink/?Linkid=270056 (17.9 MB)

EPUB format is here: http://go.microsoft.com/FWLink/?Linkid=272592 (37.3 MB)

MOBI format is here: http://go.microsoft.com/FWLink/?Linkid=272591 (69.5 MB)

 

Happy programming!!

How to Remove Css Style from codebehind?

Here is how we can achieve this from codebhind in c#. Here is the sample code snippet I am here removing CssSytle from DIV but I works for any Control

   1: // Removing Div class when we have only transaction details

   2: divTransactionSummary.Attributes.Add("class", divTransactionSummary.Attributes["class"].ToString().Replace("prodiv", ""));

   3:               

Here “prodiv” is the class of div I have used in my aspx page for this DIV

Hope this helps!!

iPad Supported Video Formats

I got my first iPad and I am trying to know about that are the Video formats that are supported by iPad devices.

Here is the list

• H.264 video up to 720p, 30 frames per second, Main Profile level 3.1 with AAC-LC audio up to 160 Kbps, 48kHz, stereo audio in .m4v, .mp4, and .mov file formats.
• MPEG-4 video, up to 2.5 Mbps, 640 by 480 pixels, 30 frames per second, Simple Profile with AAC-LC audio up to 160 Kbps per channel, 48kHz, stereo audio in .m4v, .mp4, and .mov file formats.
• Motion JPEG (M-JPEG) up to 35 Mbps, 1280 by 720 pixels, 30 frames per second, audio in ulaw, PCM stereo audio in .avi file format.

I found this information via google. Thought this worth sharing.

SMTP Server Error: Bad sequence of commands. The server response was: you must authenticate first (#5.5.1)

This error occurs due to lock down of default mail server (127.0.0.1) by web hosting companies due to SPAM or what ever other security reasons. But if you use “localhost” or default server “127.0.0.1” on your local machine it should not be an issue. But if you have a situation where you need to relay e-mail to a remote mail server that is secured you get this exception.

So you need to handle well using built in classes provided by .NET. This is take care by NetworkCredential Class. This class provides credentials for password-based authentication schemes such as basic, digest, NTLM, and Kerberos authentication.

Here is a fully working quick code sample that you can use to get started on your own SMTP-Authentication supporting e-mail code.

   1: try

   2: {

   3:     SmtpClient smtpclient = new SmtpClient();

   4:     NetworkCredential NetworkCredential = new NetworkCredential(smtpUserName, smtpPassword);

   5:     smtpclient.Credentials = NetworkCredential;

   6:     string MailServer = ConfigurationManager.AppSettings["SMTPServer"].ToString();

   7:     MailMessage objEmail = new MailMessage();

   8:  

   9:     string FromEmail = ConfigurationManager.AppSettings["ErrorReportEmailFrom"].ToString();

  10:     if (FromEmail.IndexOf(";") > 0)

  11:     {

  12:         FromEmail = FromEmail.Replace(";", ",");

  13:     }

  14:     MailAddress FromAddress = new MailAddress(FromEmail);

  15:     objEmail.From = FromAddress;

  16:  

  17:     string ToEmail = ConfigurationManager.AppSettings["ErrorReportEmailTo"].ToString();

  18:     if (ToEmail.IndexOf(";") > 0)

  19:     {

  20:         ToEmail = ToEmail.Replace(";", ",");

  21:     }

  22:     objEmail.To.Add(ToEmail);

  23:  

  24:     string CcEmail = ConfigurationManager.AppSettings["CcEmail"].ToString();

  25:     if (CcEmail.IndexOf(";") > 0)

  26:     {

  27:         CcEmail = CcEmail.Replace(";", ",");

  28:     }

  29:     objEmail.CC.Add(CcEmail);

  30:  

  31:     string BccEmail = ConfigurationManager.AppSettings["BccEmail"].ToString();

  32:     if (BccEmail.IndexOf(";") > 0)

  33:     {

  34:         BccEmail = BccEmail.Replace(";", ",");

  35:     }

  36:     objEmail.Bcc.Add(BccEmail);

  37:  

  38:     objEmail.Subject = strSubject;

  39:     try

  40:     {

  41:         objEmail.Body = strBody;

  42:         objEmail.IsBodyHtml = true;

  43:         smtpclient.Host = MailServer;

  44:         smtpclient.Send(objEmail);

  45:     }

  46:     catch (Exception ex)

  47:     {

  48:         throw ex;

  49:     }

  50:     finally

  51:     {

  52:         objEmail.Dispose();

  53:     }

  54: }

  55: catch (Exception ex)

  56: {

  57:      

  58: }

Enjoy coding!!