Viewing 15 posts - 1,936 through 1,950 (of 9,703 total)
Check the linked server itself and make sure that RPC and RPC Out are both set to TRUE.
March 21, 2016 at 12:36 pm
alicesql (3/21/2016)
So, in SQL Agent, I chose File System for the SSIS job step Package Source, and point it to the same package location that is used in VS.
This...
March 21, 2016 at 12:31 pm
alicesql (3/21/2016)
March 21, 2016 at 12:27 pm
Alan.B (3/21/2016)
yb751 (3/21/2016)
SQLRNNR (3/21/2016)
Brandie Tarvin (3/21/2016)
Lynn Pettis (3/21/2016)
March 21, 2016 at 12:13 pm
Lynn Pettis (3/21/2016)
March 21, 2016 at 8:18 am
below86 (3/21/2016)
And if you don't have the rights to create the SP on the server?
I presume the company in question would have an SDLC process to move something from Dev...
March 21, 2016 at 8:13 am
Luis Cazares (3/21/2016)
Eirikur Eiriksson (3/21/2016)
Brandie Tarvin (3/21/2016)
For those of you with standing desks, ArsTechnica says it may not be helping[/url] you at all.😎
Now, that's a great idea....
March 21, 2016 at 8:10 am
March 21, 2016 at 7:49 am
manoj.kumar-1078069 (3/17/2016)
2) Loop over the record set and store each query in a variable
Depending on how big the query is, this may not work. Variables in SSIS have a...
March 21, 2016 at 7:37 am
below86 (3/16/2016)
Brandie Tarvin (3/15/2016)
aavi1011 (3/14/2016)
App team provided select statements and want output of select statement as report in xls or csv format to thier email ID
Is this a one off...
March 21, 2016 at 7:32 am
Steve Jones - SSC Editor (3/15/2016)
JustMarie (3/15/2016)
Steve Jones - SSC Editor (3/15/2016)
One bit of advice. Work with your body shop to make sure that the repairs come under...
March 15, 2016 at 11:58 am
Can someone help over on this thread? I'm positive the OP needs to rebuild SQL Server, but he seems certain that his backup strategy works and that the issue is...
March 15, 2016 at 10:08 am
GilaMonster (3/15/2016)
Ed Wagner (3/15/2016)
GilaMonster (3/15/2016)
Brandie Tarvin (3/15/2016)
March 15, 2016 at 5:40 am
aavi1011 (3/15/2016)
Yes I know,But creating Sp's in production,DBA need to get more permissions,Need to take this to other level.
It sounds as if you've never used Data Flow Tasks given your...
March 15, 2016 at 5:38 am
aavi1011 (3/15/2016)
This need to happen daily.
Do you know how to create an SSIS package?
March 15, 2016 at 4:08 am
Viewing 15 posts - 1,936 through 1,950 (of 9,703 total)