you have not understood anything that was transmitted to you.

you setup a job - that job restores a particular database from a particular location - if name and location is...

I would also query the MAXDOP and (CTFP) settings - you seem to have a server with 64 HT (2 numa nodes) and you seem to either have a MAXDOP...

and sometimes being (or not) unicode also gives the same error - many times this happens because someone edited or created a file manually for testing and didn't set it...

your'e welcome.

try the following.

adjust number of columns as required - and if they vary hugely you can change that part of the code to be dynamic and based on the max...

in SQL the only thing that allows something nearer regex is patindex - but it is still not full regex.

give that one some time as it can do things that...

did a bit of changes to your code - untested and may have typos so if you get any error that is most likely why

there are a few comments on...

same thing

you can do it 2 ways

1 - when you are posting you can select the option from the menu that says "insert/edit code sample" - this pops up a...

you may not need one, even if MS tells you there is a missing index - many times you add those and they either don't improve performance or they aren't...

Here is the complete code:

I a now using coalesce so that extra query inside when exists is removed. I do not see a huge performance gain though.

code deleted as...

• This reply was modified 5 years, 4 months ago by frederico_fonseca.

when posting code can you please try and format it better and use the "insert/edit code sample" option so it is easy to follow it.

as all that code is repetitive...

if format is always the same you will need to use a bit of substrings and concatenation

extract following blocks

• year
• month
• day
• time

then concatenate year-month-day  time with between day and...

have a look at these 2 links to see if they help.

https://stackoverflow.com/questions/10232084/attunity-ssis-not-available-in-ssis-data-flow-tasks

https://stackoverflow.com/questions/54683977/attunity-connectors-are-not-showing-in-ssis-for-vs-2017-sql-server-2017

Thanks! That's what I thought but I wanted to make sure if i'ts not any different. Would CDC method works better for Very large database(2TB)?  Does Informatica handles better...

CDC can be used in AWS RDS - https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appendix.SQLServer.CommonDBATasks.CDC.html

but CDC does not push anything - just helps a ETL job to identify what has changed.