Viewing 15 posts - 2,701 through 2,715 (of 2,905 total)
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
Yes, i looked in to the post, whether the uninstallation and reinstallation of...
March 16, 2017 at 2:07 pm
Narine M - Thursday, March 16, 2017 2:07 AMThe query is working fine in all servers, expect SAO server.. Checked the linked connections using the simple select query it's working fine...in that query it fetches the result from SAO server, through linked server connections...But it error outs...
did you look at that link I posted?
Also, did you compare the linked...
March 16, 2017 at 8:11 am
bubby - Wednesday, March 15, 2017 10:23 AMVirtual Machine please
That is the most expensive route if memory serves. If I remember correctly,...
March 15, 2017 at 11:53 am
Oh, Lynn... Your code does have that join/where that I mentioned, but you do it on tbl1 which is Thin_water. The original was on tbl2 which is Water_Derivation.
I read...
March 15, 2017 at 10:18 am
Is this what you are trying to accomplish? (Please note I commented out the...
March 15, 2017 at 9:26 am
It would probably be handy if we had:
1 - the code being run that is failing
2 - the linked server connection information
I was re-reading the original...
March 15, 2017 at 9:14 am
Viewing 15 posts - 2,701 through 2,715 (of 2,905 total)