by Jan Eliasen <eliasen@[EMAIL PROTECTED]
>
Jan 13, 2008 at 10:07 PM
On Fri, 11 Jan 2008 07:21:04 -0800, Gurvinder
<Gurvinder@[EMAIL PROTECTED]
> wrote:
>I am inserting data from sql2005 to sql2004 sp4 . In my orchestration I
am
>picking up 1 record and use tranform (updategram) to insert record into
>sqlserver 2000.
>
>When Mesage come out, it is blank.
And you have tested this by sending the message to a file before you
send it to sql2000sp4?
Most likely, your map doesn't work.
So the file you get from sql2005, try sending it to a file. Just
create a send ****t that takes everything that comes in from that
receive ****t. Then test your map on that file. It probably doesn't
return anything (ie. the result is blank)... fix the map.
--
eliasen, representing himself and not the company he works for.
Private blog: http://blog.eliasen.dk
Private email: jan@[EMAIL PROTECTED]
