DTS copy file and clear first line

#1

Hi,

I am very new to DTS and am currently still working with SQL Server 2000.

I have two problems:

1. I need to copy a file with a daily changing name from one server to
another. The file is date stamped. However, the first part of the file is
constant ('THSNUREF - constant part) and then ('2008-11-21-07-38-38.csv' -
changing).
I have been looking around for a couple of days and got some hints on how to
do it but I cannot make it work with my experince.

After the file transfer I need to:

2. delete the first row in the file as it contains data about when the file
was created. The second row contains the column headers and the rest is the
data.

Basically I am trying to copy the file, clean it up and then import it into
the database from where I stage it und update the live table. I can manually
process the file and copy it, rename it to a constant name and strip the
first row but that takes a long time and I have to do it for several
different files. And because the file has more than 65k rows I have to do
everything via access.

I would really appreciate any help from anyone.

Thanks

#2

Any takers?

DrDude wrote:

Quote:

Hi,

I am very new to DTS and am currently still working with SQL Server 2000.

I have two problems:

1. I need to copy a file with a daily changing name from one server to
another. The file is date stamped. However, the first part of the file is
constant ('THSNUREF - constant part) and then ('2008-11-21-07-38-38.csv' -
changing).
I have been looking around for a couple of days and got some hints on how to
do it but I cannot make it work with my experince.

After the file transfer I need to:

2. delete the first row in the file as it contains data about when the file
was created. The second row contains the column headers and the rest is the
data.

Basically I am trying to copy the file, clean it up and then import it into
the database from where I stage it und update the live table. I can manually
process the file and copy it, rename it to a constant name and strip the
first row but that takes a long time and I have to do it for several
different files. And because the file has more than 65k rows I have to do
everything via access.

I would really appreciate any help from anyone.

Thanks

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200812/1

#3

Any takers?

DrDude wrote:

Quote:

Hi,

I am very new to DTS and am currently still working with SQL Server 2000.

I have two problems:

1. I need to copy a file with a daily changing name from one server to
another. The file is date stamped. However, the first part of the file is
constant ('THSNUREF - constant part) and then ('2008-11-21-07-38-38.csv' -
changing).
I have been looking around for a couple of days and got some hints on how to
do it but I cannot make it work with my experince.

After the file transfer I need to:

2. delete the first row in the file as it contains data about when the file
was created. The second row contains the column headers and the rest is the
data.

Basically I am trying to copy the file, clean it up and then import it into
the database from where I stage it und update the live table. I can manually
process the file and copy it, rename it to a constant name and strip the
first row but that takes a long time and I have to do it for several
different files. And because the file has more than 65k rows I have to do
everything via access.

I would really appreciate any help from anyone.

Thanks

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200812/1

#4

Any takers?

DrDude wrote:

Quote:

Hi,

I am very new to DTS and am currently still working with SQL Server 2000.

I have two problems:

1. I need to copy a file with a daily changing name from one server to
another. The file is date stamped. However, the first part of the file is
constant ('THSNUREF - constant part) and then ('2008-11-21-07-38-38.csv' -
changing).
I have been looking around for a couple of days and got some hints on how to
do it but I cannot make it work with my experince.

After the file transfer I need to:

2. delete the first row in the file as it contains data about when the file
was created. The second row contains the column headers and the rest is the
data.

Basically I am trying to copy the file, clean it up and then import it into
the database from where I stage it und update the live table. I can manually
process the file and copy it, rename it to a constant name and strip the
first row but that takes a long time and I have to do it for several
different files. And because the file has more than 65k rows I have to do
everything via access.

I would really appreciate any help from anyone.

Thanks

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200812/1

#5

Any takers?

DrDude wrote:

Quote:

Hi,

I am very new to DTS and am currently still working with SQL Server 2000.

I have two problems:

1. I need to copy a file with a daily changing name from one server to
another. The file is date stamped. However, the first part of the file is
constant ('THSNUREF - constant part) and then ('2008-11-21-07-38-38.csv' -
changing).
I have been looking around for a couple of days and got some hints on how to
do it but I cannot make it work with my experince.

After the file transfer I need to:

2. delete the first row in the file as it contains data about when the file
was created. The second row contains the column headers and the rest is the
data.

Basically I am trying to copy the file, clean it up and then import it into
the database from where I stage it und update the live table. I can manually
process the file and copy it, rename it to a constant name and strip the
first row but that takes a long time and I have to do it for several
different files. And because the file has more than 65k rows I have to do
everything via access.

I would really appreciate any help from anyone.

Thanks

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200812/1

#6

Any takers?

