did you use "insert into tbl with (tablock)" or without it - and what indexes do you have on destination table.

other than that I can't help as I don't have...

I'm my experience performance and validation was always better and more reliable when we converted dates (and numbers as well) to a string format (dates to YYYY-MM-DD HH:MM:SS.FFF and numbers...

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

the extension does NOT matter for SSIS - you give the filename whatever name+extension you wish.

as long as the format of the rows is what you defined everything will work...

can you give as the ACTUAL explain plan of one of those slow executions - use https://www.brentozar.com/pastetheplan/ to upload the plan and give us the resulting link.

that would give us...

if your C# code above is on your "Data source" on the dataflow Image that is your issue - a Datasource HAS to output a datarow - not write to...

google is your friend - you should have done it first.

https://learn.microsoft.com/en-us/sql/t-sql/statements/set-ansi-warnings-transact-sql?view=sql-server-ver16

regarding the code and because you got a timeout  I would add a command timeout before the executenonquery.

            
October 5, 2024 at 8:35 am
            
#4465543

            
            
                                                
        

main question is HOW did you change the service account.

If not through Configuration Manager, with a elevated account (Local admin, and maybe Domain admin depending on policies) then you are...

try HH24 (upper case)

and are those 3 columns really stored as character values instead of dates? there is no other reason to convert to date to compare.

yes I mean doing it by having DB2 doing all the work.

so it would be

select *
from openquery(remoteserver, 
'select rtrim(col1) as col1
      ,...

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

put both around square brackets e.g. [$AAG] and [$DB]

some things to consider - normally, although not always, data conversion to char datatypes should be done on the linked query side - not sure if this is the case...

I'm assuming you wish to generate a file with fixed size columns - do you need it to be fixed size record as well or can it be line delimited...

you don't create a synonym for the linked sever name - you create a synonym for a object that resides on a linked server.

this means that your code would reference...

then file is working as expected and you are getting the leading zeros - if you need them to be opened in excel as text you need to do a...

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

Just confirmed and my original reply was incorrect - it is one per file - but note that you can't change the file name on the fly, any change to...