SSIS – simple way to start
These are the link you can find for easy way to start SSIS.
http://msdn.microsoft.com/en-us/library/ms170419.aspx
http://www.accelebrate.com/sql_training/ssis_2008_tutorial.htm
http://www.mssqltips.com/tutorial.asp?tutorial=200
How to Run a Package SQL Server 2008 R2
To run an Integration Services package, you can use one of the following tools:
• The dtexec command prompt utility (dtexec.exe).
• The Execute Package Utility (dtexecui.exe).
• A SQL Server Agent job.
http://msdn.microsoft.com/en-us/library/ms138023.aspx
Running an SSIS Package Programmatically on the Local Computer SQL Server 2008 R2
With only a few lines of managed code and the correct prerequisites on the local computer, you can run a package from a custom application. The custom application can be a Windows Forms application, a console application, an ASP.NET Web form or Web service, or a Windows service.
http://msdn.microsoft.com/en-us/library/ms136090.aspx#Y1954
I think this code will be useful
This can be run creating console application.
namespace RunFromClientAppCS
pkgLocation =
@"C:\Program Files\Microsoft SQL Server\100\Samples\Integration Services" +
@"\Package Samples\CalculatedColumns Sample\CalculatedColumns\CalculatedColumns.dtsx";
app = new Application();
Console.WriteLine(pkgResults.ToString());
These are the link you can find for easy way to start SSIS.
http://msdn.microsoft.com/en-us/library/ms170419.aspx
http://www.accelebrate.com/sql_training/ssis_2008_tutorial.htm
http://www.mssqltips.com/tutorial.asp?tutorial=200
How to Run a Package SQL Server 2008 R2
To run an Integration Services package, you can use one of the following tools:
• The dtexec command prompt utility (dtexec.exe).
• The Execute Package Utility (dtexecui.exe).
• A SQL Server Agent job.
http://msdn.microsoft.com/en-us/library/ms138023.aspx
Running an SSIS Package Programmatically on the Local Computer SQL Server 2008 R2
With only a few lines of managed code and the correct prerequisites on the local computer, you can run a package from a custom application. The custom application can be a Windows Forms application, a console application, an ASP.NET Web form or Web service, or a Windows service.
http://msdn.microsoft.com/en-us/library/ms136090.aspx#Y1954
I think this code will be useful
This can be run creating console application.
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();
}
}
}
1 comment:
Hey, thanks for the blog article.Really looking forward to read more. Cool.
SAS online training
SAS training
structs online training
structs training
Webmethods online training
Webmethods training
Wise package studio online training
Wise package studio training
Python Django online training
Post a Comment