Copy many items (V9)

[jymm]

hey gang - need a way to copy many inventory items.

SO - much like when you go into Cards-Inventory and you enter a new item number then hit the copy button to copy another item --- this option takes in all of the price lists (etc) which is the feature I REALLY like.

if there is a way in T-SQL to call their stored procedure and pass the 'CopyFrom' and the 'CopyTo' I would be a very happy camper...

example
'Copy From' 'Copy To'
001-50 001-40
001-50 001-EA
...

ideas?

 

[jazgeek]

integration manager would be your best bet

-----------
and they wonder why they call it Great Pains!

jaz

 

[jymm]

with all of the pricing things under each item - integration manager would be a pain in this case - any other ideas?

 

[Dukester0122]

Try using DTS or Integration Services(SQL 2005). Create a new view which you would join all inventory tables including pricing, quantity,etc. then use this to transfer the data to the new table. While in DTS try using the 'Transform' function it might help with.