Moreover, the error occurs with ole db destination and sql server destination

Thanks

Diego

The error occurs in debug mode and in the sql server agent...

I have not yet solved the problem.

Have you any advice?? :crying:

Thanks

Diego

Hi,

I have the same problem on AS400 with SSIS 2005...

The performace compared to 2000 are very poor...

so I have used dts in the SSIS...

Have you other solutions in addition to...

:alien: :alien: :alien:

Have you some other idea??

Thank

Diego

Thanks

however, you are sure that this is the problem??

is related to the destination?

you give me an explanation

Thanks

Diego

I used SQL SERVER Destination as destination

and OLE DB Source with SQL Command as source

what is the problem????

Thanks.

Diego.

I have tried with SET STATISTICS IO

Time is almost identical

The difference is that the solution with a single table run 1 physics reading and then all logic

while The solution with...

FUNCTION [dbo].[VenditeAnno]

(

@Mese Int,

@Anno Int

)

RETURNS TABLE

AS

RETURN

(SELECT Vendite.Data, Vendite.Mese As Mese,Vendite.Anno as Anno,

Vendite.Societa, Vendite.Codice, Vendite.TipologiaCliente, Vendite.Classe,

Vendite.Importo1, Vendite.Importo2, Vendite.Importo3

FROM Vendite

WHERE Vendite.Mese=@Mese AND Vendite.Anno=@Anno

)

Example query

solution with single table

SELECT DISTINCT M.Mese,M.Anno,M.Societa,M.Codice FROM

dbo.VenditeAnno(@M,@Anno) M

LEFT OUTER JOIN dbo.VenditeAnno(@P,@AnnoPrec) P

ON M.Societa = P.Societa AND M.Codice = P.Codice

WHERE M.Classe = xxx

VenditeAnno is a function...

This is the table

CREATE TABLE [dbo].[Vendite](

[Data] [datetime] NOT NULL,

[Mese] [int] NOT NULL,

[Anno] [int] NOT NULL,

[Societa] [varchar](3) NOT NULL,

[Codice] [varchar](9) NOT NULL,

[TipologiaCliente] [varchar](1) NOT NULL,

[Classe] [int] NOT NULL,

[Importo1] [decimal](19, 2)...

protection is equal for all packages

(default value: EncryptSensitiveWithUserKey)

Connection Manager -> All -> Pooling OLE DB Services

(default value: default)

Server

Maximum number of concurrent connections (0 = unlimited)

I have to change something?

Thanks 🙂

the child packages execute in sequence

you have alternatives...

Thanks 🙂

Yes, variables have the same name.

in the child package I have used this procedure to create variables

SSIS -> Package Configuration -> Add Parent Package Variable (password connection manager)

while in the...