Viewing 15 posts - 7,696 through 7,710 (of 11,676 total)
They are just different providers. ADO.NET is the ActiveX Data Object for .NET, OLE DB is implemented using the COM model.
Important points are:
* OLE DB is most of the times...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 2:03 pm
How did you do the import exactly?
What is the datatype of the column that stored the date and time information?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 1:56 pm
The problem is that the JET OLE DB provider - used to read Excel files - tries to "guess" the datatype.
It scans the first 8 lines of the column and...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 1:38 pm
david.alcock (3/8/2012)
Its OK, found I could use a table, just assumed that was for data only!
SSRS thinks it does, because you (unfortunately) still have to assign a dataset to it...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 1:34 pm
Phil Parkin (3/8/2012)
The File System task does not have the required horsepower.
The File System Task doesn't even have the horsepower to decently move a file, let alone do something more...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 1:24 pm
Jack Corbett (3/8/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 1:20 pm
Then why not create a stored procedure instead of trying to bypass security to execute a .sql file?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 1:06 pm
FunkyDexter (3/8/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 1:05 pm
Ken Davis (3/8/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 10:10 am
Daniel Bowlin (3/8/2012)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 9:59 am
Do you know upfront how many little files you need to create?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 9:57 am
Jack Corbett (3/8/2012)
Has anyone gotten the newsletter today? I have not and I keep getting a notification email for the same post.
Got mine a bit late, but...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 9:55 am
Phil Parkin (3/8/2012)
Just modify your proc to UNION the two result sets and you're good to go.
+1
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 9:54 am
Is it possible to modify the stored procedure?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 7:25 am
What would have been nice if the role of ValidateExternalMetadata was included in the article and how it can work together with DelayValidation during design time.
For the rest, nice article.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
March 8, 2012 at 3:32 am
Viewing 15 posts - 7,696 through 7,710 (of 11,676 total)