You're apportioning blame in...

That is a common problem when importing from Excel. The way I handle it is

1. Add IMEX=1 to the Excel connection string
2. Include the header row in the import, as...

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

That looks like a good dataset, and I'm sure that your explanation makes plenty of sense, to people who understand the data!

But I'm not one of those people, so would...

Please provide a CREATE TABLE script for [Cranes].[dbo].[LPKCColmnized], along with your desired results, based on the provided sample data (which would be easier to use if it were provided as...

Sounds rather complex. You might be better off putting this into a view or stored procedure.

Are you using global temp tables rather than local ones for a reason? Local temp...

I suspect you'll find that this is a fairly thankless task, once you expand your dataset to include other name varieties, but this code works for your sample data. It...

Can you explain the rules? Looks something like

field1x-field2x-field3x----

where fieldnx = replace(fieldn,'-','')

except your sample data desired output is all over the place

a) the ordering of fields is inconsistent

b) the number of...

Hi All- Thanks for pointing that out. i am working on optimizing the execution. Also, for file count/data matching with table destination, I will insert my transactional data first...

--Deleted. Once again, the site created two versions of my post

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

I made idCategoria only on table categoria, I was gonna make an Alter Table on usuario for creating the foreign key, it means then that I need to create...

Frederico's comments are spot-on.

If it were me, I would attempt to resolve those warnings (exclamation mark inside yellow triangle). Something is misaligned and whatever it is may be slowing things...

Another approach would be to push the initial extract to a raw file, then use that as the source for your flat file and Oracle destinations.

But I don't see...

Have you isolated the line of code which gives the error?

--Edit: removed duplicate reply.

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

That seems somewhat inefficient. I suggest that you add a Multicast after your OLEDB source to broadcast the same source data to both destinations in parallel. Here's a link...