why bother sometimes. basic sql stuff that should not need our help.

straight replace -

SET @FILEPATH = replace(@FILENAME, 'chartobereplaced_escapedifneeded', 'replacewith_escapedifneeded')

you can just try out until you get the replace correct -...

If you look at the column headers of the file and compare them to the table, they don't match.  We can't see your package to know what the mapping...

this also looks like a possible execution of DTEXEC from the command line (instead of SSIS catalog/SSIS Execute step from sql agent) - and in this case its likely it...

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 12 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 year 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...