Passing parameters to Oracle - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2000 Forums

Import/Export (DTS) and Replication (2000)

Passing parameters to Oracle

Author

Topic

CtrlAltDel
Starting Member

17 Posts

Posted - 2004-06-09 : 05:46:28

I'm trying to write a DTS script to transfer records from an Oracle database to SQL Server, using the Oracle OLEDB drivers. If I copy the whole table, then I have no problems. But if I try to parameterise the transfer, to only pick up records which have a certain value, then I get an 80040E51 error, and Google has been non-to-forthcoming about it. The query that fails is


SELECT
	PERIODNO, ACCNO, ANALCODE1, ANALCODE2, COST_CODE_TYPE, 
	COST_CODE, CREATED_DATE, STATUS, THIRD_PARTY_FLAG, NET_INV_VAL, 
	VAT, GROSS_INV_VAL, LOCATION, MANAGER, PLACEMENT_TYPE, PLACEMENTS
FROM
	OLMI_FIN_PERM
WHERE 
	PERIODNO > ?

so nothing too sophisticated, and as I said, it works fine if you comment out the where clause. It's just when I try to assign the parameter, by clicking on the Parameters button in the Transform Data Task Properties window, that it all goes Pete Tong.

--
David Keaveny

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources