dts error

[stacy]

I have a DTS package that I'm doing a data driven query in. When I try to run the package I'm getting General Error - 2147213210(80042066). Does anyone know what this error means. I even try creating a log with the package but it doesn't give me any more of a description of the error.

[Paul]

it could be many things, do u have any more specific info ?


------------
stacy at 3/2/01 2:34:01 PM

I have a DTS package that I'm doing a data driven query in. When I try to run the package I'm getting General Error - 2147213210(80042066). Does anyone know what this error means. I even try creating a log with the package but it doesn't give me any more of a description of the error.

[stacy]

What I'm trying to do is the following. I have a table on our AS/400 DSSRSLSHDR which I'm trying to bring over to the sql server and put it in a sql table called SalesHeaderRetail. So I have 2 connections set up one the SQL server connection and the other the AS/400 Connection. Then I have a Data Driven Query set up. Under the Source tab I have the AS400 File DSSRSLSHDR and under the Destination tab I have the SalesHeaderRetail Table from the SQL Server. Under the tranformations I have an Active X Script as follows:

Function Main()
If DTSDestination("StoreNumber&#34 =
DTSSource("DSRHSTR&#34 And _
DTSDestination("Controller&#34 =
DTSSource("DSRHCTL&#34 And _
DTSDestination("Register#&#34 =
DTSSource("DSRHREG&#34 And _
DTSDestination("Transaction#&#34 =
DTSSource("DSRHTR#&#34 And _
DTSDestination("TransactionDate&#34 =
cdate(DTSSource ("DSRHDATI&#34) & " " &
timevalue (DTSSource("DSRHTIME&#34) _
Then
DTSDestination("StoreNumber&#34 =
DTSSource("DSRHSTR&#34
DTSDestination("StoreIndex&#34 =
DTSSource ("DSRHSTX&#34
DTSDestination("Controller&#34 =
DTSSource("DSRHCTL&#34
DTSDestination("Register#&#34 =
DTSSource("DSRHREG&#34
DTSDestination("Transaction#&#34 =
DTSSource("DSRHTR#&#34
DTSDestination("Correction#&#34 =
DTSSource("DSRHC#&#34
DTSDestination("CompanyCode&#34 =
DTSSource("DSRHCMP&#34
DTSDestination("VoidCode&#34 =
DTSSource("DSRHVOID&#34
DTSDestination("RegisterType&#34 =
DTSSource("DSRHRTYP&#34
DTSDestination("TransactionType&#34 =
DTSSource("DSRHTT&#34
DTSDestination("TransactionDate&#34 =
cdate(DTSSource("DSRHDATI&#34) & " " &
timevalue(DTSSource("DSRHTIME&#34)
DTSDestination("SalesPersonId&#34 =
DTSSource("DSRHSPN&#34
ETC.....
Main = DTSTransformstat_UpdateQuery
Else
DTSDestination("StoreNumber&#34 =
DTSSource("DSRHSTR&#34
DTSDestination("StoreIndex&#34 =
DTSSource("DSRHSTX&#34
DTSDestination("Controller&#34 =
DTSSource("DSRHCTL&#34
DTSDestination("Register#&#34 =
DTSSource("DSRHREG&#34
DTSDestination("Transaction#&#34 =
DTSSource("DSRHTR#&#34
DTSDestination("Correction#&#34 =
DTSSource("DSRHC#&#34
DTSDestination("CompanyCode&#34 =
DTSSource("DSRHCMP&#34
DTSDestination("VoidCode&#34 =
DTSSource("DSRHVOID&#34
DTSDestination("RegisterType&#34 =
DTSSource("DSRHRTYP&#34
DTSDestination("TransactionType&#34 =
DTSSource("DSRHTT&#34
DTSDestination("TransactionDate&#34 =
cdate(DTSSource("DSRHDATI&#34) & " " &
timevalue(DTSSource("DSRHTIME&#34)
DTSDestination("SalesPersonId&#34 =
DTSSource("DSRHTIME&#34
ETC...........
Main = DTSTransformstat_InsertQuery
End If
End Function

Under the queries tab I have an insert and an update query set up as follows:
Insert Query
NSERT
INTO SalesHeaderRetail (StoreNumber, StoreIndex, Controller,
Register#, Transaction#, Correction#, CompanyCode, VoidCode,
RegisterType, TransactionType, TransactionDate, SalesPersonId,
OtherSalesPersonId, TotalMerchandise, TotalNonMerchandise, TotalTax,
TaxRate, TaxCode, GroupDiscount, OriginalStore, OrigianlRegister#,
OrigianlTransaction#, CorrectionDate, CorrectionUser, CorrectionReasonCode,
TendorCode, ReleasedToCredit, AssociateSSN#, AssociatePurchase,
CustomerReceipt, TeamPerformance#)
VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?,
?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

Update query
UPDATE SalesHeaderRetail SET StoreNumber =?, StoreIndex =?,
Controller =?, Register# =?, Transaction# =?, Correction# =?,
CompanyCode =?, VoidCode =?, RegisterType =?, TransactionType
=?, TransactionDate =?, SalesPersonId =?, OtherSalesPersonId
=?, TotalMerchandise =?, TotalNonMerchandise =?, TotalTax =?,
TaxRate =?, TaxCode =?, GroupDiscount =?, OriginalStore =?,
OrigianlRegister# =?, OrigianlTransaction# =?, CorrectionDate
=?, CorrectionUser =?, CorrectionReasonCode =?, TendorCode =?,
ReleasedToCredit =?, AssociateSSN# =?, AssociatePurchase =?,
CustomerReceipt =?, TeamPerformance# =?, RowInsertTimeStamp
=?, WeekEndingDate =?

I'm using sql server 7.0. Any ideas would be greatly appreciated. Thanks for you help in advance. I get the same error whether I run in through a scheduled job or run in directly in enterprise manager. My next attemp will to be to bring it into a temp table and then use SQL to update/insert but was hoping to do it in one step the way I have it set up now. So if you have any idea on what's wrong it would be greatly appreciated. Thanks. Stacy




------------
Paul at 3/3/01 9:11:59 AM

it could be many things, do u have any more specific info ?


------------
stacy at 3/2/01 2:34:01 PM

I have a DTS package that I'm doing a data driven query in. When I try to run the package I'm getting General Error - 2147213210(80042066). Does anyone know what this error means. I even try creating a log with the package but it doesn't give me any more of a description of the error.