Viewing 15 posts - 1,651 through 1,665 (of 11,678 total)
"Exceeds 15 minutes" --> is this V2 or V3?
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...
October 13, 2014 at 1:14 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...
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:
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...
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...
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...
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.
October 10, 2014 at 8:11 am
Eric M Russell (10/10/2014)
October 10, 2014 at 8:08 am
What's the Excel version?
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!
😎
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...
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...
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...
October 10, 2014 at 4:10 am
Viewing 15 posts - 1,651 through 1,665 (of 11,678 total)