The Cellar - View Single Post

BigV · 05-26-2006, 08:09 PM

In the interest of completeness, I haven't gotten to the DTS/export stage. I hope I don't have to export it at all.

I intend to use the DTS package to scan the Excel file and extract portions of rows where the date meets some as yet undefined criterion. Once I have that subset of rows in the temporary table in SQL, I need to send an email to some users. In that email, I want the \\server\directory\filename to appear. =GetAddress() displayed that text in another cell in the same row in the Excel file. I reckon I can pick that up in the DTS package.

One problem =GetAddress() revealed was the sloppy condition of the data in the linklocation part of the cell. I have...inconsistent representations of the locations and names of the files. Specifically, spaces and %20 are freely interchanged. =GetAddress() chokes on the first %20, displaying only what follows the %20, ignoring the leading part (where the server directory and partial filename exist).

I set the owner of the file on the task of normalizing the filenames. We'll see next week how things are looking up.

Thanks to all for your help and interest.

05-26-2006, 08:09 PM	#15
BigV Goon Squad Leader Join Date: Nov 2004 Location: Seattle Posts: 27,063	In the interest of completeness, I haven't gotten to the DTS/export stage. I hope I don't have to export it at all. I intend to use the DTS package to scan the Excel file and extract portions of rows where the date meets some as yet undefined criterion. Once I have that subset of rows in the temporary table in SQL, I need to send an email to some users. In that email, I want the \\server\directory\filename to appear. =GetAddress() displayed that text in another cell in the same row in the Excel file. I reckon I can pick that up in the DTS package. One problem =GetAddress() revealed was the sloppy condition of the data in the linklocation part of the cell. I have...inconsistent representations of the locations and names of the files. Specifically, spaces and %20 are freely interchanged. =GetAddress() chokes on the first %20, displaying only what follows the %20, ignoring the leading part (where the server directory and partial filename exist). I set the owner of the file on the task of normalizing the filenames. We'll see next week how things are looking up. Thanks to all for your help and interest. __________________ Be Just and Fear Not.