DTS Package in Sql Server 2005

Question

0.00/5 (No votes)

See more:

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

Posted 7-Jan-11 20:50pm

Nilesh More

Add a Solution

Comments

fjdiewornncalwe 8-Jan-11 13:17pm

Please don't bother mentioning that "it's urgent". That has no relevance to us, only you. In fact, many of the people who will provide you with the best answers will simply ignore your questions if they include a statement like that. Cheers.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

fjdiewornncalwe · Answer 1 · 2011-01-08T07:16:00

Solution 1

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.

Posted 8-Jan-11 7:16am

fjdiewornncalwe

Comments

Espen Harlinn 16-Jan-11 9:22am

5+ To the point - keep it simple :)