Get A File To A FTP Site T-sql

Oct 6, 2003

I have to download a file from a ftp site using either SQL/T-Sql or ActiveX script. I'm using SQL Server 2000. Please help

Thanks in advance

View 2 Replies


ADVERTISEMENT

To Post A Text File In Ftp Site

Nov 12, 2007

Hi all SSIS experts,
I have a task to read certain columns from the db, convert it into a tab delimted text file and post it in an FTP site.
Please suggest on the steps to accomplish this.
Is SSIS the best way?
Can the same task be accomplished using only sql code.
Regards,
Josiny

View 1 Replies View Related

Speeding Up Site By Storing Query Results In File

Mar 4, 2008

Hello,
We have some queries that are long and intensive. We have thought about running the queries and storing the data in a text file for lookup from our website.

Example: Our online store only displays items that are in stock so when a user selects a category a query runs and grabs only items that are in stock and then displays them. There could be thousands of items the query needs to sort through before displaying the items that are in stock. What if we ran this query once every hours an stored the results in a txt file? The asp page would then go to the text file to grab the results instead of having to run the query every time a user selects a category. Will this speed up the site by not having to query every time? Would this be a correct way to eliminate queries that run thousands of times a day?

thanks
Andy

View 2 Replies View Related

Integration Services :: Send File Using SSIS To FTPS Site

Jun 25, 2013

I am given a task where I will be creating flat files and will be sending them over to a different network using FTPS site. I have tried everything(May Be not), But wasn't able to figure this out. This will be the only task which will be using FTPS site do client is not willing to spend money on buying any 3rd party addons.

View 6 Replies View Related

Receive Files From Remote Site Only If File Does Not Exist In Local Directory

Jul 13, 2007

I need to only receive files via ftp when the file does not exist on my local machine. FIles are being added to the remote location on a weekly basis and they are being downloaded locally. I do not want to download all the files each time. Instead, just download what was not already downloaded. Is there a way to do this? I want to do this using SSIS / ftp task.



Thanks in advance.

View 4 Replies View Related

Error In Accessing Site Which Is Restored Using STSADM. Error-The File Exists. (Exception From HRESULT: 0x80070050)

Oct 8, 2007

i have restored site using stsadm, site get successfully restored.
all user of the site able to access the site but the unable to access from same machine on which it is restored.
i got the error
The file exists. (Exception from HRESULT: 0x80070050)

View 1 Replies View Related

Permissions Via ASP.NET Web Site

Jan 31, 2007

