thanks for the replies!


For this I would need to have some code in dotnet -
which is how it is setup currently. I was looking for
a way to import files by only using SQL DTS and have
no external code running. This way I can schedule the
DTS to run as a job.

Oh Well!



--- Smithson Charles
<mssqldba-ezmlmshield-x9415239.[Email address protected]
wrote:
> Vishal,
> for many DTS tasks you may find what you are looking
> for at SQLDTS.com,
> below is a link for exactly what you are trying to
> accomplish.
>
> http://www.sqldts.com/default.aspx?200
>
>
> -----Original Message-----
> From: Vishal Sinha
> [mailto:mssqldba-ezmlmshield-x72095258.[Email
> address protected]
> Sent: Tuesday, May 25, 2004 12:58 PM
> To: LazyDBA.com Discussion
> Subject: DTS: Import data from file
>
>
> I am trying to import data from text file to a SQL
> table.
> The files come in daily and have format
> FileNameMMDDYYYY.txt
>
> Can someone help me design DTS package that can take
> in cariable file names?
>
> Thanks!
>
>
>
>
> __________________________________
> Do you Yahoo!?
> Friends. Fun. Try the all-new Yahoo! Messenger.
> http://messenger.yahoo.com/
>
>
>
---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT
> JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
> For additional commands, e-mail: mssqldba-[Email
> address protected]
> CONFIDENTIALITY NOTICE: This electronic message
> transmission, including any
> attachment, is intended only for the use of the
> individual or entity to
> which it is addressed. It may contain information
> that is privileged,
> confidential or otherwise protected from disclosure.
> If you are not the
> intended recipient, you are hereby notified that any
> dissemination or
> copying of the contents of this information is
> prohibited. If you have
> received this transmission in error, please notify
> the sender immediately by
> a "reply to sender only" message and destroy all
> electronic and hard copies
> of the communication, including attachments. If
> there is a transmission
> problem, please call ALERE at 1 (888) 442-5373.
>
>
>
>
---------------------------------------------------------------------
> TO REPLY TO EVERBODY , PLEASE CLICK REPLY-ALL, NOT
> JUST REPLY
> Website : http://www.LazyDBA.com
> To unsubscribe:
> http://www.lazydba.com/unsubscribe.html
> For additional commands, e-mail:
> mssqldba-[Email address protected]
>





__________________________________
Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger.
http://messenger.yahoo.com/

MS Sql Server LazyDBA home page