Monday, December 19, 2016

Part 1: Step by Step guide to create, install & register windows service in visual studio 2013 to read single CSV file and save data in a database table

Points covered in this video are: 

 1. Windows service with pre-defined schedule for reading CSV file data. 
 2. Loading the CSV file data into a data table. 
 3. Using SQLBulkCopy to save the CSV file data into a database table. 
 4. Moving the source file to different folder after successful processing 
 5. Creating an installation setup project using the InstallShield 
 6. Registering the windows service 


1. Single CSV file to be read by windows service 

Saturday, December 17, 2016

Part 11: C# Tutorial – Methods in C#

We will cover following points in this article

1. Why methods
2. Method Signature
3. Difference between static and instance methods


     Why Methods

1. Methods are also called as functions.
2. Method is a code block that contains a series of statements and used to define the
    behavior of a class.
3. Methods are extremely useful because they allow you to separate your logic into 
   different units. You can pass information to methods, have it perform one or more 
   statements, and retrieve a return value. 
4. Methods make application maintenance easier. 

Methods Signature 

< attributes> 
<accessmodifiers> <return-type> <method-name> (<parameters>) 
    //method body 
<access modifiers> - public, private, protected, internal, protected internal 
<return-type>          - void or any valid data type 
<method-name>     - can be any meaningful name except reserved keyword <parameters>         - are optional 

Static vs Instance methods 

1. Static methods are declared using static modifier. Static methods are invoked using 
    the class name. 
2.  Instance methods are declared without using the static modifier. Instance methods 
     are invoked using the instance of the class. 
3. A static method cannot access non-static class level members
4. Instance methods can access static fields. 
5. If a method is declared as static then only one definition of the static method exists in 
    the memory. Multiple instances/objects of a single class can invoke only one       
    definition of the static methods but each objects will have its own separate instance 

Friday, November 11, 2016

Step by Step guide to use SSIS Tool - Import and Export Wizard


SQL Server Data Tools for visual studio can be downloaded using the following link:


An Integration Services catalog (SSISDB) was not found


In this tutorial we will talk about the "Integration Services catalog (SSISDB) was not found" error shown while creating a deployment project.
The error is as follows:
An Integration Services catalog (SSISDB) was not found on this server instance (“ServerName\MSSQLSERVER2012"). To deploy a project to this server, you must create the SSISDB catalog. Open the Create Catalog dialog box from the Integration Services Catalogs node.

Step by Step Guide to Create Windows Service for Writing Data into File based on Insertion in Table


This tutorial follows a step by step approach to show how to create a windows service to monitor insertion into a table, retrieval of the newly inserted records from the table and writing the data into a file as a delimited string.
Step by Step Guide for Creating a Windows Service for Writing Data into a File based on Insertion in Table
General Issues:-
1. How to create a windows service that generates a file as a delimited string in a shared
location based on record insertion in a table.
2. Scheduling the windows service to monitor the Database table for new record insertion and
pick newly generated record and insert into the file as a delimited string
3. Monitoring Windows Service
4. How to Monitor a database table from Windows Service?
Points covered
1. Monitoring Purpose Windows Service
2. Windows Service Creation for Writing Data Into a File
3. Scheduling the Windows Service to Monitor Insertion into a Table
4. Inserted Data into the table will be read from Windows Service Code and the data will be
written to a File