Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Hello I am attempting to run a test which contains the following code:

        string pkgLocation;
        Package pkg;
        Application app;
        DTSExecResult pkgResults;



        pkgLocation =
          @"C:\Users\mYCoMppp\Documents\Visual Studio 2012\Projects\packageOnExeCreatesTable" +
          @"\Integration Services Project8\Package.dtsx";
        app = new Application();
        pkg = app.LoadPackage(pkgLocation, null);
        pkgResults = pkg.Execute();

        Console.WriteLine(pkgResults.ToString());
        Console.ReadKey();

This is an attempt to populate a table which has had all of its records removed thanks to the test I ran before it. I am not getting any errors - however it does take a while to complete the test. I do not know exactly how long it takes, because the test is running as I type this.

So alas, my question. I would like to know if anybody out there can explain to me if this is a time consuming way of executing a package. And also if anybody knows of any other way to execute SSIS packages faster.

share|improve this question
    
I answer the SSIS questions over here too ;) stackoverflow.com/questions/19298938/… –  billinkc Oct 10 '13 at 16:18
    
thats fine and dandy. I havent found a solution yet. and its still literally trying to finish.. but i really dont think it will.. –  Sir Knows A Bit Oct 10 '13 at 16:21

1 Answer 1

First thing write another package that does a simple file copy task for example and see if that takes a long time using your same call method. If it does then perhaps your call method could be improved. I suspect it will be quick and the package code is where the problem is, not how its called.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.