thanks reply ,

I just guess it is Oracle I am not sure  , I am new to it .

this ER diagram is from the vendor , they just ask...

Do you have access to the database containing this table? If you do, try generating the 'CREATE TABLE' script for it. When you see that, it should help explain what...

I can't give you a web page because I do not know which product you used to generate the E/R diagram. It wasn't a SQL Server database diagram, as far...

I think I can help with most of that.

P = Primary Key

F = Foreign Key

The PK_ and FK_ are constraint names, these correspond with the P and Fs.

Red asterisk means...

Show me how to make this better, if you don't  mind. String split isn't recognised for some reason, which makes no sense, unless my version of ssms is too old.

Whether...

What have you actually installed? How is Visio relevant to any of this?

This link shows you how to use SMO to generate the CREATE TABLE script.

Update U set col10=col10+@SSISvariable From mytable U where U.col1='xyz' and col2='abc'

This will update col10 in the same set of rows for each iteration of the loop. Why would you do...

Seems that a good architecture for you would be to push the imported data into (truncated) staging tables and then execute one or more procs which MERGE the staged data...

then on success to a sql task with a waitfor delay

Or a script task with a Thread.Sleep().

Edit: changed my mind.

• This reply was modified 3 years, 2 months ago by Phil Parkin.

As long as you don't mind which order the 'UniqueNumber' is assigned in, this might work:

WITH counts
AS (SELECT p.PartNumber
        ...

I've modified your structure a little to make it more relational and injected some constraints to demonstrate typical referential integrity. Hopefully, it helps you with this. Post back with any...

Or run the queries direct from Excel using PowerQuery.

Nothing else comes to mind. It feels like it's something outside of SSIS ... could some other process be locking the file temporarily? A/V software or some sort of folder...