Database Reference
In-Depth Information
using System.IO;
class Program
{
const string ProjectFileLocation
= @"C:\ETL\Project.ispac";
static void Main(string[] args)
{
// Connect to the default instance on localhost
var server = new Server("localhost");
var store = new IntegrationServices(server);
// Check that we have a catalog
if (store.Catalogs.Count == 0)
{
Console.WriteLine("SSIS catalog not found on
localhost.");
}
// Get the SSISDB catalog - note that there
should only
// be one, but the API may support multiple
catalogs
// in the future
var catalog = store.Catalogs["SSISDB"];
// Create a new folder
var folder = new CatalogFolder(catalog,
"MyFolder",
"Folder that holds
projects");
folder.Create();
// Make sure the project file exists
if (!File.Exists(ProjectFileLocation))
{
Console.WriteLine("Project file not found at:
Search WWH ::




Custom Search