October 8, 2014 at 5:33 pm
Hi, I've just installed SQL Standard 2014, having been using 2000 til now, and I'm struggling to find something.
I have done a data import using the wizard and stored the SSID package on the Server. Problem is that I've no idea how to run it again using SSMS. Having researched it, I've looked in the "Integration Services Catalogs" on the Server, just one folder there SSISDB with nothing in it. And I've tried to connect to "Integration Services" instead of Database Engine, but it wont let me change the Authentication settings... Seems to wont to use the local account, which is grayed out. I've drawn a blank now.
Any help would be greatly appreciated
Thanks
October 8, 2014 at 8:58 pm
Try running management studio "As Administrator" and then connecting to SSIS.
October 9, 2014 at 3:32 pm
Yes thank for sending me on the right track. Even though the user was an administrator, I had to give it access to the Integration Services. msdn help sent me to...
http://msdn.microsoft.com/en-us/library/hh213130(SQL.110).aspx
thank you
October 16, 2014 at 3:14 am
hello, i too have been working with SQL server 2000 up till now n never upgraded to any other higher version. I want to know whether it will be very complicated n tough working on SQL server 2014?
October 16, 2014 at 5:21 am
nostalgic.raj (10/16/2014)
hello, i too have been working with SQL server 2000 up till now n never upgraded to any other higher version. I want to know whether it will be very complicated n tough working on SQL server 2014?
That's a very open-ended question with no right answers.
What do you want to do with SQL 2014?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply