SQL Server 2005 Integration Service 专家教程 例程代码文件

1,1,2001-05-31 00:00:00,4,1,50.26,201.04,3.00,.00,3.00,2001-05-24 00:00:00 2,2,2001-05-31 00:00:00,3,359,45.12,135.36,3.00,.00,3.00,2001-05-24 00:00:00 2,3,2001-05-31 00:00:00,3,360,45.5805,136.7415,3.00,.00,3.00,2001-05-24 00:00:00 3,4,2001-05-31 00:00:00,550,530,16.086,8847.3,550.00,.00,550.00,2001-05-24 00:00:00 4,5,2001-05-31 00:00:00,3,4,57.0255,171.0765,2.00,1.00,1.00,2001-05-24 00:00:00 5,6,2001-06-14 00:00:00,550,512,37.086,20397.3,550.00,.00,550.00,2001-06-07 00:00:00 6,7,2001-06-14 00:00:00,550,513,26.5965,14628.075,468.00,.00,468.00,2001-06-07 00:00:00 7,8,2001-06-14 00:00:00,550,317,27.0585,14882.175,550.00,.00,550.00,2001-06-07 00:00:00 7,9,2001-06-14 00:00:00,550,318,33.579,18468.45,550.00,.00,550.00,2001-06-07 00:00:00 7,10,2001-06-14 00:00:00,550,319,46.0635,25334.925,550.00,.00,550.00,2001-06-07 00:00:00 8,11,2001-06-14 00:00:00,3,403,47.4705,142.4115,3.00,.00,3.00,2001-06-07 00:00:00 8,12,2001-06-14 00:00:00,3,404,45.3705,136.1115,3.00,.00,3.00,2001-06-07 00:00:00 8,13,2001-06-14 00:00:00,3,405,49.644,148.932,3.00,.00,3.00,2001-06-07 00:00:00 8,14,2001-06-14 00:00:00,3,406,45.3705,136.1115,3.00,.00,3.00,2001-06-07 00:00:00 8,15,2001-06-14 00:00:00,3,407,43.2705,129.8115,3.00,.00,3.00,2001-06-07 00:00:00 9,16,2002-01-28 00:00:00,3,422,47.523,142.569,3.00,.00,3.00,2002-01-21 00:00:00 9,17,2002-01-28 00:00:00,3,423,45.423,136.269,3.00,.00,3.00,2002-01-21 00:00:00 9,18,2002-01-28 00:00:00,3,424,49.6965,149.0895,3.00,.00,3.00,2002-01-21 00:00:00 9,19,2002-01-28 00:00:00,3,425,45.423,136.269,3.00,.00,3.00,2002-01-21 00:00:00 9,20,2002-01-28 00:00:00,3,426,43.323,129.969,3.00,.00,3.00,2002-01-21 00:00:00 10,21,2002-01-28 00:00:00,3,320,47.4705,142.4115,3.00,.00,3.00,2002-01-21 00:00:00 10,22,2002-01-28 00:00:00,3,321,42.798,128.394,3.00,.00,3.00,2002-01-21 00:00:00 10,23,2002-01-28 00:00:00,60,322,25.4205,1525.23,60.00,.00,60.00,2002-01-21 00:00:00 11,24,2002-01-28 00:00:00,3,438,41.223,123.669,3.00,.00,3.00,2002-01-21 00:00:00 11,25,2002-01-28 00:00:00,3,439,45.4965,136.4895,3.00,.00,3.00,2002-01-21 00:00:00 11,26,2002-01-28 00:00:00,3,440,41.223,123.669,3.00,.00,3.00,2002-01-21 00:00:00 11,27,2002-01-28 00:00:00,3,441,39.123,117.369,3.00,.00,3.00,2002-01-21 00:00:00 12,28,2002-01-28 00:00:00,550,941,62.9895,34644.225,550.00,82.00,468.00,2002-01-21 00:00:00 13,29,2002-01-28 00:00:00,3,320,45.3705,136.1115,3.00,.00,3.00,2002-01-21 00:00:00 13,30,2002-01-28 00:00:00,3,321,40.488,121.464,3.00,.00,3.00,2002-01-21 00:00:00 13,31,2002-01-28 00:00:00,60,322,26.3655,1581.93,60.00,.00,60.00,2002-01-21 00:00:00 14,32,2002-01-28 00:00:00,3,504,48.762,146.286,3.00,3.00,.00,2002-01-21 00:00:00 15,33,2002-01-28 00:00:00,3,497,34.188,102.564,3.00,.00,3.00,2002-01-21 00:00:00 16,34,2002-01-28 00:00:00,3,323,50.2635,150.7905,3.00,.00,3.00,2002-01-21 00:00:00 17,35,2002-01-29 00:00:00,550,523,10.731,5902.05,550.00,.00,550.00,2002-01-22 00:00:00 17,36,2002-01-29 00:00:00,550,524,14.1225,7767.375,550.00,.00,550.00,2002-01-22 00:00:00 18,37,2002-01-29 00:00:00,60,492,50.2635,3015.81,60.00,.00,60.00,2002-01-22 00:00:00 18,38,2002-01-29 00:00:00,60,493,57.1515,3429.09,60.00,.00,60.00,2002-01-22 00:00:00 18,39,2002-01-29 00:00:00,60,494,53.2035,3192.21,60.00,.00,60.00,2002-01-22 00:00:00 18,40,2002-01-29 00:00:00,60,495,63.693,3821.58,60.00,.00,60.00,2002-01-22 00:00:00 18,41,2002-01-29 00:00:00,60,496,48.909,2934.54,60.00,.00,60.00,2002-01-22 00:00:00 19,42,2002-01-29 00:00:00,550,908,21.0945,11601.975,550.00,.00,550.00,2002-01-22 00:00:00 19,43,2002-01-29 00:00:00,550,909,30.4395,16741.725,550.00,.00,550.00,2002-01-22 00:00:00 19,44,2002-01-29 00:00:00,550,910,40.9395,22516.725,550.00,.00,550.00,2002-01-22 00:00:00 19,45,2002-01-29 00:00:00,550,911,21.0945,11601.975,550.00,.00,550.00,2002-01-22 00:00:00 19,46,2002-01-29 00:00:00,550,912,30.4395,16741.725,550.00,.00,550.00,2002-01-22 00:00:00 20,47,2002-01-29 00:00:00,60,506,9.198,551.88,60.00,.00,60.00,2002-01-22 00:00:00 21,48,2002-01-29 00:00:00,550,351,5.775,3176.25,550.00,.00,550.00,2002-01-22 00:00:00 21,49,2002-01-29 00:00:00,550,352,1.155,635.25,550.00,.00,550.00,2002-01-22 00:00:00 21,50,2002-01-29 00:00:00,550,679,5.775,3176.25,550.00,27.00,523.00,2002-01-22 00:00:00 22,51,2002-01-29 00:00:00,550,507,23.394,12866.7,550.00,82.00,468.00,2002-01-22 00:00:00 22,52,2002-01-29 00:00:00,550,508,27.6465,15205.575,550.00,.00,550.00,2002-01-22 00:00:00 23,53,2002-01-29 00:00:00,550,355,1.365,750.75,550.00,.00,550.00,2002-01-22 00:00:00 23,54,2002-01-29 00:00:00,550,940,62.9895,34644.225,550.00,.00,550.00,2002-01-22 00:00:00 23,55,2002-01-29 00:00:00,550,535,3.486,1917.3,550.00,.00,550.00,2002-01-22 00:00:00 24,56,2002-01-29 00:00:00,550,351,6.195,3407.25,550.00,550.00,.00,2002-01-22 00:00:00 24,57,2002-01-29 00:00:00,550,352,1.47,808.5,550.00,550.00,.00,2002-01-22 00:00:00 25,58,2002-01-29 00:00:00,550,507,22.1655,12191.025,550.00,.00,550.00,2002-01-22 00:00:00 25,59,2002-01-29 00:00:00,550,508,29.2845,16106.475,523.00,.00,523.00,2002-01-22 00:00:00 26,60,2002-01-29 00:00:00,3,491,19.9815,59.9445,3.00,.00,3.00,2002-01-22 00:00:00 27,61,2002-01-29 00:00:00,3,341,41.1705,123.5115,3.00,.00,3.00,2002-01-22 00:00:00 27,62,2002-01-29 00:00:00,3,342,39.0705,117.2115,3.00,.00,3.00,2002-01-22 00:00:00 27,63,2002-01-29 00:00:00,3,343,43.344,130.032,3.00,.00,3.00,2002-01-22 00:00:00 27,64,2002-01-29 00:00:00,3,344,39.0705,117.2115,3.00,.00,3.00,2002-01-22 00:00:00 27,65,2002-01-29 00:00:00,3,345,36.9705,110.9115,3.00,.00,3.00,2002-01-22 00:00:00 27,66,2002-01-29 00:00:00,3,346,41.244,123.732,3.00,.00,3.00,2002-01-22 00:00:00 28,67,2002-01-29 00:00:00,550,935,31.4895,17319.225,550.00,.00,550.00,2002-01-22 00:00:00 28,68,2002-01-29 00:00:00,550,936,48.2895,26559.225,550.00,.00,550.00,2002-01-22 00:00:00 29,69,2002-02-22 00:00:00,3,375,43.344,130.032,3.00,.00,3.00,2002-02-15 00:00:00 29,70,2002-02-22 00:00:00,3,376,39.0705,117.2115,3.00,.00,3.00,2002-02-15 00:00:00 29,71,2002-02-22 00:00:00,3,377,36.9705,110.9115,3.00,.00,3.00,2002-02-15 00:00:00 29,72,2002-02-22 00:00:00,3,378,41.244,123.732,3.00,.00,3.00,2002-02-15 00:00:00 29,73,2002-02-22 00:00:00,3,379,36.9705,110.9115,3.00,.00,3.00,2002-02-15 00:00:00 30,74,2002-02-22 00:00:00,550,476,15.8865,8737.575,550.00,.00,550.00,2002-02-15 00:00:00 30,75,2002-02-22 00:00:00,550,477,11.6655,6416.025,550.00,55.00,495.00,2002-02-15 00:00:00 30,76,2002-02-22 00:00:00,550,478,11.088,6098.4,550.00,.00,550.00,2002-02-15 00:00:00 31,77,2002-02-22 00:00:00,3,402,47.4705,142.4115,3.00,.00,3.00,2002-02-15 00:00:00 32,78,2002-02-22 00:00:00,550,510,23.079,12693.45,550.00,82.00,468.00,2002-02-15 00:00:00 32,79,2002-02-22 00:00:00,550,511,29.274,16100.7,550.00,.00,550.00,2002-02-15 00:00:00 33,80,2002-03-02 00:00:00,3,403,45.3705,136.1115,3.00,.00,3.00,2002-02-23 00:00:00 33,81,2002-03-02 00:00:00,3,404,49.644,148.932,3.00,.00,3.00,2002-02-23 00:00:00 33,82,2002-03-02 00:00:00,3,405,45.3705,136.1115,3.00,.00,3.00,2002-02-23 00:00:00 34,83,2002-03-02 00:00:00,550,525,2.3205,1276.275,550.00,550.00,.00,2002-02-23 00:00:00 35,84,2002-03-02 00:00:00,550,526,3.6435,2003.925,550.00,.00,550.00,2002-02-23 00:00:00 36,85,2002-03-02 00:00:00,550,908,21.0945,11601.975,468.00,.00,468.00,2002-02-23 00:00:00 36,86,2002-03-02 00:00:00,550,909,30.4395,16741.725,550.00,.00,550.00,2002-02-23 00:00:00 36,87,2002-03-02 00:00:00,550,913,40.9395,22516.725,550.00,.00,550.00,2002-02-23 00:00:00 37,88,2002-03-02 00:00:00,60,356,3.6015,216.09,60.00,.00,60.00,2002-02-23 00:00:00 37,89,2002-03-02 00:00:00,60,357,3.9795,238.77,60.00,.00,60.00,2002-02-23 00:00:00 38,90,2002-03-02 00:00:00,550,935,31.4895,17319.225,550.00,.00,550.00,2002-02-23 00:00:00 38,91,2002-03-02 00:00:00,550,936,48.2895,26559.225,550.00,.00,550.00,2002-02-23 00:00:00 39,92,2002-03-02 00:00:00,550,524,12.9675,7132.125,550.00,.00,550.00,2002-02-23 00:00:00 40,93,2002-03-02 00:00:00,550,911,21.0945,11601.975,550.00,.00,550.00,2002-02-23 00:00:00 40,94,2002-03-0