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 month, 3 weeks 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 2 months, 2 weeks 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...

I hope that server is fully licensed for SQL Server - whatever version you have installed.

running filesystem packages with dtexec directly MAY require the packages to be fully "upgraded" to...

it does keep version information.

code below from documentation - https://learn.microsoft.com/en-us/sql/integration-services/packages/deploy-integration-services-ssis-projects-and-packages?view=sql-server-ver16

other ways of doing it - including ci/cd pipeline - the one below just requires a share accessible by...

main thing is not to use native SSMS to deploy - either use VS deploy or T-SQL

apologies - missed that reply.

this is around the issue I thought - and not much you can do about it other than...

use PlanExplorer to scramble the names - https://www.solarwinds.com/free-tools/plan-explorer

that will replace any object name (db, table, column) with object1, object2 and so on - but it will leave...