Viewing 15 posts - 5,371 through 5,385 (of 11,676 total)
Import it into a table using SSIS. Create the table before import and add the ID column with the IDENTITY property.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 1, 2013 at 3:05 am
You probably need a full outer join.
Also check the first link in my signature on how to ask questions on forums.
It will make life easier for people trying to help...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 1, 2013 at 3:03 am
Maybe you can try to do a repair of BIDS? (or maybe a re-install)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 1, 2013 at 1:57 am
TheSQLGuru (7/30/2013)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 1, 2013 at 1:34 am
Easy one today, thanks.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
August 1, 2013 at 12:51 am
nealz (7/31/2013)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 31, 2013 at 2:38 pm
The errors are quite specific.
There's a truncation at line 153 for column FIN_ACCI_TITLE.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 31, 2013 at 2:04 pm
nealz (7/31/2013)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 31, 2013 at 1:42 pm
It is not necessary, it depends on the requirements. If you never going to analyze on location, it is not necessary.
However, if you would like to answer questions like "which...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 31, 2013 at 3:20 am
Back to basics. Thanks for the question Steve.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 31, 2013 at 3:04 am
Grant Fritchey (7/30/2013)
SQLRNNR (7/30/2013)
Koen Verbeeck (7/30/2013)
SQLRNNR (7/29/2013)
L' Eomot Inversé (7/29/2013)
WayneS (7/29/2013)
FWIW: I prefer the older images over...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 31, 2013 at 2:51 am
Regarding the address: typically you would store the street and number in one field, but zipcode, town and country in other fields. Maybe in a different dimension altogether: the geography...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 31, 2013 at 2:48 am
mayank_sanghvi (7/30/2013)
I think BIDS feature is available in SQL Server 2012 not in 2008. For SQL Server 2008 you can use dtutil or Package Installer.
You do realize this thread is...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 31, 2013 at 2:40 am
I would open up the solution in visual studio and change as much as you can in there.
All the rest you'll have to change by opening up the XML and...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 30, 2013 at 1:51 pm
Grant Fritchey (7/30/2013)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
July 30, 2013 at 12:51 pm
Viewing 15 posts - 5,371 through 5,385 (of 11,676 total)