Destination Table has only 3 Indexes,

One Column store Index

is this a clustered or non clustered columnstore?

and how many rows on that table - you did mention that source table had...

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

more details required - DDL for source table and destination table please - including ALL indexes (and triggers on destination if applicable)

And please do post the powershell script - at...

and is destination using fast load? and does destination table have any indexes? and is the destination database in full , bulk or simple recovery mode?

also, and this is something...

using the bulk insert option works fine (in SQL 2016)

the openrowset I didn't manage to make it work - but didn't spend too much time on it either.

            
May 31, 2021 at 6:06 pm
            
#3890288

            
            
                                                
        

can you post a sample file so we can try it?

and what happens if you change the following to nvarchar - with (SourceFile varchar(100), [Comment-dan] varchar(100)) as hygg

kick off the install as an administrator explicitly - right click and "run as administrator"

well. half that page is talking about cache sizes and management so in my opinion it was enough to guide me - note that cache management is only an issue...

reading the manual helps - that is why it was written.

https://docs.microsoft.com/en-us/sql/t-sql/statements/create-sequence-transact-sql?view=sql-server-ver15

its possible that the 2 db's are in different compatibility level

Select b.* from #Imports
  CROSS APPLY dbo.UDF_datasummary(a.HS_code) b

missing alias - "a"

I would start by giving all tables a short alias (some tables do not have any) and use it in all respective columns so it is clear to anyone which...

the user that the instance runs under may not have access to that folder - check permissions

Not sure I understand what you are saying...

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

Brandy - you were asked to look at Windows Event Viewer and at msdb sysssislog  - do you have any of the messages logged there? if not can you change...

easy search with google (https://www.google.com/search?q=IANA+timezone+names+c%23) and the following is one of the first hits.

https://github.com/mattjohnsonpint

there may be others