Viewing 15 posts - 11,641 through 11,655 (of 13,877 total)
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.
Here[/url] is a link to an article which will describe...
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
Koen (da-zero) (1/28/2011)
Phil Parkin (1/28/2011)
The power of Google is there for you as well as me, but since you're new I've done it for you, just this once. Check here.
The...
January 28, 2011 at 7:31 am
The power of Google is there for you as well as me, but since you're new I've done it for you, just this once. Check here.
January 28, 2011 at 7:14 am
Try removing the double quotes from your expression:
@[User::LopVariable]==@[User::IterlopVariable]
January 28, 2011 at 12:42 am
Are you running the package as yourself, or another user? It is good practice to use a UNC path to your file, rather than drive letters, as these are not...
January 27, 2011 at 9:15 am
I'm with Koen. There was no need for an SP - running the count query and assigning the result to an SSIS variable can all be done in a single...
January 26, 2011 at 8:54 am
Viewing 15 posts - 11,641 through 11,655 (of 13,877 total)