I have a website with membership system.  I've been through a lot implementing the site and I think I'm on the verge of full implementation.  I can't get my registration page or my admin page to add, edit or delete users.  I'm assuming that asp does not have proper permissions on SQL to do such.
I'm running the site on a provider that has a SQL 2000 server.  I access the database through VS2005 and  SQL Server Management Studio Express.
Is there a tutorial out there that could help a newbie to SQL understand how to check and correct my permissions issue (or find out that I'm haveing a different issue entirely.
-Bill

View 3 Replies View Related

Using ASPNETDB For All Site!

May 26, 2008

Hi all,
I`m a .NET desktop-app developer and i`m new to ASP.NET and web development, i start developping a web application with SQL Server database and i want to know if i can put all my tables in ASPNETDB?
is any restriction with that?
Regards

View 3 Replies View Related

SQL 7 And Site Serer 3.0

Feb 3, 1999

Hello,

This may be the wrong place to add this but....

I am attempting to setup a membership instance for Site Server 3.0 using SQL 7 and try as I might, Site Server Membership will not see the server at all. I can do anything else I want to to that server and it works great (commerce, etc.). It all works OK under SQL 6.5 SP3 or later, just not SQL 7.

Does anyone have any thoughts or insights?

Thanks
John

View 1 Replies View Related

SQL Serverback Up To FTP Site

Oct 13, 2004

Is there a good back up software that willl back up by SQL server to a FTP site. All of them I have seen either backs up to a disk or tape.

Thanks

Jay

View 2 Replies View Related

Does Anybody Look At The Jobs On This Site

Nov 17, 2004

Poeple are calling me for resume 5 years old. They need DBA's all over the country. Please pass it on to look at the job opportunities on this site.

View 2 Replies View Related

Deploying A Web Site

Jun 14, 2006

I am having problems deploying my web site from my machine to the hosting server.

Does any know of any special configurations that have to be perfomed before copying your web site to a server? All I have is a login in page that loads another page. The login page is launching okay but it does not load the second page.

View 2 Replies View Related

Should My Site And Sql Be On The Same Server

Apr 11, 2007

Hello,

I am upgrading my site from a VPS with a shared SQL server to a dedicated server and my own sql server 2003 standard. My site is an ecommerce site with about 10,000 users a month with between 10-20 people on the site at one time.

It is better to host both my site and the SQL server on the same system or is it better to have them on separate systems? if they are on the same system is 1 gig of ram enough? is will there really be much better performance with 2 gigs?

Any information on the best way to do this would be greatly appreciated!!!

Best regards,

~ Moe

View 2 Replies View Related

Phishing Web Site

Dec 17, 2007

How can a genuine Web Outlook url be classified by filtering software as a known phishing web site?

Thanks.

View 1 Replies View Related

Accessing FTP Site

May 15, 2008



Hi,

I am trying access a FTP site present from a different server (remote work station). I am getting "The page cannot be displayed" error. I am able to access from my local machine.

Please help me solving this.

Regards,
Sriram.

View 3 Replies View Related

Backup To FTP Site

Feb 7, 2006

I want to backup my database to an ftp site. How can I do that with SQL Server 2005? Thanks.

View 1 Replies View Related

Getting Files From An FTP Site

Apr 23, 2008

Hello:

I have setup a Flat File connection manager and set the location of the file as such:

ftp://10.1.1.1/FileName.txt

When I enter this URL into Start | Run on my machine it opens the txt file fine. Working in BIDS, when I create the flat file connection manager, it doesn't give me a message saying this file does not exist, indicating it is correct. When I create a flat file Source that uses the connection manager, the preview comes up blank. When I try to execute the step it gives an error saying it "cannot open datafile ftp://10.1.1.1/FileName.txt"

Any idea what could be going on?


Thanks,
Kayda

View 5 Replies View Related

Site Settings

Oct 16, 2006



I need to place some site settings in my Report Manger.But in my Report Manager there is no Site Settings Icon.Is this installation problem please help me.

View 3 Replies View Related

Using Encryption Via An Asp Site. How Is It Done

Feb 18, 2007

ive been playing around with encryption, just encrypting a column with a symmetric key, and having that symmetric key encrypted with a cert, and all that , and it works well through the SSMS, but i want to know how that will be used if im using sql server as a back end database for an asp web site, or an application. does the sql server have to be protected with an SSL cert, and once a user has logged in, what would the steps be to view encrypted data?

View 6 Replies View Related

Web Site Admin Tool

Aug 24, 2006

Hi!
My problem is...i gut this errormessage in Web Site Administration Tool:
There is a problem with your selected data store. This can be caused by an invalid server name or credentials, or by insufficient permission. It can also be caused by the role manager feature not being enabled. Click the button below to be redirected to a page where you can choose a new data store. The following message may help in diagnosing the problem: The database filename can not contain the following 3 characters: [ (open square brace), ] (close square brace) and ' (single quote)
 
I recieved it after i try'ed to change the default Providers and use another DB then default. Now i want to go back to how it was from start, if i create a user and role - i want VS 2005 to create a SQL Express DB for me. Can anyone help me? I have even tryed to reinstalled VS 2005 but it didn't help.
/Bamsen

View 1 Replies View Related

Web Site Too Slow Search

Dec 21, 2006

how can I scale the full text search system on my web site?

View 1 Replies View Related

Problem With My WebParts Site(s)

Mar 8, 2007

hi alliam trying to build an asp.net webpart site, i donot want to use SQL Server Express for it, rathar than that i planned to use an sql server 2000 database , so far after doing this my pages is getting me this errorAn error has occurred while establishing a connection to the server.
 When connecting to SQL Server 2005, this failure may be caused by the fact that
under the default settings SQL Server does not allow remote connections.
(provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance
Specified)where i surprise because i tell it in web.config to use my profile rathar than this default one, can any one tell me the secret behind thatRegards,  

View 2 Replies View Related

Updating Site/Database Once It Is Already In Use

Mar 28, 2007

I am wondering how some of you update your database once it is already been in use.  So take for example you have a few tables and users can enter data into the site.  Now suppose you either add tables to the db or you add fields to an existing table.  I am using sql express 2005 and just want to copy the db over with the copy website but it would overwrite any data users entered.Is there any easy solutions or suggestions for this.Thanks 

View 1 Replies View Related

Cannot Connect From Published Site To My DB

Apr 17, 2007

I'm getting the following error:An error has occurred while establishing a connection
to the server. When connecting to SQL Server 2005, this failure may be
caused by the fact that under the default settings SQL Server does not
allow remote connections. (provider: SQL Network Interfaces, error: 26
- Error Locating Server/Instance Specified) Here's the setup: I have a website I've published on my server, but I haven't moved the SQL DB over to the server. For some reason the testing server can't connect with sql express on my computer. I have named pipes, tcp/ip both on, connections string is "Data Source=AMBA-176SQLEXPRESS;Initial Catalog=pubs;Integrated Security=SSPI"When I'm simply testing the site locally in visual studio it can connect just fine. 

View 1 Replies View Related

Deploying The Personal Web Site

May 15, 2007

Rank newbie to ASP.NET here, so I'm totally "at sea" as to finding a "cookbook" for "how to deploy" a slightly customized version of the "Personal Web Site" project.
My hosting service has an ASP.NET database installed. I can verify from their "SQL Server Web Admin" package that there are 11 "aspnet_" table names present. I have run the "personal-add.sql" script which has defined two (empty) tables -- "Albums" and "Photos".
CONFUSION 1: The hosting service includes a Help fille for "Connecting to a SQL Server Database Using ASP.NET 2.0" which details the way to add 'connectionStrings' for "Personal" and "LocalSqlServer". I have made a "remote" copy of the "web.config" file and supplied the ostensively correct info for my Server, Database, User ID and Password. QUESTION: Why are there TWO names -- "Personal" and "LocalSqlServer"? Since all of the tables are contained now within the ASP.NET database are the details for both of these to be the same?
CONFUSION 2: Error handling. I'm getting "An application error occurred on the server. The current custom error settings for this application prevent the details of the application error from being viewed remotely (for security reasons). It could, however, be viewed by browsers running on the local server machine." Huh!? That page then goes on to mention "<customErrors mode="RemoteOnly" defaultRedirect="mycustompage.htm"/>". I've not a clue as to what "mycustompage.htm" should contain in order to field the error[s] erupting.
POINTERS, anyone? Have I missed some basic part of the manual[s] someplace? I was sort of hoping that there would be a simple "cookbook" around someplace for how to "deploy" a relatively tested group of pages (application) in a relatively idiot-proof manner. I'm not finding it, so ANY pointers, hints, URLs will be greatly appreciated.
Color me "confused in Kauai" ... :)  KevInKauai

