Problem with DTS: SIMULTANEOUSLY process
I would like that my DTS launch SIMULTANEOUSLY two sessions of a terminal TEE3270 for downloading some files remotely. For this reason I have written two DTS, each of which uses username and pwd of two different users (retrieved from a table) and download files. Then, I made a third DTS tha contains two "Execute Package task" that launches the two above packages After all, despite I imposed two simultaneous processes, the two sessions are never contemporaneous, but always sequential. But if I run the DTS that are placed on the server by two different clients with Enterpraise Manager, the processes are contemporary. Thinking that it was a limitation of the emulator TEE3270, I made two scripts in .vbs that i have launched whit a third script using WShell.Run "" "path vbs Process 1" "" WShell.Run "" "path vbs process 2" "" and in that case the contemporaneity is guaranteed So I think that are the DTS (and also SSIS because i have tried with its) to have some limitations... Can anyone help me??
July 25th, 2012 7:03am

You could do that with one package that has two Data Flow Tasks, but not connected, besides running children packages it is possible, too, but again you need to not to connect the tasks and make the setting execute out of process, this I guess was your issue. By the way, when you run a package via the SQL Agent the packages execute concurrently - asynchronously, when in a batch file, too (unless you made a START /WAIT key applied).Arthur My Blog
Free Windows Admin Tool Kit Click here and download it now
July 30th, 2012 4:06pm

You could do that with one package that has two Data Flow Tasks, but not connected, besides running children packages it is possible, too, but again you need to not to connect the tasks and make the setting execute out of process, this I guess was your issue. By the way, when you run a package via the SQL Agent the packages execute concurrently - asynchronously, when in a batch file, too (unless you made a START /WAIT key applied).Arthur My Blog
July 30th, 2012 4:08pm

DTSxChange is a wonderful tool that Ive had the privilege of using while working on multiple DTS conversion projects. Not only does it make converting DTS packages to SSIS packages much, much easier, it also does the job in less than half of the time with very minimal manual labor. One of the great features of DTSxChange is the Profiler. The Profiler profiles the DTS packages in your environment and finds all the information about your DTS packages for scoping of projects and estimating not only cost but also time. I particularly found the Profiler report useful when calculating the amount of Active X in the DTS packages. The most powerful feature in DTSxChange however is the elaborate rules that youre able to set up during conversion. These best practice settings will allow you to select the rules that youre able to set up during conversion. These rules will be applied to each of the converted packages that are selected. These rules include Deployment Framework, Null handling, Auditing Framework and a number of other settings and rules. If you are in the midst of DTS conversion project or have a DTS migration on the horizon, DTSxChange is a must have! For more information go to www.pragmaticworks.com Convert DTS to SSIS | Document SSIS | 30+ SSIS Tasks | Real-time SSIS Monitoring | Quick Starts | BI Blitz
Free Windows Admin Tool Kit Click here and download it now
August 1st, 2012 12:50am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics