DTS how make our own?

How to make our own DTS package I have to split the data on my own.. Data is very biig almost 30 to 40 million. I need to splitt them into 10k chunks in database and with my desired table name.
Waiting for a +tive reply.
Regards
Shani ;)Using DTS wizard you can design the DTS package and save with password for your use only.

And also you can import data based on conditional requirements.
What is the condition for those 10K chunks?|||Originally posted by Satya
Using DTS wizard you can design the DTS package and save with password for your use only.

And also you can import data based on conditional requirements.
What is the condition for those 10K chunks?

Hi,

I have Database of 4.2million Email address. I am now splitting records into a new database. Now what I want is that Thorugh a trigger or something else SQL server should split up the one table that has 4.2 email address into 10,000 records in every new new table, going again and again to DTS wizard is very difficult do u have anu other solution to this problem.

Regards
Shani ;)|||So let me be sure I understand... You want us to help you to help your customers SPAM us?

-PatP|||Originally posted by Pat Phelan
So let me be sure I understand... You want us to help you to help your customers SPAM us?

-PatP

na na na email is just an example... its cc info of people who have purchased with us and their contact info its not online it is our local outlet system.... for a chain of stores... why do u take evrything to spam|||Refer to this link (http://www.1sqlstreet.com/vb/scripts/ShowCode.asp?txtCodeId=819&lngWId=5) to get nth record from a table and use normal [INSERT INTO... SELECT] to export to new table depending upon your ability.

Refer to books online for other stuff and syntax.

HTH|||Originally posted by shani
why do u take evrything to spam Because I get SO blasted much of the stuff, because databases are a key component to generating SPAM, and because your question is one that frequently appears from address harvestors trying to clean and resell their lists. It may be a coincidence, but you've certainly hit a "hot button" with me!

-PatP