i give this

choose to open dtsx file

in this pc have't sql server 

only ssis have

THANKS FOR REPLY

BUT IN @TIME TABLE ALSO '2012-01-01'),('2012-02-01')  IS_WORK COLUMN=0

MEE NEED TO UPDATE WITHOUT IS_WORK COLUMN=0 ONLY IS_WORK COLUMN=1

FOR EXAMPLE NEED RESULT THAT AFTER UPDATE

DATEMONTH IS_WORK

---------- -------

2012-01-01 0

2012-01-02 0

2012-01-03 0

2012-02-01...

i want to give values (for insert update delete)

rule is that

if @idvalue>0 and another values is empty then delete

if @idvalue =0 or is empty then insert

and was create this script...

OH NO SIR

I'M ABOUT SAVING THIS ALL STORED PROCEDURES?

CAN I SAVE IN ANOTHER DATABASE?

i know

but have a more 200 tables and if have 2 procedure will be 400 stored proc?

where i will give this procedure?

have any another optimization method?

yes have primary key

but i was deleted and tested

also this error give me null from error table

and i was update insert statement that in this stored proc (want to insert...

not working too

because dont add to error table([dbo].[Sola_uspLogError] )