original data
PART NAME SUPPLIER LINE ADBALTYD40EKL-LG-C ADBALTYD40EKL-LG-D ADBALTYD40EKL-LG-F
48420EB71A PAD ASSY-HORN D023 6666 0 0 0
48420EB71C PAD ASSY-HORN D023 6666 0 0 0
48420EB71D PAD ASSY-HORN D023 6666 1 1 1
48430EB73C BODY ASSY-AIR BAG ST D023 6666 0 0 0
48430EB74A BODY ASSY-AIR BAG ST D023 6666 0 0 0
48430EB74C BODY ASSY-AIR BAG ST D023 6666 0 0 0
48430EB75A BODY ASSY-AIR BAG ST D023 6666 0 0 0
48430EB75D BODY ASSY-AIR BAG ST D023 6666 1 1 1
48430EB76D BODY ASSY-AIR BAG ST D023 6666 0 0 0
after convert to pivot by manual task , how can i do by use ssis(2005) or dts(2000) ?
ModelNo PART NAME SUPPLIER LINE UsageQty
ADBALTYD40EKL-LG-C 0060320470 RIVET-BLIND,RD HD,OP 6000 6666 2
ADBALTYD40EKL-LG-C 0092310810 PIN-SNAP 6000 6666 2
ADBALTYD40EKL-LG-C 0111100182 BOLT M10 6000 6666 1
ADBALTYD40EKL-LG-C 01111S251E BOLT-HEX HD 6000 6666 3
ADBALTYD40EKL-LG-C 0112100022 BOLT-HEX HD WITH WAS 6000 6666 4
ADBALTYD40EKL-LG-C 0112100772 BOLT-HEX HD W/WASH 6000 6666 9
ADBALTYD40EKL-LG-C 011210084U BOLT-HEX HD W/CSW M1 6000 6666 0
ADBALTYD40EKL-LG-C 0112101601 BOLT-HEX HD,W/WASH 6000 6666 0
ADBALTYD40EKL-LG-C 0112103181 BOLT-HEX HD,PILOT PT 6000 6666 3
ADBALTYD40EKL-LG-C 0112106561 BOLT-HEX HD,PP W/WAS 6000 6666 6
ADBALTYD40EKL-LG-C 0112106671 BOLT-HEX HD,PILOT PT 6000 6666 3
ADBALTYD40EKL-LG-C 0112107251 BOLT-HEX HD,PP W/WAS 6000 6666 9
ADBALTYD40EKL-LG-C 0112107261 SCR-HEX HD,PP W/PW 6000 6666 4
.... .... .... .... .... ....
