FTP Task Editor

When attempting to use SQL Server 2005 FTP task editor remotepath, which I
have mapped directly to the FTP site folder I am using and connected too, th
e
editor keeps giving me an error that the directory doe not exist. Below is
the error I receive.
Error: 0xC002F304 at ftpsite, FTP Task: An error occurred with the following
error message: "Changing current directory to "\F:\Somedirectory\test". 550
'/F:/Somedirectory/test': Not a directory or not accessible.
Has anyone else confronted this issue and is their a known solution?
FYI: The romotepath insist I place a "\" in front of my path or else it will
not recognize the path as a valid path.i've got the same issue - I simply want to log into the ftp server and be in
the default directory it logs into and get a file from there - does anyone
have an answer to this? here is the command for what I want to do, very
simple -
get 'J3.J3PRODM.J1PPB74.AOUSCF5'
not sure if I need the quotes or not but what should the remote path be? I
think the first "/" it requires is throwing it off, here is the error I get
-
Error: 0xC002F304 at FTP AOUSCP1 from BOP, FTP Task: An error occurred with
the following error message: "Changing current directory to "\". 451 HFS
function BPX1SDD gave return code 0000009C, reason code 0B0C00FC
.
--
John F.
"NeedHelp21" wrote:

> When attempting to use SQL Server 2005 FTP task editor remotepath, which I
> have mapped directly to the FTP site folder I am using and connected too,
the
> editor keeps giving me an error that the directory doe not exist. Below i
s
> the error I receive.
> Error: 0xC002F304 at ftpsite, FTP Task: An error occurred with the followi
ng
> error message: "Changing current directory to "\F:\Somedirectory\test". 55
0
> '/F:/Somedirectory/test': Not a directory or not accessible.
> Has anyone else confronted this issue and is their a known solution?
> FYI: The romotepath insist I place a "\" in front of my path or else it wi
ll
> not recognize the path as a valid path.
>

FTP Directly into SQL Server

Hello,
Is there any way to FTP files directly into SQL Server?
We'll have users who want to FTP a file to us. Instead of bringing it into a file system, we'd like it to automatically put the file into a field in a table.
Is there a product out there that sits on top of SQL Server that will take FTP requests directly, or is there something internal?
We would rather not have to write it to a file, then pull it into SQL server via some polling mechanism. We want the user's action to dictate the whole process.
Thanks in advance
In article <57F9D4E8-4E14-44F0-AFEA-03EDDAEBE945@.microsoft.com>,
sqlquestion0001@.discussions.microsoft.com says...
> Is there any way to FTP files directly into SQL Server?
> We'll have users who want to FTP a file to us. Instead of bringing it
> into a file system, we'd like it to automatically put the file into a
> field in a table.
> Is there a product out there that sits on top of SQL Server that will
> take FTP requests directly, or is there something internal?
> We would rather not have to write it to a file, then pull it into SQL
> server via some polling mechanism. We want the user's action to
> dictate the whole process.
I would look at something like Mabry's FTP Server library and build the
app yourself. It's actually a very easy control to use and it will let
you enforce decent security. I would recommend running this app on a
different server as FTP requires a lot of ports to be open.
There are also a number of shareware FTP servers out there that let you
setup accounts and restrict file types. You can set fixed commands to
run on the upload completion event.
|||Why not just get them to use bcp to "send" it to you instead of FTP?

> Is there any way to FTP files directly into SQL Server?
> We'll have users who want to FTP a file to us. Instead of bringing it into a file system, we'd like it to automatically put the file into a field in a table.
> Is there a product out there that sits on top of SQL Server that will take FTP requests directly, or is there something internal?
> We would rather not have to write it to a file, then pull it into SQL server via some polling mechanism. We want the user's action to dictate the whole process.
> Thanks in advance
>
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvforu...?SRV=MSDevApps
(faqxxx.zip in lib 7)
or http://www.ntfaq.com/Articles/Index...partmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faq

FTP Directly into SQL Server

Hello,
Is there any way to FTP files directly into SQL Server?
We'll have users who want to FTP a file to us. Instead of bringing it into
a file system, we'd like it to automatically put the file into a field in a
table.
Is there a product out there that sits on top of SQL Server that will take F
TP requests directly, or is there something internal?
We would rather not have to write it to a file, then pull it into SQL server
via some polling mechanism. We want the user's action to dictate the whole
process.
Thanks in advanceIn article <57F9D4E8-4E14-44F0-AFEA-03EDDAEBE945@.microsoft.com>,
sqlquestion0001@.discussions.microsoft.com says...
> Is there any way to FTP files directly into SQL Server?
> We'll have users who want to FTP a file to us. Instead of bringing it
> into a file system, we'd like it to automatically put the file into a
> field in a table.
> Is there a product out there that sits on top of SQL Server that will
> take FTP requests directly, or is there something internal?
> We would rather not have to write it to a file, then pull it into SQL
> server via some polling mechanism. We want the user's action to
> dictate the whole process.
I would look at something like Mabry's FTP Server library and build the
app yourself. It's actually a very easy control to use and it will let
you enforce decent security. I would recommend running this app on a
different server as FTP requires a lot of ports to be open.
There are also a number of shareware FTP servers out there that let you
setup accounts and restrict file types. You can set fixed commands to
run on the upload completion event.|||Why not just get them to use bcp to "send" it to you instead of FTP?

> Is there any way to FTP files directly into SQL Server?
> We'll have users who want to FTP a file to us. Instead of bringing it int
o a file system, we'd like it to automatically put the file into a field in
a table.
> Is there a product out there that sits on top of SQL Server that will take
FTP requests directly, or is there something internal?
> We would rather not have to write it to a file, then pull it into SQL serv
er via some polling mechanism. We want the user's action to dictate the who
le process.
> Thanks in advance
>
Neil Pike MVP/MCSE. Protech Computing Ltd
Reply here - no email
SQL FAQ (484 entries) see
http://forumsb.compuserve.com/gvfor...p?SRV=MSDevApps
(faqxxx.zip in lib 7)
or www.ntfaq.com/Articles/Index.cfm?DepartmentID=800
or www.sqlserverfaq.com
or www.mssqlserver.com/faqsql

From Excel to Analysis Services

Have any of you heard of an application that makes it possible for normal business people with no IT knowledge to directly from Excel “publish” a table to SQL Server and Analysis Services?

I’m searching for an Excel add-in that sends the data in a normal Excel table with a few dimensions and some measures, as a data set (preferably via a web service over https) to a server application. The server creates a table in a specific SQL Server database, and automatically creates a cube in a specific analysis service database. The cube on the server is automatically processed and the data is available to all users in the company using their BI GUI.

Any ideas where to find such tool?

/Erik

I don't know any turnkey solution which can solve your entire problem. But there are enough off-the-shelf technologies, such as SQL Server Integration Service, out there from which you can build your own solution.

Alternatively, take a look at the Visual Studio Tools for Office (the .Net interop assemblies for Office essenially) as you can pretty easily write some code behind your XL spreadsheet (or as an XL add-in) yourself that can pull data off the sheet into an ADO.Net recordset which you can then push to SQL Server (or XML or many other formats for that matter).

|||You can also use pivot tables in excel and publish cubes on the web using OWC.|||

That is exactly what I would prefer. I use OWC for publishing Aanalysis Services Cube data thru Excel onto Http:// - a basic publication site. It works fine for IT and Biz community with no maintenace. - raj