I have created a DTSpacket how takes a Excelfile and insert to a
sqlserver table.The Excelfile then moves to another path. It works
okey but I have a problem when I place two files in the same path
because the file has the same name. Is there some way I can makes it
work?? I get the files from mail and then I place it in a mapp. Now I
have to run the packet after I have place one file from the mail in
the mapp

AFAIK you cannot have two files of the same name in the same path can you?

In any event. Why not "archive" the XL file after you have finished using
it so that the next time you place a file in that directory it will be the
only one.



--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Stefan" <stefanljungstedt (AT) hotmail (DOT) com> wrote

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!