Viewing 15 posts - 1,411 through 1,425 (of 2,694 total)
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...
August 27, 2020 at 11:01 am
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...
August 26, 2020 at 6:35 pm
can't think of much more - except - is the output filename UNC or Drive letter based? if UNC change it to local drive .
August 26, 2020 at 6:19 pm
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...
August 26, 2020 at 5:45 pm
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...
August 26, 2020 at 2:10 pm
Other that creating a parameter table the job reads from, I don't know anyone else that has been able to do it either.
out of curiosity what did...
August 26, 2020 at 7:07 am
that really is normally task for 3 individuals - good luck finding someone that can fill all of them.
August 25, 2020 at 8:38 pm
Other that creating a parameter table the job reads from, I don't know anyone else that has been able to do it either.
out of curiosity what did you mean...
August 25, 2020 at 4:25 pm
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...
August 25, 2020 at 4:23 pm
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...
August 24, 2020 at 7:28 pm
redgate sql compare would work fine for that.
August 24, 2020 at 7:30 am
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...
August 23, 2020 at 10:53 pm
it depends.
dtexec has a varied set of options.
August 18, 2020 at 5:30 pm
what you are failing to understand is that your command line is executing the package ON THE SERVER and as such all resources required NEED to be on the server ...
August 18, 2020 at 4:50 pm
on your SERVER you need to install the Oracle client components and configure it as required (tnsnames, sqlnet.ora) - as your SQL server is 64 bit you should install the...
August 18, 2020 at 3:53 pm
Viewing 15 posts - 1,411 through 1,425 (of 2,694 total)