I am trying to run SQL Server 2000 DTS Package from SQL Server 2005 Legacy
Data Transformation Services. This package transfers data from Lotus Notes to
SQL Server 2005 using Data Driven Query Task. I am able to create a new table
but data is not getting transferred. On running the DTS Package i get the
following error.
Error Source: Microsoft Data Transformation Services (DTS) Package
Error Description:Package failed because Step
'DTSStep_DTSDataDrivenQueryTask_1' failed.
Error code: 80040428
\Error Help File:sqldts80.hlp
Error Help Context ID:700


Package Name: New Package
Package Description: (null)
Package ID: {B46213E8-97E8-4C6D-8254-052516D594BE}
Package Version: {5B535F79-892D-4A76-930D-F0B9AA73E4A5}
Package Execution Lineage: {33B9D720-9A70-4D76-A992-A2DD921D3D17}
Execution Started: 5/12/2006 1:56:16 PM
Execution Completed: 5/12/2006 1:56:19 PM
Total Execution Time: 3.063 seconds

Package Steps execution information:


Step 'DTSStep_DTSDataDrivenQueryTask_1' failed

Step Error Source: Microsoft Data Transformation Services (DTS) Data Pump
Step Error Description:ActiveX Scripting Transform requires script Text and
Language and at least one Phase function to be specified.
Step Error code: 80042040
Step Error Help File:sqldts80.hlp
Step Error Help Context ID:0

Step Execution Started: 5/12/2006 1:56:16 PM
Step Execution Completed: 5/12/2006 1:56:19 PM
Total Step Execution Time: 2.875 seconds
Progress count in Step: 0

Can anyone help me in knowing what's the issue in using this method of
transformation.

Hello vilas,

Whilst I have not tried this and I cannot see your package the error suggests
that the step 'DTSStep_DTSDataDrivenQueryTask_1' is empty.

I cannot say whether this is as a result of 2K5 executing the package or not.


How exactly are you executing it?


Allan

i Allan,

I have installed DTS Component Designer 2000 on SQL Server 2005. From the
Management>legacy, i created a DTS package with source connection to Lotus
Notes and destination to SQL Server 2005 table. I added a data driven query
task for connecting them.

I am executing this task from both the places. One from DTS Component
Designer and second from SSIS Designer wherein i have created a execute DTD
2000 package. From both the places same error is shown.
Any help on this will be highly appreciated.

Regards,
Vilas


"Allan Mitchell" wrote:

Hello vilas,

OK so if this fails when you use the package in an Execute DTS 2000 Package
task then there is something with the package. Can you make sure that everything
that should be available to the package is available. Lotus Notes Drivers
for instance.


Allan Mitchell
www.SQLDTS.com
www.SQLIS.com
www.Konesans.com

Management>> Lotus
Management>>

Hi Allan,

Lotus SQL Driver works fine. I am able to import data from Lotus Notes
Database to SQL Server 2000. But this doesn't work in SQL 2005. That's why i
created a package in SQL 2000 and trying to call it in SQL 2005'S Legacy Data
Transformation Services. I am able to create a new table using this DTS
package but cannot migrate the data in SQL 2005 database. I tried to run the
package using SQL 2000 dts and also with Execute SQL Server 2000 DTS task but
same error.





"Allan Mitchell" wrote: