How to run SSIS package using C# code

Hello friends,

Here again i am going to show you how you can call an ssis package using C# code. as we know we have execute ssis package component to call other package but if you are going to call a set of ssis package and all those package location store in a database , in that case execute package will open different dataflow window to call one after another ssis package. It’s always not good. So we can create a dynamic string with a variable and we can use that variable inside a C# to call number of packages

.
Here is the code (a packge name as calculated columns .dtsx)


using System;

using Microsoft.SqlServer.Dts.Runtime;

namespace RunFromClientAppCS

{

class Program

{

static void Main(string[] args)

{

string pkgLocation;

Package pkg;

Application app;

DTSExecResult pkgResults;

pkgLocation =

@"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services" +

@"\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx";

app = new Application();

pkg = app.LoadPackage(pkgLocation, null);

pkgResults = pkg.Execute();

Console.WriteLine(pkgResults.ToString());

Console.ReadKey();

}

}


enjoy !!

Different ways to Execute SSIS Package

Different ways to execute SSIS Package

When we develop a package, we execute it through Business Intelligence Development Studio (BIDS), for testing the package functionality. Once the package is developed and signaled green for a proper intended behavior we deploy it and then schedule it and we are done as a developer. But there are some other ways also apart from BIDS and SQL Agent Job, that can be used to execute a package.
Let's see how many different ways we can execute an SSIS package in:?
1. Using Dtexec utility from command prompt or DOS prompt
2. Using Dtexec utility from powershell or DOS prompt
3. Using DtexecUI also known as Execute Package Utility
4. Using code (C# or VB.Net)
5. Using a batch file and schedult it through Task scheduler
6. Using sp_start_job procedure to execute a sql agent job
7. Using xp_cmdshell to execute a package deployed in MSDB database or from File System
8. Using BIDS
9. Using SQL Agent job

How Checkpoints Work

Uses of strip line in SSRS to indicate today's date

hi to all,
 here i am posting a report which will indicate today's date by aline . this kind of reports is implementing in those data which will have a dead line target value .
 so i wrote a simple query which will show u 5 days befor and 5 days after of current date
 the query is :

DECLARE
 @table TABLE (dates datetime) DECLARE @a int
SELECT
 @a = - 5 WHILE (@a != 6) BEGIN DECLARE @dat datetime
 SELECT
 @dat =(SELECTDATEADD(DAY, @a, GETDATE()))
 INSERT
 INTO @table VALUES (@dat)
 SELECT
 @a = @a + 1 END
 SELECT
 CONVERT(VARCHAR(8), dates, 3) AS [DD/MM/YY]
 FROM
 @table
then i took a bar chart. i put the value in x axis. in the properties window u wil get strip line there i configure as i mentioned in the figure

 afetr that report look like below.

.. please try it its a very simple interview queston also ,

thanks& regards
sitakanta

  

How To Execute SSIS Packages By SQL Server

@filepath is the main folder of the package and @package name is the ssis package name


Declare @FilePath varchar(2000)
Declare @cmd varchar(2000)
 
DECLARE @package_name varchar(200)
Declare @PackageCount int
Declare @X int
Set @X = 1
Set @PackageCount = (Select COUNT(*) from Packages)
set @FilePath = 'C:\Package Path'
While (@X <= @PackageCount)
Begin
 
    With PackageList as
    (
    Select PackageName, Row_Number() Over(Order by PackageName) as  Rownum
    From Packages
    )
    SELECT @package_name = PackageName
    FROM PackageList
    Where Rownum = @X
 
    select @cmd = 'DTExec /F "' + @FilePath + @Package_name + '"'
 
    print @cmd
   
    Set @X = @X + 1
   
    exec master..xp_cmdshell @cmd
 
 
End

HOW TO BACK UP ALL DATABASE FROM A SERVER LIST MENTION IN TABLE

Hi friends,
i attached one package to grab all the database name from a server list stored in the table and mail to specify mail id through send mail task.please make a look on it .

use this link i uploaded
http://www.keepandshare.com/doc/3670846/package1-dtsx-march-13-2012-4-09-pm-53k?da=y

regards
sitakanta

How to improve performance in ssis & ssrs

Improving performance will gv ur work good

SSIS, for performance improving we need to use less component in data flow items, for example in place of using data conversion component u can use a type cast in derived column. same for character map,and kp the buffer size 1000.so that moving of data to the btree buffer memory will b easier,and try to implement always parallel execution of data, use a SQL select statement to retrive data from a view or table except unused column,and one more if u r using look up then use partial or full catch mode.These are some tips in SSIS

coming to SSRS part many of reports are memory-intensive so try to use 64 bit option.Reduce the size of the dataset.Simplify the grouping, filtering, or sorting logic in the report to use less memory, if ur stored procedure taking time try to reduce in query level.and try to kp timeout in connection string between 3000 to 6000.u can type manually in connction string.

So these are the properties u can follow up.