private static void WritePackageApplication(string baseDirectoryPath, FourPartName fourPartName, Package package) { Application application; IDTSEvents dtsEvents; if ((object)package == null) throw new ArgumentNullException(nameof(package)); if ((object)fourPartName == null) throw new ArgumentNullException(nameof(fourPartName)); dtsEvents = new ConsoleEvents(); application = new Application(); application.SaveToXml(Path.Combine(baseDirectoryPath, GetSsisObjectPackageName(fourPartName)), package, dtsEvents); }
private static string GetTruncateTableCommandText(bool? useTruncate, FourPartName fourPartName) { string value; if ((object)fourPartName == null) throw new ArgumentNullException(nameof(fourPartName)); if ((object)useTruncate == null) value = string.Format(NOP_TABLE_COMMAND_TEXT_FORMAT, fourPartName.ToString(false)); else if ((bool)useTruncate) value = string.Format(TRUNCATE_TABLE_COMMAND_TEXT_FORMAT, fourPartName.ToString(false)); else value = string.Format(DELETE_FROM_TABLE_COMMAND_TEXT_FORMAT, fourPartName.ToString(false)); return value; }
private static string GetSsisObjectTypePackageName(FourPartName fourPartName) { string value; if ((object)fourPartName == null) throw new ArgumentNullException(nameof(fourPartName)); value = string.Format(SSIS_OBJECT_TYPE_PACKAGE_FILE_NAME_FORMAT, StandardCanonicalNaming.Instance.GetPascalCase(fourPartName.ServerName), StandardCanonicalNaming.Instance.GetPascalCase(fourPartName.DatabaseName), StandardCanonicalNaming.Instance.GetPascalCase(fourPartName.SchemaName), StandardCanonicalNaming.Instance.GetPascalCase(fourPartName.ObjectType.ToString())); return value; }
private static string GetSsisServerPackageName(FourPartName fourPartName) { string value; if ((object)fourPartName == null) throw new ArgumentNullException(nameof(fourPartName)); value = string.Format(SSIS_SERVER_PACKAGE_FILE_NAME_FORMAT, StandardCanonicalNaming.Instance.GetPascalCase(fourPartName.ServerName)); return value; }
private static string GetSourceConnectionString(FourPartName fourPartName) { string value; if ((object)fourPartName == null) throw new ArgumentNullException(nameof(fourPartName)); value = string.Format(CONNECTION_STRING_FORMAT, fourPartName.ServerName, fourPartName.DatabaseName); return value; }