hi and thanks for you answers.

i have the following columns in a flat file, which is not normalised, more an olap structure :

TIME PERIOD PRODUCT ...

i solved it by adding adLockOptimistic to the Open statement

jim

thanks for the script !

i found the answer in the books online : i need to be a sysadmin to create tables with dbo.

thanks

thanks !

problem solved :

the server wasn't started for local server !

Hi

I use windows authentication

I am trying to connect by using the registration wizard

i can't see the sql server icon in systray and in windows services, i only see MSSQLServerOlapService

Hi

Exactly, I import a file into a table, do some modifications then export it. So I figured when the table is exported it is considered as a new file....

thanks for replying

i used the wizard to create the package. I don't know what a global variable is.

do you mean Books Online ?

only a trail but a happy trail !

thanks for your help

i finally figured it out :

CREATE PROCEDURE myproc AS

SELECT     F.PERIOD, F.PROD, F.REP, DERIVEDTBL.TOTAL_VALUES, MKTSHARE = case when  derivedtbl.total_values > 0 then  F.VALUES / DERIVEDTBL.TOTAL_VALUES else 0 end,

                      categ = CASE...

thanks for your suggestion :

I receive an error :   view definition includes no output columns or includes no items in the from clause

do you know what it means ?

thanks