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.
| Author |
Topic |
|
daveofgv
Starting Member
6 Posts |
 Posted - 2011-04-17 : 14:08:45
|
| We get anywhere from 200 - 1000 files we have to extract from a directory and ship off to a client. Right now, I am using excel with a macro that can search from a list (column A) and return a value of files not found.I would rather uses SSIS to perform this task since excel seems to "Not Respond" a lot.I want to add all the file names to column "A" in excel and have SSIS find the files and copy them to another directory - and also let me know what files were not found.Can anyone help me set this up / or / what do I have to do in order to have this done?I am not a well known SQL man - beginner.....I do know how to set up a SSIS package and have done them before, however, not for this type of work.Thanks in advanceddaveofgvI am learning new things about SQL everyday |
|
|
daveofgv
Starting Member
6 Posts |
Posted - 2011-04-17 : 14:14:47
|
| I forgot to mention that I am using SQL 2005 and will show the code for what I am using in excel to perform the function.Also, all the files will be in one directory, however, subfolders within the directory.I am learning new things about SQL everyday |
 |
|
|
latch
Yak Posting Veteran
62 Posts |
Posted - 2011-05-06 : 12:04:31
|
| Hi,I too work in the same environment where we get usually some files and a excel file with the file names in the column 'A'.I read the file names from the excel file if it is what i need then i pick it up and drop to other folder if it not useful just move to other folder.Usually what i do is, i take script task in control flow.My script is in vb.net which reads one line at a time from the excel and then moves the files. |
|
|
|
|
|
|
SSIS / search for files from excel