Viewing 15 posts - 4,381 through 4,395 (of 11,678 total)
In your table structure for Line you gave in your original post you specified LineID,PointA,PointB.
I don't see any RampID or PreRampID.
Please read the first link in my signature on how...
October 23, 2013 at 4:42 am
Check the execution log of Reporting Services.
It will detail how many seconds it did over retrieving the data and how many time it took to render the report itself.
October 23, 2013 at 3:55 am
What are the relationships by the way?
Which columns are related to each other?
October 23, 2013 at 3:53 am
Beatrix Kiddo (10/23/2013)
Koen Verbeeck (10/23/2013)
Even hardcore DBAs like Gail, Jeff and others have gaps in their knowledge.
I utterly refuse to believe this :-D.
Ask them about SSIS 🙂
October 23, 2013 at 3:37 am
I'd suggest you read up on how to join tables. You are referencing tables in your correlated subqueries who are aliased in another correlated subquery. This is not possible.
Example: in...
October 23, 2013 at 3:22 am
Your question isn't entirely clear, but I guess you can create a foreign key relationship.
October 23, 2013 at 3:18 am
I'm not a DBA, so I can't really answer on the accidental part.
However, the amount of knowledge on this site is indeed amazing, but don't let that scare you.
Don't forget...
October 23, 2013 at 3:14 am
Spoon, this rings a bell. Is there some open-source variant called Kettle?
I remember using that in college (quite some time ago :-))
October 22, 2013 at 2:19 pm
rockstar283 (10/22/2013)
Data viewer on the Green pipeline is showing me all the records before that particular erroneous record
Sure? It might also show all the records loaded into the first buffer...
October 22, 2013 at 1:55 pm
mario17 (10/22/2013)
I have some custom mapping to apply which has ~500 cases, does it worth to code it with CASE or probably I can do something more nicer, like use...
October 22, 2013 at 1:41 pm
rockstar283 (10/22/2013)
and also the data viewer on Green pipeline is telling me where the error is
And why is that, if I may ask?
October 22, 2013 at 1:40 pm
“all ETL tools should be tuned out of the box”
Right. I'm pretty sure a lot of SSIS packages out there use all of the default settings, but still get reasonable...
October 22, 2013 at 1:38 pm
rockstar283 (10/22/2013)
I checked it in the Data Viewer
I thought you said redirecting error rows didn't work?
October 22, 2013 at 1:19 pm
Try this:
"C:\\Folder1\\Folder2\\" + @[User::Site] + ".MDB"
I assume @[User::Site] is a string variable?
October 22, 2013 at 1:18 pm
Viewing 15 posts - 4,381 through 4,395 (of 11,678 total)