WCF link

http://msdn.microsoft.com/en-us/library/aa480210.aspx

http://msdn.microsoft.com/en-us/netframework/wcf-code-samples.aspx

http://msdn.microsoft.com/en-us/library/ms750530.aspx

How to add reference in SSIS

1 ) put assembly in C:\WINDOWS\Microsoft.NET\Framework\v2.0.50727

OR C:\Program Files\Microsoft SQL Server\90\SDK\Assemblies

for accessing the dll , generate strong name for assemblies and put in Gac folder C:\windows\assembly\

Open the Add Reference dialog box again and the assembly should be visibile.

Execute SQL Task Pragmatically


Dim p As New Package()

Dim cm As ConnectionManager = p.Connections.Add("ADO.NET")

cm.ConnectionString = " Data Source=rajeshsharma\sql2005; Integrated Security=SSPI;Initial Catalog=test;"
Dim e As Executable = p.Executables.Add("STOCK:SQLTask")
Dim th As TaskHost = CType(e, TaskHost)
Dim est As ExecuteSQLTask = CType(th.InnerObject, ExecuteSQLTask)
est.Connection = cm.Name
est.SqlStatementSourceType = SqlStatementSourceType.DirectInput
est.SqlStatementSource = " CREATE TABLE TestTable7 ( ID int NOT NULL, Description nchar(100)); "
'run the package

Dim r As DTSExecResult = p.Execute()
If (r = DTSExecResult.Success) Then

End If

How to count week in month

  public int GetWeekInMonth(int year, int month)

        {

            CultureInfo cinfo = CultureInfo.CurrentCulture;

            Calendar MyCal = CultureInfo.InvariantCulture.Calendar;

            int CountWeek = 0;

            for (int icount = 1; icount < cinfo.Calendar.GetDaysInMonth(year, month); icount++)

            {

                string str = Convert.ToString(MyCal.GetDayOfWeek(new DateTime(year, month, icount)));

                if (str.Equals(“Monday”, StringComparison.OrdinalIgnoreCase))

                {

                    CountWeek = CountWeek + 1;

                }

 

            }

            return CountWeek;

        }

 

 

Hello world!

Welcome to WordPress.com. This is your first post. Edit or delete it and start blogging!