Viewing 15 posts - 1,366 through 1,380 (of 2,649 total)
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
on your pc you need both 32bit and 64bit of the oracle client as you were told before.
32bit install should be done first.
Did you do that?
August 14, 2020 at 10:33 am
parallel is not necessarily worst - in many cases is it a lot faster than serial but it all depends.
as we mentioned before we need full code including underlying views...
August 12, 2020 at 6:57 pm
if you have Enterprise Edition use the Attunity driver instead as it is faster - you still need oracle client.
if you have SQL 2019 then the newer driver will be...
August 10, 2020 at 11:12 pm
Viewing 15 posts - 1,366 through 1,380 (of 2,649 total)