Help me to script a table including data

Im try to use SQL server 2000 and use Enterprise to cript a table

But my result is only table structure in the script (myfile.sql)

(something like "create table Tb1, column..") and not have any data in my table included.

how good it is if it can write some insert statement (depend on number of records existed).

Could I have any way to do it with MS SQLServer 2000?

Thank you much.

DongMT

Hi,

This is a SQL question and not related to SSIS. You will need to post this kind of questions in SQL Server Forums.
Anyways, here is a link which has answer for your query.
http://vyaskn.tripod.com/code.htm#inserts

Thanks