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 3 years, 1 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 3 years, 1 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

Multiple calls to sqlpackage.exe, with as many different source/target...

If you want a coded solution, please provide DDL, INSERT statements, desired results etc. You know the drill.

I work on sql server 2019 i have issue i can't get percentage of two string from table

so i will compare between two string columns (PartText,MaskText) and i will...

One of the arguments for the SQLPackage command line (link) when Publishing a DB is TargetDatabaseName. Using this, it's quite straightforward to deploy the same DACPAC to multiple databases.