thanks for the replies.

I will try it. 🙂

Hi once again!

Forget about the last post. I've found the solution.

The clause 'where' needs to be on both tables, like this:

select * from Table1 as a

where ((datepart(dd,a.datefield) <= datepart(dd,GETDATE())) and

...

thanks for the help!

I've solutioned the problem.

Thanks once again.

Hi!

You need to start the SQL Server Agent.

Right click Jobs and add a new job.

Hi! I think it's not necessary a proxy. In order to run a dts package, you just need to put the dts file in :

(for example "C:\Program Files\Microsoft SQL...

thanks for the patience.

The field to be updated is already type bit. I've also tried one thing:

Conditional Split with 2 conditions (OutputSalesHeaderStatus == 1 and OutputSalesHeaderStatus !=1), then for the 2 outputs I...

Hi!

After de lookup, I made a conditional split with the condition:

(OutputSalesHeaderStatus == 1)

Then a derived column with the expression:

(ISNULL(OutputSalesHeaderStatus) ? FALSE : TRUE )

I have the following...

Yes, I'm using SSIS.

OutputSalesHeaderStatus(type:integer) is an output of a lookup. If that output is 1, then a field in another table is updated. It cannot be null.

Is there other way?

Thanks...

thanks for the reply.

the message is queued but it did'n arrived. I also want to associate the message to a sheduled job.

thanks!

it works great!!

😉

thanks!

yes, i noticed that i was not joining them!

[]