Hi,
Basically, I have to deny the rows in table2 > number of units in table 1 for that date range.

Hi Guys,

I solved this using Script task.

I added a foreach loop container and a script task and added below code

var directory = new DirectoryInfo(Dts.Variables["User::remoteFolder"].Value.ToString());

...

My XML file has different nodes with different information. I have to put them in different tables and join them on their respective Id's and ParentId's.it is not in same...

hi ,

Thank you!

I used distinct and got the answer.

I have to stage the data from XML file into different tables and then use joins to put them together...

thank you :-). I put them in CTE and it worked

hi,

Thank you!!

we have to insert source table via webservice and I am doing this in a script task. after the source table is inserted via web service, then I have...

thank you !!

This makes sense!

Well, client have a web service which inserts the values and lot of bugs with webservice and wrong value is brrn assigned to create ID....

Hi,

There is update trigger and it has something like below code,

UPDATE [dbo].

SET

.[CreateId] = ISNULL(deleted.[CreateId],

.[CreateId]),

.[CreateDate] = ISNULL(deleted.[CreateDate],

.[CreateDate]),

.[LastUpdate] = GETDATE(),

.[UpdateId] = SUSER_SNAME()

FROM [dbo].

JOIN inserted

ON (inserted.[tableId] =

.[tableId])

LEFT JOIN...

thank you very much!

How can i achieve that using except clause?

Hi ,

Thank you!yes I agree with you! My client wants to check if columns are same .update only if they are not same. I could think only of this way....

Hi,

More than 40 columns.

Hi,

We cannot have hash because target table does not have it. we cannot alter the target table.

Can we do this by dynamic updates?

i.e. I want to check if any...

They are in different database.

Basically, I am looping the files in SSIS and loading each file in target table. so each time I loop the file and load in target...

Thank you :-).

I suggested same but they are asking to check individual column when there is no difference .

Thanks again 🙂