예제 #1
0
파일: Program.cs 프로젝트: textmetal/main
		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);
		}
예제 #2
0
파일: Program.cs 프로젝트: textmetal/main
		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;
		}
예제 #3
0
파일: Program.cs 프로젝트: textmetal/main
		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;
		}
예제 #4
0
파일: Program.cs 프로젝트: textmetal/main
		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;
		}
예제 #5
0
파일: Program.cs 프로젝트: textmetal/main
		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;
		}