Viewing 15 posts - 11,626 through 11,640 (of 13,870 total)
So, in effect, you're trying to build a file-status table in memory and then issue a single commit at the end of package execution to write it to disk?
February 9, 2011 at 2:57 am
Koen (da-zero) (2/9/2011)
Stringzz (2/8/2011)
February 9, 2011 at 1:01 am
I agree, this seems puzzling. Is there anything in the Event Log?
February 8, 2011 at 10:18 am
Could this be relevant?
February 8, 2011 at 9:57 am
ranganathanmca (2/8/2011)
How to fetch 3 differente(excel,csv,flatfile..) file in single source control ? any possibilites to do that?
please share some...
February 8, 2011 at 7:41 am
I suggest that you learn - it is a better tool to use in this situation.
Do you have SSIS installed on the machine you are doing this?
February 3, 2011 at 8:46 am
Is there any reason why you are not using SQL Agent to run the package?
February 3, 2011 at 8:12 am
parulpriya10 (2/3/2011)
I tell u one thing shut ur mouth and control hands (writing).if u cant no need to anything to anybody...some people are so disgusting...
For the benefit of any others...
February 3, 2011 at 6:02 am
Most people here pick things up pretty quick.
Using a thesaurus to say the same thing in several hundred ways isn't going to impress anyone.
February 3, 2011 at 5:45 am
Although I agree with you, did you notice that it's his/her first forum post?
Maybe when they get to 30 or 40 posts, you can start slamming them for any dumb...
February 3, 2011 at 5:19 am
That's better. You can do that using a subquery - something like this (untested):
SELECT
t2.SumGross,
t.BOOKING_ID,
t.KL_EQUIPMENT_TYPE_CD,
etc etc
FROM tablename t
JOIN
(select t1.Booking_ID, Sum(t1.Gross_Wgt) SumGross
from tablename t1
group by t1.Booking_ID) t2
on t.Booking_ID...
February 3, 2011 at 4:55 am
Probably.
But unless you provide a better description of what you are trying to achieve, that's the best answer I can provide.
February 3, 2011 at 4:09 am
Stringzz (2/1/2011)
Thanks Phil, I actually had a lightbulb go off before I saw your post, but you would have directed to the correct solution if I hadn't figured it out.
Haha,...
February 1, 2011 at 9:44 am
Stringzz (2/1/2011)
February 1, 2011 at 9:36 am
You'd be wise not to mention the 'c' word in this forum 🙂
Have you tried SELECT ... rather than RETURN?
February 1, 2011 at 9:30 am
Viewing 15 posts - 11,626 through 11,640 (of 13,870 total)