Viewing 15 posts - 1,651 through 1,665 (of 11,676 total)
"Exceeds 15 minutes" --> is this V2 or V3?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 13, 2014 at 1:16 am
Why is it an issue there is a bit of complexity in the final SELECT?
You can rewrite the CTE so that it also does the logic of the final SELECT...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 13, 2014 at 1:14 am
Easy enough for a Monday morning 😀
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 13, 2014 at 1:08 am
Eirikur Eiriksson (10/11/2014)
cbrammer1219 (10/10/2014)
Will this be the same with SSIS 2010?This is the essentially the same in SSIS 2012 (VS 2010)
😎
And in all other existing versions of SSIS, going from...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 13, 2014 at 12:57 am
Pritz (10/11/2014)
Destination is excel, how will we able to use ace oldb, can you please explain?
This blog post might have some useful information:
SSIS Reading Excel (xls) data in 64 bit...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 13, 2014 at 12:39 am
Pritz (10/10/2014)
Microsoft excel 97-2003
I've read somewhere that the ACE OLEDB driver has less issues with this. Try using that one instead. Not sure if it works with 97-2003, maybe you...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 11, 2014 at 2:26 am
gasblr (10/10/2014)
Yes there is not a 1:1 relationship between the two fact tables. But, is there a work around for many to many relationship between...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 11, 2014 at 1:48 am
In that case you can use a for each loop to iterate over the tables and import them to the history table using a data flow task.
Your best bet is...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 10, 2014 at 8:18 am
You can only use SSIS if the metadata (aka the schema) of the table stays the same.
SSIS hates changing metadata.
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 10, 2014 at 8:11 am
Eric M Russell (10/10/2014)
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 10, 2014 at 8:08 am
What's the Excel version?
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 10, 2014 at 7:54 am
sqldriver (10/10/2014)
And yes, they refuse to implement a default constraint of 0 to make their lives easier. Because less code is... bad? Something?
Constraints are evil! Because of uh... EVIL!
😎
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 10, 2014 at 7:47 am
fokkol (10/10/2014)
Koen Verbeeck (10/10/2014)
fokkol (10/9/2014)
Did not know about that, thanks koen.But the problem here isn't really the mapping 'in' SSIS, but SSIS detecting the source column as NUMERIC(38,4).
Is it possible...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 10, 2014 at 6:58 am
Junglee_George (10/10/2014)
I can remove this DISTINCT keyword from the query once the OUTER APLLY is changed to...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 10, 2014 at 4:19 am
GilaMonster (10/10/2014)
Large log file will not be the cause of performance problems. Look elsewhere for your performance issues.Managing transaction logs: http://www.sqlservercentral.com/articles/Administration/64582/
What if the log file has to grown continuously? Or...
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
October 10, 2014 at 4:10 am
Viewing 15 posts - 1,651 through 1,665 (of 11,676 total)