OLEDB Error Failed on SP

[#1]

    In my script I am executing a sp but on the reload I am getting the error OLEDB Error Failed SP_Name

Any help please?

[maxgro]

please could you post your script and your error?

[#3]

My script for the SQL is

Cost:

Load Class, ][Financial Period] AS FinancialPeriod  ;

sql execute CostQlikView

The script has a OLEDB connection has the script includes connection to a SQL Server db and has other load statements to tables.

[maxgro]

try

Cost:

Load *;

sql execute CostQlikView;

you have a ]

[#5]

thats worked.  Why would that be?  Does that mean that in the SP i should rename the fields that have [a and b  ] should be made into a single field as aandb

[maxgro]

yes you can rename field

but you have an error or two

]

;

Cost:

Load Class, ][Financial Period] AS FinancialPeriod  ;

sql execute CostQlikView;

for example this works on my sql server

T:

load id_banca, [cod_banca] as newfield;

sql execute sisim_stat..sp_test '%BANCA%';

[#7]

This what i have when it fails

Cost:

Load [P&L Classification] ,[Point] AS POD ;

sql execute C_CostQlikView;

[maxgro]

perhaps you have a wrong field name

this works for me

qlikview script is

T:

load [P&L Classification], [Point] AS POD;

sql execute sisim_stat..sp_test2;

sql server procedure is

alter PROCEDURE [dbo].[sp_test2]

AS

BEGIN

  SET NOCOUNT ON;

  SELECT id_banca [P&L Classification], cod_banca [Point] from d001_banche; -

END

RESULT is