Hi Russel,

Thanks very much for your help. I do not want to add identity column into those tables because there are so many of them. It will take too much...

Hi Girish,

Yes, order of data is changing; not all but for some of the data inside the tables.. There are no indexes at the tables I import those files.

Thanks.

Regards,

Sahin.

Hi,

Instead of wrapping it into .bat file, did you try running abc.exe through Execute Process task with the Arguments that you will assign through variables?

Regards,

Sahin.

Hi,

You can use Execute Process Task in order to run a zipping program, like winzip, on the server.

Just write the full path of the program into Executable line and Arguments...

Hi,

I faced a similar problem and could not solve the authentication issue, but found an alternative way like creating a batch file running the SSIS package and schedule that batch...

Thank you Wildh. I will try that option also.

Regards,

Sahin.

Thank you very much Michael. I tested it; it is perfectly running. 🙂

Thank you Michael.

I need to use such a process to automatically start my SSIS part after a certain program (that I cannot have any interject on it) finishes its...

Thank you Jeff.

But my question is how I can run that query in every 1 minute repeatedly in SSIS until I see that value is updated, and allow SSIS...

Thank you very much for your comments and guidance for the solution.

I am informed by the contractor company hosting the server about that the standard Microsoft patches ( for SP1...