Viewing 15 posts - 736 through 750 (of 5,111 total)
All Databases is on same Instant but instance are different as well.. This is requirement as per DBA.
Huh? A instance can't be the same instance and different instances. That's...
October 22, 2019 at 8:06 am
How can i use stored procedure in Data flow task ?
I assume you mean as a source, like you would any other time you want to use SQL; with...
October 21, 2019 at 3:47 pm
Sounds like you're after Environmental Variables. I assume you're using SQL Server 2012+ and SSISDB?
October 21, 2019 at 3:08 pm
The packages are located on a shared folder in the server which all team members has access to .
That is clearly not true. Look at the location of the...
October 21, 2019 at 2:00 pm
That's the only error message I am receiving.
Yes and the error is telling you, very explicitly, what the problem is. Myself or Phil can't make that error any clearer...
October 21, 2019 at 1:52 pm
I don't mean to be rude, but the error couldn't be more clear...
Access to the path 'C:\Users\User\Source\Workspaces\Workspace\SSIS\Internal PMO\Integrations\SSIS\SSIS Prod\SSIS Prod\SSIS Prod.dtproj' is denied.
October 21, 2019 at 1:50 pm
"open those packages from the server" makes it sound like your using the File System Deployment method as well. Considering your using 2017, why not the project deployment method SSISDB?
File...
October 21, 2019 at 1:44 pm
What does "I am unable to open those packages from the server" mean? What are you doing? What are the errors you're getting? You need to describe the problem, please.
October 21, 2019 at 1:34 pm
As per Hardware and Software Requirements:
SQL Server 2016 (13.x) RC1 and later require .NET Framework 4.6 for the Database Engine, Master Data Services, or Replication. SQL Server setup automatically...
October 11, 2019 at 1:27 pm
Agent is local admin to both servers, but have not specifically provided security to particular folder as it is already admin on the machine.
Agent being an administrator of another...
October 11, 2019 at 11:15 am
I assume the Agent has access to both the source and destination directories? Also, are you using UNC paths for remote shares, if you have them?
October 11, 2019 at 8:38 am
This doesn't surprise me at all, but it does surprise me that BBC realises it's so bad it's a headline: BBC News - Copycat coders create 'vulnerable' apps https://www.bbc.co.uk/news/technology-49960387
October 7, 2019 at 12:48 pm
I wonder if more of us ought to be using UTC or at least datetimeoffset for applications. There are more and more that are crossing time zones and it...
October 4, 2019 at 3:51 pm
We have a dumping ground Utility Database here and it works well.If you can try and get him to come around to the idea, you'll likely start finding other uses...
October 4, 2019 at 2:04 pm
Ooo, I like the new Report function, which shows how many times it has been (prior to you click the function, then it changes to Unreport and doesn't tell you...
October 4, 2019 at 1:22 pm
Viewing 15 posts - 736 through 750 (of 5,111 total)