DTS Export to Web Folder

Question

Post reply

DTS Export to Web Folder

Mike Howell

Mr or Mrs. 500

Points: 521
More actions
July 13, 2004 at 5:10 pm

#66019

I need to export data from SQL Server 2000 to a csv file located in a
web folder. When I choose the file name path using the dialog box and selecting the folder from Netwrok Places, it
becomes translated to C:\Documents and Settings\v-michh\Local
Settings\Temporary Files\Content.IE5\KFCRM1S1. When I run the
package, I get an error
"Error Source: Microsoft Data Transformation Services Flat File Rowset
Provider
Error Description: Error opening datafile: Access is denied"
If I enter the https://Webfolder/file.csv address in the file path, I
get an error
"Error Source: Microsoft Data Transformation Services Flat File Rowset
Provider
Error Description: Error opening datafile: The filename, directory name,
or volume label syntax is incorrect"
How can I get DTS to export directly to this webfolder.
I do have the appropriate permissions for the site, as I can access it
and copy files directly to the site. I have also been granted
administrative right to the site. This site uses Integrated Windows
Authentication.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply

Ryk Neethling Old Hand Points: 380 More actions · Answer 1

Try sharing a folder in the web as a Network folder and use a UNC path to do it.

Mike Howell Mr or Mrs. 500 Points: 521 More actions · Answer 2

You can not map a web folder as a drive without 3rd party software. As I am not an administrator on the server where the package exists, or where the web folder exists, I am unable to install 3rd party software and the admin is unwilling to install the software on this server.

I do not know which server the web folder resides on and it is not a shared folder anyways, so using a \\server\folder\file path is not an option. I also do not know who the administrator is for this server.

I am looking to be able to schedule this package so I do not need to manually move the file. Can DTS be programmed to FTP to the web folder? If so how? The FTP task on DTS is for downloading, not uploading.

Thanks