DTS stands for Data Transformation Services. It is available under the SQL
2000 Enterprise Manager user interface. (I used to know right where to look
but that info got pushed out of my brain when SQL 2005 came along, sorry). It
is one of the nodes. Just keep expanding the '+' signs until you find it.

Once you find it, right click and select "New Package" or figure out how to
create a new DTS Package. (Stay away from 'Meta Data Packages' which are no
longer supported in future versions.) On the package design surface, you will
need two connections, one being the 'flat file' or CSV, and one being SQL.
Once you have those, create a 'data pump' to move data from one to the other.

I appologize that these instructions are real generic but I have not worked
with SQL 2000 for 3 years. If there is anybody out there that can give more
detailed instructions to our roiginal poster, please chime in.

Once you have your DTS Package created, saved, and tested, go down to the
SQL Server Agent node. Find the Jobs node and right click there and select
New Job. Again, I can't remember how the setup is for SQL 2000 but there is a
way to create a job that will run a DTS Package. And with any job in SQL
Agent, it can be set to run on a variety of schedules.

You will have to poke around and experience a steep learning curve on this
one.

Keep us posted.
--
Todd C

"sac" wrote:

DTS stands for Data Transformation Services. It is available under the SQL
2000 Enterprise Manager user interface. (I used to know right where to look
but that info got pushed out of my brain when SQL 2005 came along, sorry). It
is one of the nodes. Just keep expanding the '+' signs until you find it.

Once you find it, right click and select "New Package" or figure out how to
create a new DTS Package. (Stay away from 'Meta Data Packages' which are no
longer supported in future versions.) On the package design surface, you will
need two connections, one being the 'flat file' or CSV, and one being SQL.
Once you have those, create a 'data pump' to move data from one to the other.

I appologize that these instructions are real generic but I have not worked
with SQL 2000 for 3 years. If there is anybody out there that can give more
detailed instructions to our roiginal poster, please chime in.

Once you have your DTS Package created, saved, and tested, go down to the
SQL Server Agent node. Find the Jobs node and right click there and select
New Job. Again, I can't remember how the setup is for SQL 2000 but there is a
way to create a job that will run a DTS Package. And with any job in SQL
Agent, it can be set to run on a variety of schedules.

You will have to poke around and experience a steep learning curve on this
one.

Keep us posted.
--
Todd C

"sac" wrote:

DTS stands for Data Transformation Services. It is available under the SQL
2000 Enterprise Manager user interface. (I used to know right where to look
but that info got pushed out of my brain when SQL 2005 came along, sorry). It
is one of the nodes. Just keep expanding the '+' signs until you find it.

Once you find it, right click and select "New Package" or figure out how to
create a new DTS Package. (Stay away from 'Meta Data Packages' which are no
longer supported in future versions.) On the package design surface, you will
need two connections, one being the 'flat file' or CSV, and one being SQL.
Once you have those, create a 'data pump' to move data from one to the other.

I appologize that these instructions are real generic but I have not worked
with SQL 2000 for 3 years. If there is anybody out there that can give more
detailed instructions to our roiginal poster, please chime in.

Once you have your DTS Package created, saved, and tested, go down to the
SQL Server Agent node. Find the Jobs node and right click there and select
New Job. Again, I can't remember how the setup is for SQL 2000 but there is a
way to create a job that will run a DTS Package. And with any job in SQL
Agent, it can be set to run on a variety of schedules.

You will have to poke around and experience a steep learning curve on this
one.

Keep us posted.
--
Todd C

"sac" wrote:

DTS stands for Data Transformation Services. It is available under the SQL
2000 Enterprise Manager user interface. (I used to know right where to look
but that info got pushed out of my brain when SQL 2005 came along, sorry). It
is one of the nodes. Just keep expanding the '+' signs until you find it.

Once you find it, right click and select "New Package" or figure out how to
create a new DTS Package. (Stay away from 'Meta Data Packages' which are no
longer supported in future versions.) On the package design surface, you will
need two connections, one being the 'flat file' or CSV, and one being SQL.
Once you have those, create a 'data pump' to move data from one to the other.

I appologize that these instructions are real generic but I have not worked
with SQL 2000 for 3 years. If there is anybody out there that can give more
detailed instructions to our roiginal poster, please chime in.

Once you have your DTS Package created, saved, and tested, go down to the
SQL Server Agent node. Find the Jobs node and right click there and select
New Job. Again, I can't remember how the setup is for SQL 2000 but there is a
way to create a job that will run a DTS Package. And with any job in SQL
Agent, it can be set to run on a variety of schedules.

You will have to poke around and experience a steep learning curve on this
one.

Keep us posted.
--
Todd C

"sac" wrote:

DTS stands for Data Transformation Services. It is available under the SQL
2000 Enterprise Manager user interface. (I used to know right where to look
but that info got pushed out of my brain when SQL 2005 came along, sorry). It
is one of the nodes. Just keep expanding the '+' signs until you find it.

Once you find it, right click and select "New Package" or figure out how to
create a new DTS Package. (Stay away from 'Meta Data Packages' which are no
longer supported in future versions.) On the package design surface, you will
need two connections, one being the 'flat file' or CSV, and one being SQL.
Once you have those, create a 'data pump' to move data from one to the other.

I appologize that these instructions are real generic but I have not worked
with SQL 2000 for 3 years. If there is anybody out there that can give more
detailed instructions to our roiginal poster, please chime in.

Once you have your DTS Package created, saved, and tested, go down to the
SQL Server Agent node. Find the Jobs node and right click there and select
New Job. Again, I can't remember how the setup is for SQL 2000 but there is a
way to create a job that will run a DTS Package. And with any job in SQL
Agent, it can be set to run on a variety of schedules.

You will have to poke around and experience a steep learning curve on this
one.

Keep us posted.
--
Todd C

"sac" wrote: