Get A File To A FTP Site T-sql
Oct 6, 2003I 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
ADVERTISEMENT
To Post A Text File In Ftp Site
Nov 12, 2007Hi 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
Speeding Up Site By Storing Query Results In File
Mar 4, 2008Hello,
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
Integration Services :: Send File Using SSIS To FTPS Site
Jun 25, 2013I 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 RelatedReceive Files From Remote Site Only If File Does Not Exist In Local Directory
Jul 13, 2007I 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.
Error In Accessing Site Which Is Restored Using STSADM. Error-The File Exists. (Exception From HRESULT: 0x80070050)
Oct 8, 2007i 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)
Permissions Via ASP.NET Web Site
Jan 31, 2007I 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
Using ASPNETDB For All Site!
May 26, 2008Hi 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
SQL 7 And Site Serer 3.0
Feb 3, 1999Hello,
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
SQL Serverback Up To FTP Site
Oct 13, 2004Is 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
Does Anybody Look At The Jobs On This Site
Nov 17, 2004Poeple 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 RelatedDeploying A Web Site
Jun 14, 2006I 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.
Should My Site And Sql Be On The Same Server
Apr 11, 2007Hello,
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
Phishing Web Site
Dec 17, 2007How can a genuine Web Outlook url be classified by filtering software as a known phishing web site?
Thanks.
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.
Backup To FTP Site
Feb 7, 2006I want to backup my database to an ftp site. How can I do that with SQL Server 2005? Thanks.
View 1 Replies View RelatedGetting Files From An FTP Site
Apr 23, 2008Hello:
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
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.
Using Encryption Via An Asp Site. How Is It Done
Feb 18, 2007ive 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 RelatedWeb Site Admin Tool
Aug 24, 2006Hi!
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
Web Site Too Slow Search
Dec 21, 2006how can I scale the full text search system on my web site?
View 1 Replies View RelatedProblem With My WebParts Site(s)
Mar 8, 2007hi 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,
Updating Site/Database Once It Is Already In Use
Mar 28, 2007I 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 RelatedCannot Connect From Published Site To My DB
Apr 17, 2007I'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.
Deploying The Personal Web Site
May 15, 2007Rank 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
Web Site Admin Question
May 20, 2007Hello!
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
Updating Live Site
Jun 29, 2007Hi: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 RelatedMy Web Site Cannot Connect With The SQL Database
Jan 15, 2008I 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" ?
I Need Advise For The Way For Using The Datavase In A Big Site
Apr 2, 2008hello
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
DBMGR2K Download Site
Jun 23, 2005Hello!
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!
Please Help Me In Administering SQL Database On The Site.
Jul 25, 2000I 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
Site Server, LDAP
Oct 2, 2000Hi,
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
Using SQL For Navigating A Public Web Site
Apr 4, 2000Is 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?