Results 1 to 7 of 7
  1. #1
    Join Date
    Sep 2003
    Location
    Pakistan, Karachi
    Posts
    22

    Angry Unanswered: 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

  2. #2
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    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?
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  3. #3
    Join Date
    Sep 2003
    Location
    Pakistan, Karachi
    Posts
    22
    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

  4. #4
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    So let me be sure I understand... You want us to help you to help your customers SPAM us???

    -PatP

  5. #5
    Join Date
    Sep 2003
    Location
    Pakistan, Karachi
    Posts
    22
    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

  6. #6
    Join Date
    Aug 2002
    Location
    Scotland
    Posts
    1,578
    Refer to this link 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
    --Satya SKJ
    Microsoft SQL Server MVP
    [IMG]http://sqlserver-qa.net/google_bart.gif[/IMG]

  7. #7
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •