Ejemplo n.º 1
0
		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);
		}
Ejemplo n.º 2
0
		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;
		}
Ejemplo n.º 3
0
		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;
		}
Ejemplo n.º 4
0
		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;
		}
Ejemplo n.º 5
0
		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;
		}