If you are wanting to list the files on the web server using an ActiveX control then the files on the web server need to be in a shared folder as the control runs on the client machine. You can set the web server to display the contents of the directory alternatively you can use ASP and the...
You can get a number of them from ADOVBS.inc (C:\Program Files\Common Files\SYSTEM\ADO). I'd expect there to be a complete set on MSDN somewhere.
What do you want them for? If you want them in ASP you can reference the ADO type library and have access to them all (or use the above INC file)...
I believe that all the save file dialog does is enable you to get a path and filename from a user. You then have to write the code that saves the file yourself.
Sorry to disappoint!
Change the SQL script in your package to read:
lastmodifieddate = getdate()
Getdate() is a T-SQL function that returns the current date/time (equivalent to VB Now()). To filter purely for date you need to convert the value to remove the time portion. Use convert(varchar(11), getdate(), 106)...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.