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.

you don't use CDC instead of ETL - CDC IS a method that can be used as part of a ETL Process

I'm sure you can do a sample create table and insert statements of sample data to help us help you.

field names don't even need to mean anything so no excuse...

Alejandro, if you read the documentation you will see that the example given is indeed on the MS documentation as an option to start SQL Server on single mode and...

what are the reasons for not using backup/restore?

but the copy database option, using SMO, will copy all db objects - data will be the same with likely exception of timestamp/rowversion...

This will explain what it is.

I don't think full plan has columnstore segments data on it - but to confirm we would need the full explain plan file (to...

curious of what statistics io would say on both cases - specifically segments read / skipped which will be an output when table/index is a columnstore.

on this case I don't...

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

Stanley bot - 1 spam post every 5 min. ARGHH!!

great explanation

should this be created as an article instead?

Lordy... there's a "bot" running with the handle of "Stanley" and it's posting spam every 5 minutes.  Between that and another bot that was active only for a while,...

if your source is a file then just split it on the file definition by setting up the file with comma delimited as column separator, quoted