I am using a DTS package to transfer a file from a location on the computer to a sql table column. To be more specific, I am using the bcp utility of sql server to do it.
Here's my problem:
If I knew the file's name in advance, then there would be no problem. However, the file is generated in a sequence. For eg. 1111.pdf, 1112.pdf,1113.pdf,etc. Now if the name of the file is 1111.pdf, the file has to go to the row in the table which has ID=1111. If the name of the file is 1112.pdf, the file has to go to the row which has ID=1112.
How would I get to know the names of the files in the location since they keep changing?
Any ideas?
rsshetty.
It's always in the details.
Here's my problem:
If I knew the file's name in advance, then there would be no problem. However, the file is generated in a sequence. For eg. 1111.pdf, 1112.pdf,1113.pdf,etc. Now if the name of the file is 1111.pdf, the file has to go to the row in the table which has ID=1111. If the name of the file is 1112.pdf, the file has to go to the row which has ID=1112.
How would I get to know the names of the files in the location since they keep changing?
Any ideas?
rsshetty.
It's always in the details.
