Viewing 15 posts - 8,776 through 8,790 (of 11,676 total)
The second error says it cannot find the Excel file.
* does the Excel file exist?
* if it does, is it locked by some process or user?
* does the SQL Agent...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 16, 2011 at 3:27 am
priya.pk20 (11/15/2011)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 16, 2011 at 3:23 am
The PowerPivot that comes off the SQL Server installation media is intended for integration with SharePoint. For Excel itself (locally on your desktop), you need to download a plug-in from...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 16, 2011 at 3:00 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
November 16, 2011 at 2:21 am
Got back from a 2-day event from our local PASS chapter (SQLUG.be).
My session on SSIS in SQL Server 2012 went amazingly well (the demo gods were apparently very pleased) and...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 16, 2011 at 12:18 am
amitabhbose2 (11/15/2011)
Hi Koen,Many thanks I will give that a go. Would thae expression capture all "0.0" or "0.00*" amounts?
Appreciate your help on this.
No problem, glad to help.
It will...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 16, 2011 at 12:13 am
chris duffield (11/15/2011)
There is a MSc from Dundee University which can be taken part-time (mostly remotely).http://www.dundee.ac.uk/postgraduate/courses/business_intelligence_msc.htm
Tony Rogerson (http://www.sql-server.co.uk/) is currently finishing his dissertation.
Oink. £14000 if you're from abroad.
No thanks...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 16, 2011 at 12:09 am
The data inside the dataflow, does it have a date datatype?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 16, 2011 at 12:01 am
Welsh Corgi (11/14/2011)
The USPS has 5 Digit Zip Codes...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 15, 2011 at 11:58 pm
Ninja's_RGR'us (11/15/2011)
jcrawf02 (11/15/2011)
Hey, I like the condensed version of The Thread...Same here.
No offense if I forgot anything else. I didn't reread the whole 2 weeks either :hehe:.
Hmmm, if I...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 15, 2011 at 11:49 pm
jhowe3 (11/14/2011)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 15, 2011 at 11:28 pm
If you change the protection level to DontSaveSensitive and keep the configuration file (which has the sensitive info), does it work?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 15, 2011 at 11:24 pm
Welsh Corgi (11/14/2011)
Koen Verbeeck (11/14/2011)
What datatype has the numeric column in the SSIS dataflow?
Converting to a Unicode String [DT_WTSR] in a Data Conversion Task.
Since I posted this believe that it...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 14, 2011 at 12:59 pm
What have you configured as the row delimiter in the flat file connection manager?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 14, 2011 at 3:10 am
Great article, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
November 14, 2011 at 2:40 am
Viewing 15 posts - 8,776 through 8,790 (of 11,676 total)