"Venkata" <anonymous@discussions.microsoft.com> wrote in message
news:608701c3e5ed$b8603af0$a001280a@phx.gbl...
> I had created a package with
>
> Two Execute Process Tasks (Each execute Process task bcps
> the data into separate table)
> One Activex script Task.
>
> Overall the Package Behaviour is
> Whenever the Activex Script Task is sucessful automatically
> Two Execute Process Tasks should run in Parallel
> (i.e., A Single Process should Run Should the two threads)
>
> I am not able to sucessfully run the two processes tasks
> in parallel Behaviour is as one of the Execute Proces is
> errored out
>
> So How can I Run two execute process tasks in parallel
>
> Please any of you throw some Light.
>
> Thanks in Advance.
> Have a Nice Day.
>
> Regards
> Venkata
>

>-----Original Message-----
>Are you trying to pull the same file into two different
tables?
>Have you look at the Bulk Insert task? This is internal
to SQL Server
>whereas bcp is an external executable
>
>--
>
>Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>www.allisonmitchell.com - Expert SQL Server Consultancy.
>www.SQLDTS.com - The site for all your DTS needs.
>I support PASS - the definitive, global community
>for SQL Server professionals - http://www.sqlpass.org
>
>
><anonymous@discussions.microsoft.com> wrote in message
>news:5d5f01c3e5f9$67fa4c20$a101280a@phx.gbl...
>> Allan
>>
>> Thanks for ur quick Reponse
>>
>> The following is the Error that I got in the
>> Errorhanding file (Package Properties).
>>
>> The execution of the following DTS Package failed:
>>
>> Error Source: Microsoft Data Transformation Services
(DTS)
>> Package
>> Error Description:Package failed because
>> Step 'DTSStep_DTSCreateProcessTask_2' failed.
>> Error code: 80040428
>> \Error Help File:sqldts80.hlp
>> Error Help Context ID:700
>>
>>
>> Package Name: bcp1
>> Package Description: (null)
>> Package ID: {F02831E7-F00B-458B-AE93-BE677BC342B3}
>> Package Version: {0F7C0D73-A87E-4FB4-861C-5408EFA751EF}
>> Package Execution Lineage: {F328DBC8-A394-4EE9-81A3-
>> 0983C05AC1C6}
>> Executed On: CLDG2159421
>> Executed By: #vpeddir
>> Execution Started: 1/28/2004 3:38:19 PM
>> Execution Completed: 1/28/2004 3:42:00 PM
>> Total Execution Time: 220.578 seconds
>>
>> Package Steps execution information:
>>
>>
>> Step 'DTSStep_DTSCreateProcessTask_1' succeeded
>> Step Execution Started: 1/28/2004 3:38:19 PM
>> Step Execution Completed: 1/28/2004 3:42:00 PM
>> Total Step Execution Time: 220.563 seconds
>> Progress count in Step: 0
>>
>> Step 'DTSStep_DTSActiveScriptTask_1' succeeded
>> Step Execution Started: 1/28/2004 3:38:19 PM
>> Step Execution Completed: 1/28/2004 3:38:19 PM
>> Total Step Execution Time: 0.015 seconds
>> Progress count in Step: 0
>>
>> Step 'DTSStep_DTSCreateProcessTask_2' failed
>>
>> Step Error Source: Microsoft Data Transformation
Services
>> (DTS) Package
>> Step Error
>>
Description:CreateProcessTask 'DTSTask_DTSCreateProcessTask
>> _2': Process returned code 1, which does not match the
>> specified SuccessReturnCode of 0.
>> Step Error code: 80040496
>> Step Error Help File:sqldts80.hlp
>> Step Error Help Context ID:1100
>>
>> Step Execution Started: 1/28/2004 3:38:19 PM
>> Step Execution Completed: 1/28/2004 3:38:20 PM
>> Total Step Execution Time: 0.609 seconds
>> Progress count in Step: 0
>>
>>
>>
__________________________________________________________
>>
>> Altogether my Package looks like following in the DTS
>> desinger.
>>
>> execute process 1--------
>> |-----sucess-- Activex script
>> |
>> execute proceess 2-------
>>
>>
>> Thanks in Advance,
>> Rajesh
>>
>> >-----Original Message-----
>> >Errors with what ?
>> >
>> >--
>> >--
>> >
>> >Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
>> >www.allisonmitchell.com - Expert SQL Server
Consultancy.
>> >www.SQLDTS.com - The site for all your DTS needs.
>> >I support PASS - the definitive, global community
>> >for SQL Server professionals - http://www.sqlpass.org
>> >
>> >
>> >"Venkata" <anonymous@discussions.microsoft.com> wrote
in
>> message
>> >news:608701c3e5ed$b8603af0$a001280a@phx.gbl...
>> >> I had created a package with
>> >>
>> >> Two Execute Process Tasks (Each execute Process task
>> bcps
>> >> the data into separate table)
>> >> One Activex script Task.
>> >>
>> >> Overall the Package Behaviour is
>> >> Whenever the Activex Script Task is sucessful
>> automatically
>> >> Two Execute Process Tasks should run in Parallel
>> >> (i.e., A Single Process should Run Should the two
>> threads)
>> >>
>> >> I am not able to sucessfully run the two processes
tasks
>> >> in parallel Behaviour is as one of the Execute
Proces is
>> >> errored out
>> >>
>> >> So How can I Run two execute process tasks in
parallel
>> >>
>> >> Please any of you throw some Light.
>> >>
>> >> Thanks in Advance.
>> >> Have a Nice Day.
>> >>
>> >> Regards
>> >> Venkata
>> >>
>> >
>> >
>> >.
>> >
>
>
>.