Viewing 15 posts - 7,366 through 7,380 (of 11,678 total)
rajn.knit07 (4/11/2012)
A file can be of minimum 30000 KB in size. So let say there are around 400 files, ssis is taking around one and half day to load...
April 11, 2012 at 2:39 am
The most used example of a role playing dimension is the time dimension.
Say you have a fact dimension with the following attributes:
* orderdate
* due date
* delivery date
You don't want to...
April 11, 2012 at 2:33 am
April 11, 2012 at 2:30 am
And the question is...?
April 11, 2012 at 2:26 am
danielfountain (4/11/2012)
I need to start canvassing votes I think!🙂
I already started on Twitter 😀
April 11, 2012 at 1:29 am
63 votes and still active?
Seems the RS team has fallen asleep...
April 11, 2012 at 1:20 am
I would still do this in TSQL. It's much easier there, as there are no easy date formatting functions in the SSIS expression language.
April 10, 2012 at 11:59 pm
How many files are we talking about here?
How many rows? How many megabytes?
April 10, 2012 at 11:57 pm
No idea why this still isn't implemented in SSRS.
I wish they did.
Maybe you can create a feature request on Connect.
I'll vote it up 🙂
April 10, 2012 at 11:55 pm
asranantha (4/10/2012)
if u know answers plz tell me
I hope with all my heart you'll never land a DBA job. At least not with that attitude.
I fear for the company's data...
April 10, 2012 at 11:52 pm
It surely works in 2008.
What is your expression?
April 10, 2012 at 4:50 am
What if you removed SET ARITHABORT ON from the query?
April 10, 2012 at 12:57 am
Charmer (4/6/2012)
Find where it tries to convert varchar into int data type with the help of break point....
You cannot debug a script component using breakpoints, unless SSIS 2012 is used.
April 10, 2012 at 12:54 am
Viewing 15 posts - 7,366 through 7,380 (of 11,678 total)