View 2 Replies View Related

Web Site Admin Question

May 20, 2007

Hello!
 
I'm interested in using the NEW security that 2.0 has.  I had a table that has users, passwords stuff like that.  But I wanted to try this new option. I ran "aspnet_regsql.exe" wizard, which updated the schema on my db.  But when I go to Web site admin, and click on security tab, it states unable to connect to database. I have no database in my AppData folder.  Do I need to just make my own connection with a data source, like I have done for everything elses, or is there a diffrent way?
 
Rudy

View 1 Replies View Related

Updating Live Site

Jun 29, 2007

Hi:I have a site that is getting close to production.  I am using SQL Server 2005 express and VWD express.  Up to this point, I have been updating the live server by deleting the file and copying the MDF file from my development machine in its place.  This clearly won't work once the site goes live - but I still expect to be doing a lot of upgrading of stored procedures etc.  Can someone point me to a resource or make any suggestions that would help me in this regard?Thanks,Roger Swetnam 

View 3 Replies View Related

My Web Site Cannot Connect With The SQL Database

Jan 15, 2008

I am developing a web site with asp.net 2.0 and c#, using Visual Studio 2005 and Microsoft SQL Server 2005 ( I am still learning about these technologies and languages ).
I transferred my web site files to a new computer.
I created a empty SQL database called "SiteData.mdf",  I stopped the SQL server and then I replaced this database with a previous one with the same name and already populated with data.
I used this maneuver in order to avoid having to insert all data again.
The web site works fine when running inside Visual Studio, however when I try to run it in its published format it gives this error message:
Server Error in '/MA' Application.
Cannot open database "SiteData" requested by the login. The login failed.Login failed for user 'CENTAURUSASPNET'.
I also observed that inside the SQL Server Management Studio, in the database properties, it shows "ETHERASPNET" as User or Roles ( however "ETHERASPNET" was created using the old computer's name [ or should I say domain ? ]) but the permissions list correctly displays the new name "CENTAURUSASPNET".
I think that I, probably, should create a new user using the name "CENTAURUSASPNET" because it would use the name of the new computer ( or domain ) and then I should delete the old user name. Actually I tried to do that but I get the message "An object named ‘CENTAURUSASPNET' cannot be found".
So,
1) What should I do to get the database being connected with the published web site ( note: I am publishing it in my own computer for awhile ) ?
2) How do I create the new user name "CENTAURUSASPNET" ?
3) I also would like to know why the name of the database in the Server Explorer panel of VS appears as  "centaurus.SiteData.dbo" -while- inside the Object Explorer panel of the SQL Server Management Studio it appears simply as "SiteData" ?

