Database Reference
In-Depth Information
sb.AppendLine("Set @ExecutionOrder = " + e.ToString());
sb.AppendLine("If Not Exists(Select PackageFolder
+ PackageName");
sb.AppendLine("
From cfg.Packages");
sb.AppendLine("
Where PackageFolder
= @PackageFolder");
sb.AppendLine("
And PackageName
= @PackageName)");
sb.AppendLine(" begin");
sb.AppendLine(" print 'Adding ' + @PackageFolder
+ @PackageName");
sb.AppendLine(" exec cfg.AddSSISPackage @PackageName,
@PackageFolder, @PackageID output");
sb.AppendLine(" end");
sb.AppendLine("Else");
sb.AppendLine(" begin");
sb.AppendLine(" Select @PackageID = PackageID");
sb.AppendLine(" From cfg.Packages");
sb.AppendLine(" Where PackageFolder = @PackageFolder");
sb.AppendLine(" And PackageName = @PackageName");
sb.AppendLine(" print @PackageFolder + @PackageName + '
already exists in the Framework.'");
sb.AppendLine(" end");
sb.AppendLine();
sb.AppendLine("
If Not Exists(Select
AppPackageID");
sb.AppendLine("
From cfg.AppPackages");
sb.AppendLine("
Where ApplicationID
= @ApplicationID");
sb.AppendLine("
And PackageID
= @PackageID");
sb.AppendLine("
And ExecutionOrder
= @ExecutionOrder)");
sb.AppendLine(" begin");
sb.AppendLine(" print 'Adding ' + @ApplicationName + '.'
+ @PackageName + ' to Framework with ExecutionOrder '
+ convert(varchar, @ExecutionOrder)");
sb.AppendLine(" exec cfg.AddSSISAppPackage
Search WWH ::




Custom Search