Viewing 15 posts - 7,996 through 8,010 (of 11,678 total)
Tools --> Options --> Query Execution --> SQL Server --> Advanced
There is a checkbox for "Disconnect after query executes". Is that one checked or not?
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...
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"?
February 10, 2012 at 5:23 am
Are we talking about the 2008 version?
Is this everytime, or after a period of inactivity?
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.
February 10, 2012 at 5:19 am
Package configurations are created for just this purpose:
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)
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...
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...
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.
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.
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.
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...
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...
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.
February 10, 2012 at 1:30 am
Viewing 15 posts - 7,996 through 8,010 (of 11,678 total)