|
|||||||||
|
|||||||||
| |||||||||
|
|||||||||
|
|||||||||
| |||||||||
|
|
|
| |||||||||
 |
|
|
«
Previous Thread
|
Next Thread
»
|
Thread Tools | Search this Thread | Rate Thread | Display Modes |
Dev Shed Forums Sponsor:
|
|
1200+ fellow developers rate and compare features of the top IDEs, like Visual Studio, Eclipse, RAD, Delphi and others, across 13 categories. Enjoy this FREE Download of the IDE User Satisfaction Study by Evans Data Corporation. Download Now!
|
|
#1
April 14th, 2004, 02:14 PM
|
|||
|
|||
|
The SQL statement does not contain any parameters
Whenever I click on the paramters button in the "Transform Data Task Properties", I get the error, "The SQL statement does not contain any parameter"
SELECT I.vendor_id, I.currency, I.po_no, I.total, I.date_received, I.invoice_type, D.business_unit, D.obj_account, D.obj_account_sub, D.subledger_account, D.subledger_type, I.proc_id, I.business_unit AS Expr1, I.company_code, I.invoice_group, D.total AS Expr2, I.id, D.item_desc FROM ap_invoice I INNER JOIN ap_invoice_detail D ON I.proc_id = D.proc_id WHERE (I.invoice_group = 'INS') AND (I.laststatus = ' ') AND (I.status = 'P') AND (I.po_req = 'N') ORDER BY I.proc_id
|
|
#2
April 14th, 2004, 02:19 PM
|
|||
|
|||
|
destination tab
Whenever I click on the destination tab, I get an error saying: HResult of 0x800300fb (-2147286789)
Unexpected error occured. An error result was returned without an error message.
|
|
#3
April 14th, 2004, 02:28 PM
|
|||
|
|||
|
DTS Designer Error
Then I get a DTS Designer Error
No provider is selected. To continue, you must select a valid provider.
|
|
| Viewing: Dev Shed Forums > Databases > MS SQL Development > The SQL statement does not contain any parameters |
| Thread Tools | Search this Thread |
| Display Modes | Rate This Thread |
|
|
 |
|
|
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
