ftp task to network drive?

Hi I have a simple ftp task that downloads some files from an ftp to a local directory. That package run as a sheduled job from the sql 2005 server without a problem so far.

Now I whant to have the same task but to download the files to different mapped network drives , so I mapped the drives then I changed the paths to the config file but since then the job fails...

is it possible to do that or I did something wrong?

Thanks
g

Drive mappings are local to the user profile, so trying to use them in unattended jobs which run under a service account context does not make too much sense. I would strongly advise you to use a UNC path instead, e.g. \\Server\Share\Folder\File.ext

You will need top ensure that the service account or job proxy account has access to the share, as well as the normal folder permissions required for local as well.

|||Hi Darren,

Thanks a lot for the reply!!

I try the UCN path from the BI studio and it works fine but since I run it as a job faild. It must be something with the access to the share as you already said but since I am a newbie I don't know where exaclly to look for the problem... I am not running the job from a proxy do I have to create one? And if yes could you let me know for the process ?

As about the folder permissions I ve set full permission to "Everyone".

Thanks in advanced
G
|||

There is no need for a proxy account. By default your job will run under the context of the SQL Server Agent service account. Make sure you know what this is, and then check if that account has access to the share.

FTP Task Problem

I am new to this task...In order to set up this task do i need to set any basic thing on my local machine.

If so Please let me know

Sureshv,
Please read the Books On-Line page on this task and then come back here with any further questions you might have.

http://msdn2.microsoft.com/en-us/library/ms137656.aspx|||

I have few question

server name= ?

Server por =?

username=?

password=?

if i am trying to connect to remote

|||

sureshv wrote:

I have few question

server name= ?

Server por =?

username=?

password=?

if i am trying to connect to remote

If you know how to use FTP, you know the answer to those questions otherwise you won't be able to use FTP at all and you should probably talk to whomever supports the FTP site you want to connect to.|||

What i meant is

IS server name=Name of remote server or machine(is it ip address)

server port =server port which remote uses

username=is it valid username with all the permission to access

Password= valid password

|||

sureshv wrote:

What i meant is

IS server name=Name of remote server or machine(is it ip address)

server port =server port which remote uses

username=is it valid username with all the permission to access

Password= valid password

Yes.|||

I am trying to use FTP task to a remote machine.I am trying to take a local file from my machine and place it over there using FTP.

I place the ip address in the server name and i tried server name too..

port 21

i have a remote account(with full control set up) too by which i login using remote desk top

But my connection fails

Please help..

