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 2008 Forums
 SSIS and Import/Export (2008)
 load excel files except one file

Author  Topic 

inbs
Aged Yak Warrior

860 Posts

Posted - 2012-02-15 : 05:21:31
i follow this post.
i load every hour a lot of dynamic excel files (the name is dynamic)
after i load, i move the file to backup folder.

the problem is the connection of excel file is lost (because i move the all the files to backup folder).

so i need to save the connecion of excel file (i mean not move specific excel file)

1.how can move file except one?
2.how save connection of excel file (after i need move it)

thanks
   

- Advertisement -