Viewing 15 posts - 7,996 through 8,010 (of 11,676 total)
Tools --> Options --> Query Execution --> SQL Server --> Advanced
There is a checkbox for "Disconnect after query executes". Is that one checked or not?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 10, 2012 at 6:12 am
saidapurs (2/10/2012)
If i execute any query it showing below error.....
An error occurred while executing batch. Error message is: The directory name is invalid.
Today i deleted some...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 10, 2012 at 5:41 am
What errors do you get?
What do you mean with "i can use SQL SERVER 2008 to connect to connect to different instances except the local instance"?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 10, 2012 at 5:23 am
Are we talking about the 2008 version?
Is this everytime, or after a period of inactivity?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 10, 2012 at 5:22 am
BinaryDigit (2/10/2012)
Can those generate straight off the database?
Well, Powerpoint can't, but I think all the others have a reverse engineer function.
Check the product documentation, it will surely be mentioned somewhere.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 10, 2012 at 5:19 am
Package configurations are created for just this purpose:
Understanding Integration Services Package Configurations
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 10, 2012 at 5:16 am
I don't know if they can be classified as 'awesome', but these tools can make diagrams:
* Embarcadero
* ERStudio
* PowerDesigner
* MS Visio
(* MS Powerpoint)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 10, 2012 at 5:13 am
padmanabhuni.k (2/10/2012)
Hi thanx for your reply.In SSIS I dont know how to create named ranges to load data into excel.
Excel Names -- Excel Named Ranges
It is the first Google result...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 10, 2012 at 3:18 am
PanKostka (2/10/2012)
In Extended properties change "Excel 12.0" -> "Excel 12.0;IMEX=1"
Then all rows from Excel are datatype Unicode string 255 (DT_WSTR). So...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 10, 2012 at 2:25 am
Eric Mamet (2/10/2012)
Indeed... If I choose the executable directly rather than double clicking on the package, it works fine.Once again, thanks a bunch! :w00t:
No problem, glad to help.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 10, 2012 at 2:24 am
It's the maximum commit size, so it only defines the maximum. Not a minimum.
Try setting also the rows per batch. And enable transactions to be sure.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 10, 2012 at 1:47 am
Maybe try the reporting services forums, you'll get better answers there? This forum is about Integration Services.
Hint: also explain your question more clearly, preferably with examples.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 10, 2012 at 1:45 am
ssubudhib (2/9/2012)
How can i export a report to excel that has more than 1,50,000 rows. My present application is based on .NET Framework 2.0 and reportviwer 2005.Please Suggest...
You can't. Excel...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 10, 2012 at 1:43 am
The only thing I found is this:
http://www.decosta.com/Nomad/cgiseries/cgipart1.html
It talks about using visual basic to extract data from Nomad, but it's also talking about Windows 95, so I'm afraid it is a...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 10, 2012 at 1:37 am
Are you sure you are using the DTEXECUI of the correct version?
Maybe it calls the DTEXEC from a different version, hence the failure.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 10, 2012 at 1:30 am
Viewing 15 posts - 7,996 through 8,010 (of 11,676 total)