Viewing 15 posts - 736 through 750 (of 5,109 total)
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 21, 2019 at 3:47 pm
Sounds like you're after Environmental Variables. I assume you're using SQL Server 2012+ and SSISDB?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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.
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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?
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
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...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 4, 2019 at 1:22 pm
SQL Saturday in Edinburgh - 1st Feb, anybody from here thinking about going?
Haven't been to Edinburgh since I was about 14, but planning to go there next year...
Thom~
Excuse my typos and sometimes awful grammar. My fingers work faster than my brain does.
Larnu.uk
October 4, 2019 at 10:52 am
Viewing 15 posts - 736 through 750 (of 5,109 total)