Пример #1
0
        public static void Main(string[] args)
        {
            if (args.Length != TotalNumberOfArgs)
            {
                Console.WriteLine("I got " + args.Length + " arguments to this process. I need " + TotalNumberOfArgs);
                for (var i = 0; i < args.Length; i++)
                {
                    Console.WriteLine("Arg : " + i + " is : " + args[i]);
                }
                Console.WriteLine("Usage:");
                Console.WriteLine("GeneratorTool <importName> <generatedScriptPath> <sourceConnectionString> <destinationConnectionString> <stagingDatabaseConnectionString> <importSchemaName> <defaultImportRunId> <defaultSourceIds> <logFileDir>");
                return;
            }

            var importName                      = args[0];
            var generatedScriptPath             = args[1];
            var sourceConnectionString          = args[2];
            var destinationConnectionString     = args[3];
            var stagingDatabaseConnectionString = args[4];
            var importSchemaName                = args[5];
            var defaultImportRunId              = Convert.ToInt64(args[6]);
            var defaultSourceIds                = args[7];
            var logFileDir                      = args[8];

            Console.WriteLine("ctor for SsisPackageGenerator about to be called");

            var session = CreateSession(stagingDatabaseConnectionString);
            var importSchemaRepository = new ImportSchemaRepository(session, importName);
            var ssisPackageGenerator   = new SsisPackageGenerator(importSchemaRepository, importName, generatedScriptPath, sourceConnectionString,
                                                                  destinationConnectionString,
                                                                  stagingDatabaseConnectionString, importSchemaName,
                                                                  defaultImportRunId, defaultSourceIds, logFileDir);

            ssisPackageGenerator.GeneratePackage();
        }
Пример #2
0
 public SsisPackageGenerator(ImportSchemaRepository repository, string importName, string generatedScriptPath, string sourceConnectionString, string destinationConnectionString, string stagingDatabaseConnectionString, string importSchemaName, long defaultImportRunId, string defaultSourceIds, string logFileDir)
 {
     _repository                      = repository;
     _importName                      = importName;
     _generatedScriptPath             = generatedScriptPath;
     _sourceConnectionString          = sourceConnectionString;
     _destinationConnectionString     = destinationConnectionString;
     _stagingDatabaseConnectionString = stagingDatabaseConnectionString;
     _importSchemaName                = importSchemaName;
     _defaultImportRunId              = defaultImportRunId;
     _defaultSourceIds                = defaultSourceIds;
     _logFileDir                      = logFileDir;
 }
 public SsisPackageGenerator(ImportSchemaRepository repository,string importName, string generatedScriptPath, string sourceConnectionString, string destinationConnectionString, string stagingDatabaseConnectionString, string importSchemaName, long defaultImportRunId, string defaultSourceIds, string logFileDir)
 {
     _repository = repository;
     _importName = importName;
     _generatedScriptPath = generatedScriptPath;
     _sourceConnectionString = sourceConnectionString;
     _destinationConnectionString = destinationConnectionString;
     _stagingDatabaseConnectionString = stagingDatabaseConnectionString;
     _importSchemaName = importSchemaName;
     _defaultImportRunId = defaultImportRunId;
     _defaultSourceIds = defaultSourceIds;
     _logFileDir = logFileDir;
 }
        public static void Main(string[] args)
        {
            if (args.Length != TotalNumberOfArgs)
            {
                Console.WriteLine("I got " + args.Length + " arguments to this process. I need " + TotalNumberOfArgs);
                for (var i = 0; i < args.Length; i++)
                {
                    Console.WriteLine("Arg : " + i + " is : " + args[i]);
                }
                Console.WriteLine("Usage:");
                Console.WriteLine("GeneratorTool <importName> <generatedScriptPath> <sourceConnectionString> <destinationConnectionString> <stagingDatabaseConnectionString> <importSchemaName> <defaultImportRunId> <defaultSourceIds> <logFileDir>");
                return;
            }

            var importName = args[0];
            var generatedScriptPath = args[1];
            var sourceConnectionString = args[2];
            var destinationConnectionString = args[3];
            var stagingDatabaseConnectionString = args[4];
            var importSchemaName = args[5];
            var defaultImportRunId = Convert.ToInt64(args[6]);
            var defaultSourceIds = args[7];
            var logFileDir = args[8];
            Console.WriteLine("ctor for SsisPackageGenerator about to be called");

            var session = CreateSession(stagingDatabaseConnectionString);
            var importSchemaRepository = new ImportSchemaRepository(session,importName);
            var ssisPackageGenerator = new SsisPackageGenerator(importSchemaRepository,importName, generatedScriptPath, sourceConnectionString,
                                                                destinationConnectionString,
                                                                stagingDatabaseConnectionString, importSchemaName,
                                                                defaultImportRunId, defaultSourceIds, logFileDir);
            ssisPackageGenerator.GeneratePackage();
        }