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, it
becomes translated to C:\Documents and Settings\v-michh\Local
Settings\Temporary Internet 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.


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

In article <eaWswKSaEHA.3996 (AT) TK2MSFTNGP12 (DOT) phx.gbl>, Mike Howell wrote:
How are you copying the files right now?

Maybe you should eport to a csv locally then FTP to the website. This may
be simpler.


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
www.konesans.com - for all your consultancy needs

Current I just drag and drop to the web folder, copy and paste also
works. I am looking for a solution where the DTS package does it
automatically so I can schedule it and have it run at a designated time.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

In article <eJUuJEcaEHA.2340 (AT) TK2MSFTNGP09 (DOT) phx.gbl>, Mike Howell wrote:
Then FTP it there.

Can you map a drive to it?
Can you use a UNC path to it?


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
www.konesans.com - for all your consultancy needs

Can DTS be programmed to FTP to the web folder? If so how? The FTP
task on DTS is for downloading, not uploading.

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.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

In article <uYJiPHraEHA.3356 (AT) tk2msftngp13 (DOT) phx.gbl>, Mike Howell wrote:
To push a file up to a server you can use the ExecuteProcess task and
call a batch file which calls FTP.exe


Allan Mitchell (Microsoft SQL Server MVP)
MCSE,MCDBA
www.SQLDTS.com
www.konesans.com - for all your consultancy needs