I played with this and i need to store the hashbytes value in the Target database that only has a column of int that i can use.
I...

I was able to install visual studio and set up my first SSIS package to take data from table a and put into table b and it also wrote to...

Thanks, for some reason when i ran my new code it did the errors and capture in my new table...the one that should have inserted, it didn't write to my...

Hi sschasing, I doing a few inserts first, and then a larger conversation starts from source to target.  I thought it may be simple to do a few inserts but...

I got so far, trapped the error and wrote to a log table TRACKER_VEND so at least it didn't fail on the constraint

That is  a step forward.

I will also work...

Scott, how would i know what record i am on here....

--write code to log key(s) of row that had valid INSERT

BEGIN TRANSACTION

BEGIN TRY

INSERT INTO TRACEY_VEND (

[VEND_ID],[TERMS_DC],[S_AP_1099_TYPE_CD],[AP_1099_TAX_ID]

,[AP_ACCTS_KEY],[CASH_ACCTS_KEY],[MODIFIED_BY],[TIME_STAMP]

,[COMPANY_ID],[CAGE_CD])

SELECT '1000','NET 0','AP','AB',1,1,'TRACEY',GETDATE(),'1','C'

COMMIT TRANSACTION

/* or,...

I will be dealing with 2000 tables and approx 1 million in some tables.

It is a data migration from one system to another with a mapping in between of old...

Got it, if it has a constraint read that table as part of the join based on your data, rather than trying to automatically code for them all.  Thanks.

I dont want to turn off the constraints,  what I am trying to do is read one row of data, and if there is a constraint, i.e TERMS_DC and that...

Thank you for your help

Thank you.

The end result should just return 101000, as it has two records in client table.

If there is one record in projects and one record in clients this is a...

Thanks i am looking at sys.dm_db_index_physical_stats, a lot of fragmentation 100% with dictionary size.

I will rebuild all these tables.

For regular reorganize I will research a little more.

Thank you

Once you rebuild all partitions how do you find which partition to build, as I would think I don't want to rebuild all partitions every time as that would take...

Wow, I need to amend my CCI Index rebuild script

---First do this

1.  ALTER INDEX idx_cci_someindex ON [sometable]  REORGANIZE WITH (COMPRESS_ALL_ROW_GROUPS = ON);

SELECT * FROM sys.dm_db_column_store_row_group_physical_stats WHERE object_id  = object_id('CCI__someindex')

ORDER BY...