Sql Server 2005中的DTS包 [英] DTS Package in Sql Server 2005

问题描述

我想在交易中插入数据，但条件是
1)有些交易商通过交易表(SaleEntry表)中的TSI(地区销售费用)指示了特定月份的数据，我现在提供一个销售条目表格(在网格视图(Dev Expres网格)中)，现在我输入了四月至十一月月

2)如果TSI想要输入过去一个月的数据，例如12月输入的5月或6月数据，那么如果交易表中没有经销商，我必须在过去一个月的所有产品中插入0(零). />
3)有85000个经销商对于他们，我要插入数据经销商Tabele不同(MDealer)，交易表不同(MTmpSale)

4)如果经销商是在5月创建的，那么它不适用于4月进入，依此类推，我正在Mdealer表(经销商主)中创建的经销商中检查此创建.

任何人都可以帮我这个忙，这是一次事务处理表中的绝缘.从4月到11月，当我在网上发现很多人为此目的使用SQL SERVER 2005的DTS包

我不知道如何创建任何身体帮助meplz.它的紧急

I want to Insert Data in my Transaction but the Condition is that
1)There are dealers whose data is insteted for the particular month by TSI(Territory Sale Incharge)in Transaction table(SaleEntry Table) i am providing one Sale Entry Form (In Grid View(Dev Expres Grid)) now i entered the data for Aprial To November month

2)IF TSI Want to entered the data for past month like in the december entered data for May Or June for that i have to inserted 0(Zero) for all product to all past month if the dealer is not availabe in Transaction Table

3) The are 85000 dealer For them i want to inserted data Dealer Tabele is different(MDealer) and Transction Table is(MTmpSale)

4)If Dealer created in May Then Its not available for April Entry and so on i am checking this creation on dealer created coloumn in Mdealer Table(Dealer Master)

Can any body help me for this, This is one time Inseration in Transaction table From Apr To Nov When i find on net many say for this purpose use DTS Package of SQL SERVER 2005

i don''t have idea how o create it any body help meplz. its urgent

推荐答案

如果它是一次性进程，只需编写一个sql脚本并执行它.您可以在DTS中执行的任何操作都可以在独立脚本中执行.那时DTS包的唯一目的是可以将其安排为多次运行，在这种情况下使其变得多余.

If it is a one time process, just write a sql script and execute that. Anything you can do in a DTS you can do in a standalone script. The only purpose of the DTS package at that point is that it can be scheduled for multiple runs, which in the case makes it redundant.

这篇关于Sql Server 2005中的DTS包的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！