Viewing 15 posts - 6,526 through 6,540 (of 11,676 total)
Troubleshooting MSDTC Permission Issues When a Distributed Transaction Starts
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 23, 2012 at 11:24 pm
Mordred (8/22/2012)
I set the properties-Window Style to Hidden and now all is good in my hood.
Good to know. Thanks for posting the solution.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 23, 2012 at 2:40 am
When you use transactions in SSIS, MSDTC is used (Distributed Transaction Coordinator). Maybe you don't have permissions on that?
Or maybe the SQL Server instance doesn't allow distributed transactions?
An alternative is...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 23, 2012 at 2:37 am
Daniel Bowlin (8/20/2012)
I am not sure if this answers your question, but the properties of the package have version information.
SSIS autoincrements the build number of the package everytime you save...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 23, 2012 at 2:34 am
Dammit! Moar coffee!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 22, 2012 at 11:36 pm
n79799 (8/22/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 22, 2012 at 11:21 pm
Great question, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 22, 2012 at 12:17 am
Easy question for the Monday 🙂
@Ron: the answer does have a reference to the COUNT MSDN article
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 20, 2012 at 1:15 am
rasika.segan (8/17/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 19, 2012 at 11:55 pm
will.byrne (8/16/2012)
Mhlewis (8/16/2012)
...But I just have to ask, how in the world do you get a job in BI with no database experience?!?
Good question, I'm not sure. I'm scared...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 17, 2012 at 1:42 am
Great question, but way too difficult for a Friday 🙂
Didn't even think about RECEIVE.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 17, 2012 at 12:12 am
Can you post the full output of the output window?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 16, 2012 at 12:13 am
Nice question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 15, 2012 at 11:31 pm
Easy one, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 15, 2012 at 11:25 pm
Great question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 15, 2012 at 11:21 pm
Viewing 15 posts - 6,526 through 6,540 (of 11,676 total)