string strSourceConn = @"D:\SSIS\Test3\emp.txt"; // Create a new SSIS Package //Package package; Microsoft.SqlServer.Dts.Runtime.Application app; string pkgLocation = @"D:\SSIS\Test3\Integration Services Project2\Integration Services Project2\Package.dtsx"; app = new Microsoft.SqlServer.Dts.Runtime.Application(); package = app.LoadPackage(pkgLocation, null); // Add a Connection Manager to the Package, of type, FLATFILE var connMgrFlatFile = package.Connections.Add("FLATFILE"); connMgrFlatFile.ConnectionString = strSourceConn; connMgrFlatFile.Name = "My Import File Connection"; connMgrFlatFile.Description = "Flat File Connection"; package.Execute();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)