Viewing 15 posts - 106 through 120 (of 2,651 total)
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...
September 16, 2024 at 5:54 pm
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...
September 6, 2024 at 11:29 pm
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...
September 5, 2024 at 12:11 pm
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 -...
September 4, 2024 at 1:42 pm
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...
September 4, 2024 at 1:33 pm
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...
August 30, 2024 at 7:56 pm
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 the server...
August 30, 2024 at 4:50 pm
main thing is not to use native SSMS to deploy - either use VS deploy or T-SQL
August 30, 2024 at 3:53 pm
Already done that, scroll up a little bit.
apologies - missed that reply.
this is around the issue I thought - and not much you can do about it other than...
August 29, 2024 at 11:09 am
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 intact the...
August 29, 2024 at 8:48 am
please post actual explain plan of the problematic query as well as the full sql statement (and of any views/functions used by it) so we can help.
use https://www.brentozar.com/pastetheplan/ to upload...
August 28, 2024 at 1:48 pm
then you have a problem as this is never going to be a slow operation - a amount of downtime will always be required, how much is going to depend...
August 27, 2024 at 5:23 pm
likely the standard method of inserting into a new table with the column being calculated at that stage, and then one of 2 options
1 - truncate source table...
August 27, 2024 at 3:59 pm
if the IP returned in both local PC and problem SSIS server are the same then the server is able to get the DNS entry for the target - on...
August 27, 2024 at 2:32 pm
this likely a DNS issue - within the server where SSIS is running open a command line (RDP) or a xp_cmdshell, or even a custom SSIS package just for the...
August 27, 2024 at 1:27 pm
Viewing 15 posts - 106 through 120 (of 2,651 total)