Viewing 15 posts - 3,646 through 3,660 (of 11,676 total)
Which provider do you use when reading data from SQL Server?
If you put a data viewer right after the source, is the data still correct?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 26, 2014 at 2:48 am
gsaini 95591 (2/26/2014)
Assuming that earlier loaded data has duplicates which is fine and now I want to upload only uniquedata.Any query would help.Thanks!1
This could be realized with a unique...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 26, 2014 at 2:02 am
If you convert Jan 31 2014 11:59PM to int and then back to datetime, you get Feb 01 2014 12:00AM. So it is a rounding "error", resulting in a day...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 26, 2014 at 1:21 am
No. If you run the package without the XML file present, you will get configuration warnings, but the package will keep running using the values defined during design-time of the...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 26, 2014 at 1:10 am
Yes, you can add a PK after data has been loaded into the table.
You can also use a unique contstraint to check if data is unique.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 26, 2014 at 1:09 am
It might be helpful if you posted the actual errors.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 26, 2014 at 1:08 am
There was once an MSDN blog post with a zip containing those reports, but it seems to be offline.
Those reports are not RDL files stored on your hard drive somewhere.
You...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 26, 2014 at 1:06 am
Easy one, thanks!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 26, 2014 at 12:47 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
February 26, 2014 at 12:41 am
Lynn Pettis (2/25/2014)
Last night home. Start my journey back to Afghanistan Tuesday morning.
Good luck!
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 25, 2014 at 12:53 am
Great question, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 24, 2014 at 1:46 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
February 24, 2014 at 1:43 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
February 20, 2014 at 12:43 pm
stormsentinelcammy (2/20/2014)
will this forum thread ever get back on topic?
Hahahahahahahahahahahahahahaha...
I'm sorry, you were saying?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 20, 2014 at 12:26 pm
Seems like some unicode characters got stuck in your name column.
What is the data type in the SQL Server table?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
February 20, 2014 at 4:21 am
Viewing 15 posts - 3,646 through 3,660 (of 11,676 total)