Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Flexible Imported File Name

Status
Not open for further replies.
Wrinn

Wrinn

MIS
Apr 30, 2001
18
0
0
HK
Dear,
I would like to import Flat file into MS database by using DTS (Data Transfer Services). But my flat filename is flexible, its name depends on current date: such as F051101.dat. Does anyone know how to set flexible imported filename?

Regards,
 
Sort by date Sort by votes

You can import using Bulk Insert in a stored procedure. You could easily create the file name in the SP. Terry

X-) "I don't have a solution, but I admire your problem."
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

elly00
  • Locked
  • Question
create sql view using batch file
Replies
5
Views
113
Mike Lewis
Mike Lewis
Cpreston
  • Locked
  • Question
Update with a month name 1
Replies
9
Views
163
gmmastros
gmmastros
Auguy
  • Locked
  • Question
Connection String in .NET program Config File 2
Replies
10
Views
138
Auguy
Auguy
ahmedsa2018
  • Locked
  • Question
How to make pivot for features dynamically based on feature name and feature value ?
Replies
1
Views
60
TamarGranor
TamarGranor
bmacbmac
  • Locked
  • Question
Help searching within this Json file
Replies
0
Views
43
bmacbmac
bmacbmac

Part and Inventory Search

Sponsor

Back
Top