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

are you sure you ticked the right boxes on the Oracle install? default will not install the required components.

also on a server only the 64bit version should be installed -...

it is but not advisable - a Excel linked server is 1 per file per tab - not something I would setup.

if your DBA is ok with installing the MS...