Re: DTS Prediction Task ERROR

Tech-Archive recommends: Fix windows errors by optimizing your registry

You're correct in that the error is misleading. Unfortunately, I can't see
anything obviously wrong in this query. The first thing I would try is to
remove the quotes in the embedded query - since you don't have any spaces,
etc, they are superfluous. Beyond that, I think it's divide and conquer
time - remove elements until you see what went wrong.

One thing to try is to execute a singleton query like below to seperate
possible OPENROWSET issues from the rest of the query. You can use DMSample
to execute/test your queries.

SELECT FLATTENED
[T1].[Userid], [T1].[Genere], [T1].[Provenienza], [T1].[Esperienza],
[T1].[Età], [T1].[Qualifica], [T1].[Studi], [T1].[Mansione],
[DM_KPI_DT_CLEAN_DESKTOP].[Clean Desk Policy]
FROM
[DM_KPI_DT_CLEAN_DESKTOP]
PREDICTION JOIN
( SELECT 1 AS 'Userid', 'myGenere' as Genere, 'myProvenienza' as
'Provenienza',
'myEsperienza' as 'Esperienza', 25 AS 'Età', 'Qualifica' asn 'Qualifica',
'MyStudi' as 'Studi', 'MyMansione' as 'Mansione'
)
AS [T1]
ON
[DM_KPI_DT_CLEAN_DESKTOP].[Userid] = [T1].[Userid] AND
[DM_KPI_DT_CLEAN_DESKTOP].[Genere] = [T1].[Genere] AND
[DM_KPI_DT_CLEAN_DESKTOP].[Provenienza] = [T1].[Provenienza] AND
[DM_KPI_DT_CLEAN_DESKTOP].[Esperienza] = [T1].[Esperienza] AND
[DM_KPI_DT_CLEAN_DESKTOP].[Età] = [T1].[Età] AND
[DM_KPI_DT_CLEAN_DESKTOP].[Qualifica] = [T1].[Qualifica] AND
[DM_KPI_DT_CLEAN_DESKTOP].[Studi] = [T1].[Studi] AND
[DM_KPI_DT_CLEAN_DESKTOP].[Mansione] = [T1].[Mansione]

--

-Jamie MacLennan
SQL Server Data Mining
This posting is provided "AS IS" with no warranties, and confers no rights.
"Sergio" <Sergio@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:3BEAE0C7-0154-4FE2-8380-086DCB7DC300@xxxxxxxxxxxxxxxx
>I am tryng to create a DTS Task for prediction against a DM model based on
> Decision Trees.
>
> I worked with the wizard, that creates the following statement:
>
> SELECT FLATTENED
> [T1].[Userid], [T1].[Genere], [T1].[Provenienza], [T1].[Esperienza],
> [T1].[Età], [T1].[Qualifica], [T1].[Studi], [T1].[Mansione],
> [DM_KPI_DT_CLEAN_DESKTOP].[Clean Desk Policy]
> FROM
> [DM_KPI_DT_CLEAN_DESKTOP]
> PREDICTION JOIN
> OPENROWSET
> (
> 'SQLOLEDB.1',
> 'Provider=SQLOLEDB.1;Integrated Security=SSPI;Persist Security
> Info=False;Initial Catalog=Pirelli;Data Source=SHARKY',
> 'SELECT "userid" AS "Userid", "Genere", "Provenienza",
> "Esperienza", "Age" AS "Età", "Qualifica", "Studi", "Mansione" FROM
> "Esclusi"
> ORDER BY "userid"'
> )
> AS [T1]
> ON
> [DM_KPI_DT_CLEAN_DESKTOP].[Userid] = [T1].[Userid] AND
> [DM_KPI_DT_CLEAN_DESKTOP].[Genere] = [T1].[Genere] AND
> [DM_KPI_DT_CLEAN_DESKTOP].[Provenienza] = [T1].[Provenienza] AND
> [DM_KPI_DT_CLEAN_DESKTOP].[Esperienza] = [T1].[Esperienza] AND
> [DM_KPI_DT_CLEAN_DESKTOP].[Età] = [T1].[Età] AND
> [DM_KPI_DT_CLEAN_DESKTOP].[Qualifica] = [T1].[Qualifica] AND
> [DM_KPI_DT_CLEAN_DESKTOP].[Studi] = [T1].[Studi] AND
> [DM_KPI_DT_CLEAN_DESKTOP].[Mansione] = [T1].[Mansione]
>
> Unfortunately, any time I try to run the task, I receive an error message
> about a SYNTAX ERROR near '('.
>
> Is there someone that could please help me?
>
> I am not able to run any example on it, also from the sample DMX Query
> Tool
> both against the FoodMart DM.


.

Relevant Pages

  • Re: Finally which ORM tool?
    ... manipulate the linq query IF you're executing it at that moment. ... simply because the declaration construction was with 'CHOPS'. ... implement IEnumerablebut had an Execute() method which gave back ...
    (microsoft.public.dotnet.languages.csharp)
  • RE: SQL stored procedure executing twice
    ... I wasn't aware that DLookupwould execute the "domain" more than once. ... caused the stored procedure to execute twice. ... Dim stDocName As String ... My pass-thru query properties ...
    (microsoft.public.access.modulesdaovba)
  • Re: Clarification on DBI module
    ... You get the same results for the second execute because the record buffer in the statment handle is not cleaned out because no execute took place. ... The sql query can have bind variables or they may not have. ... Ahhh...imagining that irresistible "new car" smell? ...
    (perl.dbi.users)
  • RE: Running action function from SELECT query
    ... Yes ADO can execute queries saved in an Access database. ... I do not know how ADO.NET works, but the developer tells me he is able to ... At any rate, I can call just a function from a query, like this: ...
    (microsoft.public.access.modulesdaovba)
  • Re: UPDATE query in Access 2003 raising error
    ... Runtime error 3066 Query must have at least one destination field. ... The SQL works fine if I use it in the QBF Design mode. ... Set qdfTemp = db.CreateQueryDef ... Elsewhere in the code I use the same technique to execute an SQL ...
    (microsoft.public.access.formscoding)