on the linked server provider and properties ensure that the property "allow inprocess" is set to true.

specify the full path to that executable - that is basic stuff for any operating system - either it is on the PATH or full path needs to be specified

you did not supply enough details - what is the job and how does it connect to ANY server.

getting data out of a server can be done in a multitude...

it does not need to be on admin group for this purposes. - but it will need permissions on the folder in question

logon as a batch and/or logon as a...

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

can't think of much more - except - is the output filename UNC or Drive letter based? if UNC change it to local drive .

I would try and change from executing a SSIS step (which seems to be what you are doing) to execute a command line instead - see if it makes a...

Hello Folks,

Same package with same options (picked from SQL Server Agent command line only) is run manually by opening a command prompt and invoking DTexec utility, the destination gives...

out of curiosity what did...

that really is normally task for 3 individuals - good luck finding someone that can fill all of them.

out of curiosity what did you mean...

if you going for an article on this I suggest you highlight the differences between the Powershell version that SQL Agent uses vs the "windows installed" version - also the...

although you could do it through a PS script directly on the step I prefer, and advise, using a command prompt instead and start an instance of powershell - more...

redgate sql compare would work fine for that.

limitations are on the documentation you read - should you post a link here maybe someone will look at it and if the link is the wrong one give you...

it depends.

dtexec has a varied set of options.

1. execute package - package model - executes locally - option /FILE is used
2. execute package - project model - executes locally if...