we got this data from a sharepoint source and need to get the specific value from column A regular expression..

If i use group by left(OU, 7) am getting the desired output only in terms of total count. what should i do to get both OU and total count as...

The error description needs to be altered and customized as per the requirement for which i cant use Execute sql task. the requirement is to use Script task. am using...

This was my initial query where i was considering only Bios ID. Based on latest time stamp, i was able to merge both source table.

WITH Combined As(

SELECT MachineID,TimeStamp,Account,BiosID,SerialNumber,HostName

FROM TEST1

UNION

SELECT...

Sorry.

My source tables are read only which are structured by some one else.

MachineID is not primary key. There is no primary key in both source tables.

Destination table does not have...

Hello,

Both Test1 and Test2 are source tables and result should be stored in a different destination table.

I even posted the table structure with values.

Result tale should be:

Result:

MachineID |Timestamp |Account |BiosID...

Drew's query is perfectly fine. The issue was with my data. when i checked the data from source table, Machine ID and Instance Key were not primary key. hence few...

It is just dummy table name. Query is working fine now.

Am able to get single record based on time stamp.

Thank you.

Hi Allen,

The query is returning duplicate rows. i have same MachineID and InstanceKey in both tables. only Account. Schema class and time key is different. I mean Work_Station_Admin_1 got updated...

This works perfectly fine for me. Thank you.

But if you don't mind, can you explain me the code please?

Yes. For each combination of machine ID and instance ID, which ever gets updated at latest in both the tables, that i should insert in another new table.

This is because...

1st table Name: Work_Station_Admin_1

MachineIDInstanceKeyTimeKey RevisionIDrowversion AccountSchemaClass

167772831 ...

Sorry i did not understand clearly.

Can you please give me some real example with the below query?

Thanks in advance.

Thank you Phil,

Is there any example to do that?

i have row version in my source table. using row version can i do the incremental load? will the performance is fast...

Hi phil,

yes i have sufficient data in source table and am able to use lookup and conditional split for incremental data load.

problem is i have huge number of records in...