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, 10 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, 10 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...

If a column contains a non-numeric character, do you want to treat it is zero? If not, what?

Have you investigated TRY_CAST()?

Remember that the numeric datatype has both a size and...

You need to install SSDT and then add the 'SQL Server Integration Projects' extension.

This looks like a duplicate of https://www.sqlservercentral.com/forums/topic/validate-result