Viewing 15 posts - 5,596 through 5,610 (of 13,874 total)
I can only imagine how annoying that this is. I'm running out of ideas, but I think I would do the following:
1) As well as scripting the close...
May 11, 2017 at 7:48 am
May 11, 2017 at 7:14 am
May 10, 2017 at 5:56 am
If your data is always in the very structured format your sample data shows, this works:
DROP TABLE IF EXISTS #Temp;
CREATE TABLE #Temp (Name NVARCHAR(200));
May 10, 2017 at 5:56 am
Not sure whether it is relevant, but what is the value of the RetainSameConnection property on the Excel Connection Manager?
May 9, 2017 at 3:15 pm
Was the file copied, or moved? Copying should inherit permissions in the way you want, but moving does not necessarily do so.
May 9, 2017 at 1:47 pm
May 9, 2017 at 12:20 pm
May 9, 2017 at 11:47 am
OK, good.
If you check both
C:\Program Files (x86)\Microsoft SQL Server\130\DTS\Binn
and
C:\Program Files\Microsoft SQL Server\130\DTS\Binn
Do the paths exist?
Do they contain any .bak files at all?
May 9, 2017 at 10:39 am
May 9, 2017 at 10:32 am
May 9, 2017 at 10:25 am
Eric M Russell - Tuesday, May 9, 2017 8:41 AMSo, it's essentially a staging table that you're comparing back to Excel.
Getting...
May 9, 2017 at 9:03 am
May 9, 2017 at 8:58 am
You are not quite correct. SSMS 2016 is just the client part of the install and it can easily be used to access servers with older versions of SQL Server...
May 9, 2017 at 8:55 am
Viewing 15 posts - 5,596 through 5,610 (of 13,874 total)