How to upload dynamic text file !!. Experts Only !!!

3 Sep 2005 12:05 PM

Ahmed Jewahar

Dear All,

I have project and I'm in the middle of system design & analysis. I
would really appreciate if you could share your knowledge in the
following area where I'm newbie.

In Win2k/Win2003 server, SQL2K is running. I have a folder called
"D:\Work" where I'm gettin many ".txt" (pipe delimeter files) in every 2
miniutes time from a UNIX box.

Now, I need a system which should upload ".txt" files from "D:\work"
folder to SQL Table (tblDailyData) and move the ".txt" files those are
loaded to SQL to "D:\processed" folder. This process might be a job that
should be executed in every 5 minutes time daily.

Hope you understand my objective. So, I'm looking for your thoughts !.

Many thanks in advance..

Regards,

*** Sent via Developersdex http://www.developersdex.com ***

3 Sep 2005 1:29 PM

Tom Moreau

This can be handles by creating a DTS package that does both theimport and
move. You can scheduled it to run evey minute or two.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com

Show quote

"Ahmed Jewahar" <ahmed.jewa***@dhl.com> wrote in message
news:em$NO$HsFHA.3976@TK2MSFTNGP10.phx.gbl...
> Dear All,
>
> I have project and I'm in the middle of system design & analysis. I
> would really appreciate if you could share your knowledge in the
> following area where I'm newbie.
>
> In Win2k/Win2003 server, SQL2K is running. I have a folder called
> "D:\Work" where I'm gettin many ".txt" (pipe delimeter files) in every 2
> miniutes time from a UNIX box.
>
> Now, I need a system which should upload ".txt" files from "D:\work"
> folder to SQL Table (tblDailyData) and move the ".txt" files those are
> loaded to SQL to "D:\processed" folder. This process might be a job that
> should be executed in every 5 minutes time daily.
>
> Hope you understand my objective. So, I'm looking for your thoughts !.
>
> Many thanks in advance..
>
> Regards,
>
>
>
>
>
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***

3 Sep 2005 1:40 PM

Ahmed Jewahar

Tom,

Since my data source (.txt) is dynamic, how can I design a DTS with
dynamic source file names !. Appreciate if you could elaborate bit in
more desgining of a DTS which use dynamic .txt file as source and
loading to a table.

Appreciate your comments

*** Sent via Developersdex http://www.developersdex.com ***

3 Sep 2005 2:04 PM

Tom Moreau

The Dynamic Properties task in DTS may be your best bet. It can set up
various package properties for you. Failing that, an ActiveX script taks can
let you mange that down to the bare metal.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinpub.com

Show quote

"Ahmed Jewahar" <ahmed.jewa***@dhl.com> wrote in message
news:%23uhSX0IsFHA.1032@TK2MSFTNGP12.phx.gbl...
>
> Tom,
>
> Since my data source (.txt) is dynamic, how can I design a DTS with
> dynamic source file names !. Appreciate if you could elaborate bit in
> more desgining of a DTS which use dynamic .txt file as source and
> loading to a table.
>
> Appreciate your comments
>
>
> *** Sent via Developersdex http://www.developersdex.com ***

3 Sep 2005 3:44 PM

Andrew J. Kelly

If you look at the link I posted you will find that exact example in amongst
all the wonderful samples.

--
Andrew J. Kelly SQL MVP

Show quote

"Ahmed Jewahar" <ahmed.jewa***@dhl.com> wrote in message
news:%23uhSX0IsFHA.1032@TK2MSFTNGP12.phx.gbl...
>
> Tom,
>
> Since my data source (.txt) is dynamic, how can I design a DTS with
> dynamic source file names !. Appreciate if you could elaborate bit in
> more desgining of a DTS which use dynamic .txt file as source and
> loading to a table.
>
> Appreciate your comments
>
>
> *** Sent via Developersdex http://www.developersdex.com ***

3 Sep 2005 1:41 PM

Andrew J. Kelly

You don't really need to be an expert to answer this one. Your best bet is
to create a DTS package and schedule it through SQL Agent. This site should
help quite a bit.

http://www.sqldts.com/

--
Andrew J. Kelly SQL MVP

Show quote

"Ahmed Jewahar" <ahmed.jewa***@dhl.com> wrote in message
news:em$NO$HsFHA.3976@TK2MSFTNGP10.phx.gbl...
> Dear All,
>
> I have project and I'm in the middle of system design & analysis. I
> would really appreciate if you could share your knowledge in the
> following area where I'm newbie.
>
> In Win2k/Win2003 server, SQL2K is running. I have a folder called
> "D:\Work" where I'm gettin many ".txt" (pipe delimeter files) in every 2
> miniutes time from a UNIX box.
>
> Now, I need a system which should upload ".txt" files from "D:\work"
> folder to SQL Table (tblDailyData) and move the ".txt" files those are
> loaded to SQL to "D:\processed" folder. This process might be a job that
> should be executed in every 5 minutes time daily.
>
> Hope you understand my objective. So, I'm looking for your thoughts !.
>
> Many thanks in advance..
>
> Regards,
>
>
>
>
>
>
>
>
> *** Sent via Developersdex http://www.developersdex.com ***