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

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 (AT) discussions (DOT) microsoft.com> wrote

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--------


Thanks in Advance,
Rajesh

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 (AT) discussions (DOT) microsoft.com> wrote

Allen,

1. I am pulling two different files into two different
tables. Its completely Separate.

2. Yeah.. I know that I can use Bulk Insert and as far
as I remember one of the article specify it gives the same
performance for uploading the data using bcp/Bulkinsert.

When I use the Bulk Insert--
Permissions denied error is given as follows.

EXECUTE permission denied on object 'xp_availablemedia',
database 'master', owner 'dbo'.

Just I am doing it as my personal Insert and Its not
related to my work to improve one of the Job which exists
in perl so I cannot ask permission on master database.

Thanks & Regards
Venkata.

I always use BULK INSERT for inserts of text files
If I want to export then I either use the BULK Export task on the sqldts
website or I use bcp

You need to be a BULKADMIN or SYSADMIN to execute BULK INSERT

It is part of SQL Server so therefore not external.



--

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 (AT) discussions (DOT) microsoft.com> wrote