importing from text file on another server
-
I'm new to sql server and this forum. Here's what I'm trying to do but not sure how to do it. I need to create and schedule a package that will pull three csv files from a web site (I also have ftp access to this site) and load them into a database on another server. This works fine when everything is on my developement computer but not on production servers. Any help would be greatly appreciated.
-
Sounds to me like a permissions problem. Are you scheduling these dts packages through sql server agent?
What error/s are you getting?
------------------------------
The Users are always right - when I'm not wrong! -
I haven't even got to scheduling the package yet. When I try to change the connection once I have saved the package to the production sql server, I get a file not found error. The file is on a seperate web server from the sql server. During developement both servers were running on my computer and it worked fine. So how can I set up the package to use a text file from a remote server as the source connection for a data import process? Thanks for the help.
-
Are the servers in the same domain? It is a permission problem. Make sure you have the port open between your website which is usually in the DMZ and your SQL Server, which should be outside of your DMZ. Make sure SQL Server is set up to listen to whichever port you open. I'd recommend something besides 1433 as that is the port that most hackers attack for SQL Server. Hope this helps.
Marvin
Marvin Dillard
Senior Consultant
Claraview Inc
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply