コード例 #1
0
        private static string ScriptSetParameterValue(this PackageInfo @this, PackageInfo.ExecutionValueParameterSet parameterSet, int counter)
        {
            StringBuilder stringBuilder = new StringBuilder();
            Type          type          = parameterSet.ParameterValue.GetType();
            TypeCode      typeCode      = Type.GetTypeCode(type);
            string        arg           = Helpers.TypeCodeToSqlTypeString(typeCode);

            stringBuilder.AppendFormat("DECLARE @var{0} {1} = {2}\n", counter, arg, Helpers.FormatSqlVariant(parameterSet.ParameterValue));
            SfcTsqlProcFormatter sfcTsqlProcFormatter = new SfcTsqlProcFormatter();

            sfcTsqlProcFormatter.Procedure = string.Format(CultureInfo.InvariantCulture, "[{0}].[catalog].[set_execution_parameter_value] @execution_id, ", new object[]
            {
                @this.Parent.Parent.Parent.Name
            });

            List <SfcTsqlProcFormatter.RuntimeArg> list = new List <SfcTsqlProcFormatter.RuntimeArg>();

            SfcTsqlProcFormatter.RuntimeArg item = new SfcTsqlProcFormatter.RuntimeArg(typeof(short), parameterSet.ObjectType);
            list.Add(item);
            sfcTsqlProcFormatter.Arguments.Add(new SfcTsqlProcFormatter.SprocArg("object_type", true));
            item = new SfcTsqlProcFormatter.RuntimeArg(typeof(string), parameterSet.ParameterName);
            list.Add(item);
            sfcTsqlProcFormatter.Arguments.Add(new SfcTsqlProcFormatter.SprocArg("parameter_name", true));
            item = new SfcTsqlProcFormatter.RuntimeArg(typeof(object), "@var" + counter.ToString(CultureInfo.InvariantCulture));
            list.Add(item);
            sfcTsqlProcFormatter.Arguments.Add(new SfcTsqlProcFormatter.SprocArg("parameter_value", true));
            stringBuilder.Append(sfcTsqlProcFormatter.GenerateScript(@this, list));
            return(stringBuilder.ToString());
        }
コード例 #2
0
        private static string ScriptCreateExecution(this PackageInfo @this, bool use32RuntimeOn64, EnvironmentReference reference)
        {
            if (use32RuntimeOn64)
            {
                string platform = Helpers.GetPlatform(@this.GetDomain() as IntegrationServices);
                if (platform != null && !platform.Contains("64"))
                {
                    throw new InvalidArgumentException($"Use32RuntimeOn64_Not64: {use32RuntimeOn64}");
                }
            }

            SfcTsqlProcFormatter sfcTsqlProcFormatter = new SfcTsqlProcFormatter();

            sfcTsqlProcFormatter.Procedure = string.Format(CultureInfo.InvariantCulture, "[{0}].[catalog].[create_execution]", new object[]
            {
                Helpers.GetEscapedName(@this.Parent.Parent.Parent.Name)
            });

            sfcTsqlProcFormatter.Arguments.Add(new SfcTsqlProcFormatter.SprocArg("package_name", "Name", true, false));
            List <SfcTsqlProcFormatter.RuntimeArg> list = new List <SfcTsqlProcFormatter.RuntimeArg>();
            long num = 0L;

            SfcTsqlProcFormatter.RuntimeArg item = new SfcTsqlProcFormatter.RuntimeArg(typeof(long), num);
            list.Add(item);
            sfcTsqlProcFormatter.Arguments.Add(new SfcTsqlProcFormatter.SprocArg("execution_id", true, true));
            item = new SfcTsqlProcFormatter.RuntimeArg(typeof(string), @this.Parent.Parent.Name);
            list.Add(item);
            sfcTsqlProcFormatter.Arguments.Add(new SfcTsqlProcFormatter.SprocArg("folder_name", true));
            item = new SfcTsqlProcFormatter.RuntimeArg(typeof(string), @this.Parent.Name);
            list.Add(item);
            sfcTsqlProcFormatter.Arguments.Add(new SfcTsqlProcFormatter.SprocArg("project_name", true));
            item = new SfcTsqlProcFormatter.RuntimeArg(typeof(bool), use32RuntimeOn64);
            list.Add(item);
            sfcTsqlProcFormatter.Arguments.Add(new SfcTsqlProcFormatter.SprocArg("use32bitruntime", true));
            SqlInt64 sqlInt = (reference != null) ? reference.ReferenceId : SqlInt64.Null;

            item = new SfcTsqlProcFormatter.RuntimeArg(typeof(SqlInt64), sqlInt);
            list.Add(item);
            sfcTsqlProcFormatter.Arguments.Add(new SfcTsqlProcFormatter.SprocArg("reference_id", true));
            Version serverVersion = ((IntegrationServices)@this.GetDomain()).Connection.ServerVersion;

            if (serverVersion.Major >= 14)
            {
                if (serverVersion >= new Version(14, 0, 700))
                {
                    item = new SfcTsqlProcFormatter.RuntimeArg(typeof(bool), false);
                    list.Add(item);
                    sfcTsqlProcFormatter.Arguments.Add(new SfcTsqlProcFormatter.SprocArg("runinscaleout", true));
                }
                else
                {
                    item = new SfcTsqlProcFormatter.RuntimeArg(typeof(bool), false);
                    list.Add(item);
                    sfcTsqlProcFormatter.Arguments.Add(new SfcTsqlProcFormatter.SprocArg("runincluster", true));
                }
            }

            return(sfcTsqlProcFormatter.GenerateScript(@this, list));
        }