Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SSIS and Import/Export (2005)
 Reading a file

Author  Topic 

powellbound
Starting Member

23 Posts

Posted - 2008-08-12 : 11:09:44
Any ideas how I read a file where the filename changes every five minutes but always has an 'ante' in the name. I tried to look for '*ante*' but SSIS did not like that (told me there was an illegal character in the filename).

TIA,

David

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-12 : 13:16:58
I think this might be what you're looking for

http://www.sqlis.com/23.aspx
Go to Top of Page

powellbound
Starting Member

23 Posts

Posted - 2008-08-13 : 13:16:00
Worked perfectly!

Thanks for the pointer
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-08-13 : 13:24:07
quote:
Originally posted by powellbound

Worked perfectly!

Thanks for the pointer


Cool
You're welcome
Go to Top of Page
   

- Advertisement -