DrDude wrote:

Quote:

Hi,

I am very new to DTS and am currently still working with SQL Server 2000.

I have two problems:

1. I need to copy a file with a daily changing name from one server to
another. The file is date stamped. However, the first part of the file is
constant ('THSNUREF - constant part) and then ('2008-11-21-07-38-38.csv' -
changing).
I have been looking around for a couple of days and got some hints on how to
do it but I cannot make it work with my experince.

After the file transfer I need to:

2. delete the first row in the file as it contains data about when the file
was created. The second row contains the column headers and the rest is the
data.

Basically I am trying to copy the file, clean it up and then import it into
the database from where I stage it und update the live table. I can manually
process the file and copy it, rename it to a constant name and strip the
first row but that takes a long time and I have to do it for several
different files. And because the file has more than 65k rows I have to do
everything via access.

I would really appreciate any help from anyone.

Thanks

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200812/1

#7

Any takers?

DrDude wrote:

Quote:

Hi,

I am very new to DTS and am currently still working with SQL Server 2000.

I have two problems:

1. I need to copy a file with a daily changing name from one server to
another. The file is date stamped. However, the first part of the file is
constant ('THSNUREF - constant part) and then ('2008-11-21-07-38-38.csv' -
changing).
I have been looking around for a couple of days and got some hints on how to
do it but I cannot make it work with my experince.

After the file transfer I need to:

2. delete the first row in the file as it contains data about when the file
was created. The second row contains the column headers and the rest is the
data.

Basically I am trying to copy the file, clean it up and then import it into
the database from where I stage it und update the live table. I can manually
process the file and copy it, rename it to a constant name and strip the
first row but that takes a long time and I have to do it for several
different files. And because the file has more than 65k rows I have to do
everything via access.

I would really appreciate any help from anyone.

Thanks

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200812/1

#8

Any takers?

DrDude wrote:

Quote:

Hi,

I am very new to DTS and am currently still working with SQL Server 2000.

I have two problems:

1. I need to copy a file with a daily changing name from one server to
another. The file is date stamped. However, the first part of the file is
constant ('THSNUREF - constant part) and then ('2008-11-21-07-38-38.csv' -
changing).
I have been looking around for a couple of days and got some hints on how to
do it but I cannot make it work with my experince.

After the file transfer I need to:

2. delete the first row in the file as it contains data about when the file
was created. The second row contains the column headers and the rest is the
data.

Basically I am trying to copy the file, clean it up and then import it into
the database from where I stage it und update the live table. I can manually
process the file and copy it, rename it to a constant name and strip the
first row but that takes a long time and I have to do it for several
different files. And because the file has more than 65k rows I have to do
everything via access.

I would really appreciate any help from anyone.

Thanks

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200812/1

#9

Any takers?

DrDude wrote:

Quote:

Hi,

I am very new to DTS and am currently still working with SQL Server 2000.

I have two problems:

1. I need to copy a file with a daily changing name from one server to
another. The file is date stamped. However, the first part of the file is
constant ('THSNUREF - constant part) and then ('2008-11-21-07-38-38.csv' -
changing).
I have been looking around for a couple of days and got some hints on how to
do it but I cannot make it work with my experince.

After the file transfer I need to:

2. delete the first row in the file as it contains data about when the file
was created. The second row contains the column headers and the rest is the
data.

Basically I am trying to copy the file, clean it up and then import it into
the database from where I stage it und update the live table. I can manually
process the file and copy it, rename it to a constant name and strip the
first row but that takes a long time and I have to do it for several
different files. And because the file has more than 65k rows I have to do
everything via access.

I would really appreciate any help from anyone.

Thanks

--
Message posted via SQLMonster.com
http://www.sqlmonster.com/Uwe/Forums...r-dts/200812/1

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

DTS copy file and clear first line

microsoft.public.sqlserver.dts microsoft.public.sqlserver.dts

DTS copy file and clear first line - 11-21-2008 , 05:27 AM

Re: DTS copy file and clear first line - 12-01-2008 , 10:33 AM

Re: DTS copy file and clear first line - 12-01-2008 , 10:33 AM

Re: DTS copy file and clear first line - 12-01-2008 , 10:33 AM

Re: DTS copy file and clear first line - 12-01-2008 , 10:33 AM

Re: DTS copy file and clear first line - 12-01-2008 , 10:33 AM

Re: DTS copy file and clear first line - 12-01-2008 , 10:33 AM

Re: DTS copy file and clear first line - 12-01-2008 , 10:33 AM

Re: DTS copy file and clear first line - 12-01-2008 , 10:33 AM