Thank you very much for your help!

You've just helped me understand a little bit more on SQL srv.

[]

--

Bruno

THX for the link!

I had already checked it out....

I was just looking for an article with stuff to watch out for!

THX anyway again!

THX!

Has I suspected I've just stumbled on yet another error on the execution of the DTS.

Here's the problem:

Insert error: Column name or number of supplied values does not match table...

THX for your help!

I've just seen your post, and it was exactly what I did prior to viewing your post!

The object reference on the view was "conso.conso.clients", and I changed...

I'm specifying the owner of the obbjects, still...it pops up the same error!

Are you saying I should classify all views and tables with the specific owners?

Should this be done with the syntax:

"owner.object"

btw, should the correct syntax be:

"db.owner.object"

on all objects?

--

THX!

This is the SQL Statement the task on the DTS executes:

execute dm_conso.load_tmp_clients_affaires

This is the error that pops up:

Could not use view or function 'v_client_affaire' because of binding errors.

Invalid object name...

The problem was exactly that, the owner wasn't specified.

I fixed that, but now I'm having yet another problem, which is described on a new topic: 'DTS exec error!'

If you could...

THX!

That's what I did and it worked, now I've got another problem:

One of the tasks on my DTS is execute a stored procedure, and when I execute it an error...

Thx for the reply!

The first task on my DTS is as follows:

truncate table dm_conso.dim_base_natural

truncate table dm_conso.dim_campanha

truncate table dm_conso.dim_caracteristicas_cabelo

truncate table dm_conso.dim_codigo_postal

truncate table dm_conso.dim_escalao_idade

truncate table dm_conso.dim_fonte_contacto

truncate table dm_conso.dim_local_compra

truncate table dm_conso.dim_modo_contacto

truncate table dm_conso.dim_motivo_contacto

truncate...