• Not sure if it is related to the command line anymore, but this is what I get

    Calling ParseSsisPackage with the parameters:

    System.String ssis_filename = C:\ssis\pckg2.dtsx

    System.String output_folder = C:\ssis csharp_dessist.SqlCompatibilityType SqlMode = System.Reflection.Missing

    Boolean UseSqlSMO = System.Reflection.Missing

    6/27/2013 2:34:36 PM STDOUT Exception: System.Reflection.TargetInvocationException: Exception has been thrown by the target of an invocation. ---> System.NullReferenceException: Object reference not set to an instance of an object.

    at csharp_dessist.Program.WriteProgram(IEnumerable`1 variables, IEnumerable`1 functions, String filename, String appname)

    at csharp_dessist.Program.ProduceSsisDotNetPackage(String projectname, SsisObject o, String output_folder)

    at csharp_dessist.Program.ParseSsisPackage(String ssis_filename, String output_folder, SqlCompatibilityType SqlMode, Boolean UseSqlSMO)

    --- End of inner exception stack trace ---

    at System.RuntimeMethodHandle._InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, SignatureStruct& sig, MethodAttributes methodAttributes, RuntimeType typeOwner)

    at System.RuntimeMethodHandle.InvokeMethodFast(IRuntimeMethodInfo method, Object target, Object[] arguments, Signature sig, MethodAttributes methodAttributes, RuntimeType typeOwner)

    at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture, Boolean skipVisibilityChecks)

    at System.Reflection.RuntimeMethodInfo.Invoke(Object obj, BindingFlags invokeAttr, Binder binder, Object[] parameters, CultureInfo culture)

    at System.Reflection.MethodBase.Invoke(Object obj, Object[] parameters)

    at CommandWrapLib.ExecuteMethod(MethodInfo mi, Object[] parameters, Form f)

    Should the dtsx package be of specific version? I tried 2012 and 2008 packages... one package selects one table (as built by the sql server) and one package does a simple statement for one column for one table.

    Should have I built the packages using visual studio and not rely on the SQL server built one? How did you test it on your end?