|||Can you ftp to this site and upload a file using one of approximately 10,000 (I'm being a little facetious but its close) non SSIS ftp clients?
|||I have no idea of what u are talking.what do i need to do now..I am not an expert in the area...would u please help|||I'm trying to help, believe it or not. The question was, can you upload to the site with a non-SSIS ftp client first off, so at least we know the issue is specific to SSIS?
|||

so do u mean that my system via command promt has an ability to reach the remote by sending files.

If u are talking about this.I say system gets connected but what do we need to do to send a file.

Please let me know.

|||Please stop starting new threads for an issue you've already opened here.

I've merged this thread.|||Should FTP from command prompt work first in order to set up ftp task
|||

sureshv wrote:

Should FTP from command prompt work first in order to set up ftp task

YES!

How do you know everything is setup correctly if you don't know how to FTP?

That is, how have you verified that it is setup correctly and that you have full permissions?

FTP TASK PROBLEM

Dear all,

I have problem in my ftp task.For example,
I create two variable remotepath and localpath to set up remote and local path of ftp task. And the IsRemotePathVariable and IsLocalPathVariable is set to true.

I create two funtions to retrun the pathvalue. The return value

is like 'D:\A.TXT' , but in DTSX the varible value is changed to 'D:\\A.TXT'. So my ftp task fail.

How can I overcome this problem?

Thanks a lot.

Regards

wen

Replace all occurences of "\\" with "\" if its causing you a problem.

You can do this in an expression.

-Jamie

|||

It doesn't actually change the value. It is just that the undelying engine for SSIS is written in C and "\" is an escape character. To actually display the value of "\" it has to be preceeded by a "\". so to use/display it in a string it appears as "\\". For example \r actually means a carriage return.

As for your situation what error are you getting?

|||

when the path value is changed to "\\" , the error is as bellow,

Error: 0xC0029183 at FTP Task, FTP Task: File represented by "User::FTPPATH" does not exist.
Task failed: FTP Task

sql

ftp task

Is is possible by ftp task to unzip the file and take the respective text file and place it in the local system.

sureshv wrote:

Is is possible by ftp task to unzip the file and take the respective text file and place it in the local system.

No. Unzipping a file has nothing to do with FTP and never will be included in such a task.

Use an Execute Process Task after the FTP task to unzip it.

Use a File System Task after the Execute Process task to move the resulting file, if needed. You usually can use command line arguments to the unzip process to direct the ZIP utility where to place the unzipped file.|||

what i am trying to do is i get a zip file (which has a text file) .

This zipfile is located on a different server.I want to transfer text file located with in the zip to a different server and then i run my package.

i want to setup my packages in such a way that they run automatically.

so in this case i guess i need to use ftp task to get the zip file to local server and then unzip it as u said..

|||

sureshv wrote:

so in this case i guess i need to use ftp task to get the zip file to local server and then unzip it as u said..

Correct. I've spelled out the steps you need.

FTP Replication

Is it possible to implement SQL Replication via ftp without expose SQL
Server on Internet.
I mean if SQL Server is in local mashine and only ftp site is visible to the
subscribers.
And i dont want to use VPN
Well you have several options
1) have SQL run on port 21, then get your snapshot over another way.
2) use sp_browsereplcmds to get plain text commands to issue on the
subscriber. This will require a local subscription to generate these
commands.
Hilary Cotter
Looking for a SQL Server replication book?
http://www.nwsu.com/0974973602.html
Looking for a FAQ on Indexing Services/SQL FTS
http://www.indexserverfaq.com
"Greg" <gcholakidis@.hotmail.com> wrote in message
news:d74j04$3pe$1@.usenet.otenet.gr...
> Is it possible to implement SQL Replication via ftp without expose SQL
> Server on Internet.
> I mean if SQL Server is in local mashine and only ftp site is visible to
the
> subscribers.
> And i dont want to use VPN
>
|||I try to implement the second approach (using sp_browsereplcmds).
Unfortunly i see in help that sp_browsereplcmds doesnt work with merge
replication
(in remarks ' sp_browsereplcmds is working with transactional replication')
I dont understand why Microsoft is mention ftp replication since they dont
implement futures which allows
you to use ftp server anywhere in the net and require VPN or SQL Server
exposed to net.
Is there any workoroun or thirt party tool which will allows such
communication?
I mean i need merge replication between two sites. And i want to use ftp
server to store and exchange snapshots.
I have an application which works this way but using Sybase Anywhere
replication and want to convert it to SQL Server 2000
"Hilary Cotter" <hilary.cotter@.gmail.com> wrote in message
news:%2393LawgYFHA.1040@.TK2MSFTNGP10.phx.gbl...
> Well you have several options
> 1) have SQL run on port 21, then get your snapshot over another way.
> 2) use sp_browsereplcmds to get plain text commands to issue on the
> subscriber. This will require a local subscription to generate these
> commands.
>
> --
> Hilary Cotter
> Looking for a SQL Server replication book?
> http://www.nwsu.com/0974973602.html
> Looking for a FAQ on Indexing Services/SQL FTS
> http://www.indexserverfaq.com
> "Greg" <gcholakidis@.hotmail.com> wrote in message
> news:d74j04$3pe$1@.usenet.otenet.gr...
> the
>
sql

From local to Inet server

Hi..

First of all im a super newb in asp.net and MSSQL.
I had a guy program a website with database, but the guy just stood me up and left me with the files and the server as a file.

Now I need to get them online and working.

The files are FTP on the server so I "just" need the server running

I got the following files:

Justgeek_data.mdf and Justgeek_log.ldf

The server admin interface is:myLittleAdmin.

Any walktrough help or simular would be highly appreciated.

The web is:http://www.bodyplanning.dk

have alook at SQL Server "attach database" process on MSDN

http://msdn2.microsoft.com/en-us/library/ms190794.aspx

|||

Got the database up and running but still errors:

Main page:http://www.bodyplanning.dk/default.aspx

Sub pages:

http://www.bodyplanning.dk/frmLogin.aspx

|||

It is likley that there is a user set up in the database, which also needs to exist at the global level in SQL Server.

Look in Security/Logins in SQL server, then add any users in the database you have attached, and set the passwords.

In the web.config file for the site, ensure that the usernames and passwords match up