Viewing 15 posts - 2,671 through 2,685 (of 2,883 total)
What is the default database of the linked server user on the linked server side?
Even if you are using the OPENQUERY method, you could try using 3 part...
March 22, 2017 at 1:18 pm
Thank you for your detailed reply.
We are small team so we have to manage the...
March 22, 2017 at 8:19 am
March 20, 2017 at 8:58 am
Possibly an easier answer - convert User.id to a varchar.
edit - guess I shouldn't have left this open for a bit before answering... others beat me to that LOL.
March 17, 2017 at 4:36 pm
what happens if you change the visible to true? You should be able to see Excel running then and any errors that are coming up.
Since excel starts, but...
March 17, 2017 at 3:12 pm
March 17, 2017 at 1:22 pm
Thanks for your reply! I've now managed to deploy the dtspackage on to the MSDB...
March 17, 2017 at 11:19 am
If I was implementing it, I'd do a 3 table system:
Company - which would hold the company name, the board member and the shareholder with FK's on board member...
March 17, 2017 at 9:54 am
I have 2 thoughts:
1 - are you using a network share for the excel file and if so, are you using UNC paths?
2 - does your SQL Server...
March 17, 2017 at 9:39 am
Did you provide the full path to the package?
What is the full command you are running? Seeing the arguments you provided will likely help resolve the issue.
March 17, 2017 at 9:34 am
Have a problem not sure if its permission issue or something else, any...
March 16, 2017 at 4:30 pm
Narine M - Thursday, March 16, 2017 3:23 PMThe SAO server in different domain , whether it may cause any issue.?????
Depends on...
March 16, 2017 at 3:41 pm
Viewing 15 posts - 2,671 through 2,685 (of 2,883 total)