View 2 Replies View Related

I Need Advise For The Way For Using The Datavase In A Big Site

Apr 2, 2008

hello
 
Iam building a big site for video ( like youtube )
 
and I want to store the video url in the database because as I know that is the best choice
 
but my friend advised me to store  all the video in the database for more security
I know that will take alot of space in the database
but he said ask the proffesionals
 
please give me your opinion
 
thanks

View 3 Replies View Related

DBMGR2K Download Site

Jun 23, 2005

Hello!

I've heard about a free tool for msde "dbmgr2k" can someone please help to point me to where can i download the software?

Thanks in advance!

View 2 Replies View Related

Please Help Me In Administering SQL Database On The Site.

Jul 25, 2000

I am new to the internet field. Can anybody help me in administering the SQL database on the site. Are there any tools so that I can administer the database on the site straight from my PC??? If there, please tell the URLs so that I can refer them. And please tell me other issues which are involved in administering the database on site.

How can I maintain a parellel SQL server database on my PC?? How can I take backup from my site to the SQL database which is placed in my PC?? I want to keep backup of my database in my PC.

Please help me in these issues.

Venkat Reddy
gv.reddy@usa.net

View 2 Replies View Related

Site Server, LDAP

Oct 2, 2000

Hi,
can anyone tell me how exactly sql server7 interacts with Site Server, LDAP.
I am a sql dba, trying to work with above ones. Anyone pls suggest me any book or material or ur ideas.

Thanks!

--Siva

View 1 Replies View Related

Using SQL For Navigating A Public Web Site

Apr 4, 2000

Is anyone using SQL server to navigate their public web site?
We are concerned about having a database hit every time the user chooses a different page from our navigation bar.
Any advice? Experience with this?

View 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved