Viewing 15 posts - 121 through 135 (of 184 total)
Have practically same problem.
I have a dts package running just fine.
When I schedule it (right click in local packages) every time it runs i get an error. It doesn't find...
January 5, 2006 at 12:46 am
January 3, 2006 at 8:27 am
Many thx guys.
Will be cheaper 😉
What's the big difference then ?
Best regards
J
January 3, 2006 at 2:28 am
Hi guys
That query was for the head of the orders. Now I have to change the orderlines 😉
This is the query :
update vl1
set vl1.mttht = vl2.mttht*-1,
vl1.mtnhtl = vl2.mtnhtl*-1
from vligven...
December 2, 2005 at 6:38 am
ok, this one works 🙂
use sn
update ventven
set ventven.mtht = vv2.mtht,
ventven.mthtsp = vv2. mthtsp,
ventven.mthtax = vv2.mthtax,
ventven.mttva = vv2.mttva,
ventven.mtttc = vv2.mtttc,
ventven.netrem = vv2.netrem,
ventven.mthtre = vv2.mthtre,
ventven.netesc = vv2.netesc,
ventven.mosoco...
November 30, 2005 at 6:05 am
(0 row(s) affected) is the result. This should be 167 rows.
November 30, 2005 at 5:53 am
I can parse this one :
update ventven
set ventven.mtht = vv2.mtht,
ventven.mthtsp = vv2. mthtsp,
ventven.mthtax = vv2.mthtax,
ventven.mttva = vv2.mttva,
ventven.mtttc = vv2.mtttc,
ventven.netrem = vv2.netrem,
ventven.mthtre = vv2.mthtre,
ventven.netesc = vv2.netesc,
ventven.mosoco...
November 30, 2005 at 5:51 am
Kenneth
Thx I receive next error :
Server: Msg 156, Level 15, State 1, Line 2
Incorrect syntax near the keyword 'as'.
November 30, 2005 at 5:41 am
ok, i have narrowed the problem.
I can't select the toerok table.
This is a excel file that has been imported with dts.
When I open the table I have the data
November 16, 2005 at 4:52 am
Kenneth
thx for yr quick response
Done that. Even placed database in front of it.
UPDATE ventven
SET priori = toer
FROM epp.dbo.TOEROK INNER JOIN epp.dbo.ventven
ON nomat = ship
WHERE codaff...
November 16, 2005 at 3:01 am
Sorry, could post the stored procudure, but it will take about 30 pages i guess. But no offense. Result is erverything.
Thx in advance
October 19, 2005 at 8:49 am
I've killed the translation between source and destination and created it manually.
That did it.
September 19, 2005 at 7:26 am
Already solved it.
Thx.
September 19, 2005 at 7:15 am
The number of failing rows exceeds the maximum specified.
Conersion error. Destination overflowed on column pair 1.
Source column Coll001, destinationcolumn fld_ru_pt_id
Which is very strange because this isn't a link in the...
September 19, 2005 at 7:10 am
Viewing 15 posts - 121 through 135 (of 184 total)