How to import file .txt having a changing name ?

Question

Viewing 9 posts - 1 through 8 (of 8 total)

You must be logged in to reply to this topic. Login to reply

balaji-44374 SSC Eights! Points: 944 More actions · Answer 1

Hi,

You can use the dynamic properties task to define the txt file dynamically?

Balaji

Ken Klaft-80806 Say Hey Kid Points: 693 More actions · Answer 2

...or identify the newest file in the folder (by file timestamp)...?

wildh SSCarpal Tunnel Points: 4370 More actions · Answer 3

I always force imported files to have the same name everytime.

Dave Mathein SSC Veteran Points: 282 More actions · Answer 4

You can save the DTS as a VB package, then change it so the new filename is passed into it or it or it calc's the correct filename to import.

Peter P SSCrazy Points: 2777 More actions · Answer 5

You can dynamically change the name of a text file. One option is to use the ActiveX Script Task in your DTS to perform this name change. Example:

'**********************************************************************

' Visual Basic ActiveX Script

'************************************************************************

Function Main()

Dim FSO

Set FSO = CreateObject("Scripting.FileSystemObject")

Dim objFile

Set objFile = FSO.GetFile("C:\TEMP\MyFile.txt")

objFile.Name = "MyNewFile.txt"

Set FSO = Nothing

Set objFile = Nothing

Main = DTSTaskExecResult_Success

End Function

philcart SSC-Forever Points: 47794 More actions · Answer 6

This is one of the many questions covered at http://www.sqldts.com

--------------------
Colt 45 - the original point and click interface

olzo SSC Veteran Points: 248 More actions · Answer 7

Thanks a lot for the replies ! There is what I needed.

For my last project, I have used only linked server and T-SQL to program my imports for each day.

So this time I'm trying the DTS.

But I'm asking how to choose between DTS and linked server/T-SQL for a replication ?

RonKyle SSC-Dedicated Points: 31556 More actions · Answer 8

The suggested method works well when you can determine the name. When you can't, use the following method:

Dim fso, folder, file, filecollection

Set fso=CreateObject("Scripting.FileSystemObject")

Set folder=fso.GetFolder("<<Path>>")

Set filecollection=folder.Files

For each file in filecollection

DTSGlobalVariables("ImportFileName").Value=file.Name

Exit For