Is there a quick way to import a txt file from an http location manually...
and then later automate the process? This is a do-not-call list that
consists only of phone numbers. I appreciate any and all pointers!!!
TIA - Rob
I know parsing json data has been discussed lots but what I want is probably a little simpler or different:
I have a URL where I can open and get the Json data.
I need to parse and load the Json data into a SQL table, and I want to use it in SSIS, not using C# or VB.NET coding.
I am on Visual Studio.NET 2008 and SQL 2008R2
I looked online and couldn't find anything to help me make this change. I want to change the default URL for reporting services to another url. Is this possible? Any assistance would be greatly appreciated.
View 3 Replies View RelatedHi All,
I have setup SSRS 2000 and gotten it to work but I am having trouble with SSRS 2005. I can't access to reportserver anywhere on the network. The only way to get to reportserver is termserv into the server and hit it with http://localhost/reportserver The server is Windows 2003 server Standard Ed. running SQL 2005 SP2 and Sharepoint Portal Server 2007. Can somebody please help? Thank you.
When i am tring to open the .NET application the following error is raised
HTTP 404. The resource you are looking for (or one of its dependencies) could have been removed, had its name changed, or is temporarily unavailable. Please review the following URL and make sure that it is spelled correctly.
I kept a start page as default.aspx, which physically exists in the application directoty but I still get the error.
Can you please help me out.
A view named "Viw_Labour_Cost_By_Service_Order_No" has been created and can be run successfully on the server.
I want to import the data which draws from the view to a table using SQL Server Import and Export Wizard.
However, when I run the wizard on the server, it gives me the following error message and stop on the step Setting Source Connection
Operation stopped...
- Initializing Data Flow Task (Success)
- Initializing Connections (Success)
- Setting SQL Command (Success)
- Setting Source Connection (Error)
Messages
Error 0xc020801c: Source - Viw_Labour_Cost_By_Service_Order_No [1]: SSIS Error Code DTS_E_CANNOTACQUIRECONNECTIONFROMCONNECTIONMANAGER. The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0014019. There may be error messages posted before this with more information on why the AcquireConnection method call failed.
(SQL Server Import and Export Wizard)
Exception from HRESULT: 0xC020801C (Microsoft.SqlServer.DTSPipelineWrap)
- Setting Destination Connection (Stopped)
- Validating (Stopped)
- Prepare for Execute (Stopped)
- Pre-execute (Stopped)
- Executing (Stopped)
- Copying to [NAV_CSG].[dbo].[Report_Labour_Cost_By_Service_Order_No] (Stopped)
- Post-execute (Stopped)
Does anyone encounter this problem before and know what is happening?
Thanks for kindly reply.
Best regards,
Calvin Lam
I am trying to import an xlsx spreadsheet into a sql 2008 r2 database using the SSMS Import Wizard. When pointed to the spreadsheet ("choose a data source") the Import Wizard returns this error:
"The operation could not be completed" The Microsoft ACE.OLEDB.12.0 provider is not registered on the local machine (System.Data)
How can I address that issue? (e.g. Where is this provider and how do I install it?)
I am attempting to import data from Microsoft Access databases to SQL Server 2000 using the DTS Import/Export Wizard. I have a few errors.
Error at Destination for Row number 1. Errors encountered so far in this task: 1.
Insert error column 152 ('ViewMentalTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Insert error column 150 ('VRptTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Insert error column 147 ('ViewAppTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Insert error column 144 ('VPreTime', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Insert error column 15 ('Time', DBTYPE_DBTIMESTAMP), status 6: Data overflow.
Invalid character value for cast specification.
Invalid character value for cast specification.
Invalid character value for cast specification.
Invalid character value for cast specification.
Invalid character value for cast specification.
Could you please look into this and guide me
Thanks in advance
venkatesh
imtesh@gmail.com
I am trying to simplify a query given to me by one of my collegues written using the query designer of Access. Looking at the query there seem to be some syntax differences, so to see if this was the case I thought I would import the database to my SQL Server Developer edition.
I tried to start the wizard from within SQL Server Management Studio Express as shown in one of the articles on MSDN which did not work, but the manual method also suggested did work.
Trouble is that it gets most of the way through the import until it spews forth the following error messages:
- Prepare for Execute (Error)
Messages
Error 0xc0202009: {332B4EB1-AF51-4FFF-A3C9-3AEE594FCB11}: An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft JET Database Engine" Hresult: 0x80004005 Description: "Could not start session. Too many sessions already active.".
(SQL Server Import and Export Wizard)
Error 0xc020801c: Data Flow Task: The AcquireConnection method call to the connection manager "SourceConnectionOLEDB" failed with error code 0xC0202009.
(SQL Server Import and Export Wizard)
Error 0xc004701a: Data Flow Task: component "Source 33 - ATable" (2065) failed the pre-execute phase and returned error code 0xC020801C.
(SQL Server Import and Export Wizard).
There does not seem to be any method of specifying a number of sessions, so I don't see how to get round the problem.
Does anyone know how I can get the import to work?
Hi,
Is it possible to write a stored procedure which can post an XML file to a server using HTTP?
Thanks!
Are HTTP Endpoints able to be reached by another application that does not run on the same network?
For example, we have a partner that has a Web Application that would like to retrieve data from our database. We would like them to call a SOAP method through the Endpoint and in essence let their Web Application consume the Web Service. Is this possible?
George writes "I wan to use a cursor to execute
let's say
'www.xxx.com/'+@mydata.....
from SQL 2005
Is that possible??
THanks in advance"
hi
i created endpoints and able to view wsdl
http://<servername>/hello_world
it's a stored procedure created in master database.
when i just try to view the output from this like
http:///<servername>/hello_world
it's giving me an error http501/http505 error.
i read in other article like, when soap is not able to process message , it'll be giving out as http errors.
my endpoint creation is as follows:
CREATE ENDPOINT hello_endpoint
STATE = STARTED
AS HTTP(
PATH = '/hello_world',
AUTHENTICATION = (INTEGRATED ),
PORTS = ( CLEAR ),
SITE = 'testserver'
)
FOR SOAP (
WEBMETHOD 'GetSqlInfo' (name='master.dbo.hello_world', SCHEMA=STANDARD ),
WSDL = DEFAULT,
BATCHES = ENABLED,
DATABASE = 'master',
NAMESPACE = 'http://testserver/hello_world'
);
GO
i already created a stored procedure hello world:
USE [master]
GO
CREATE PROCEDURE [dbo].[hello_world]
(@msg nvarchar(256)= "Hello Sql Server")
AS BEGIN
select @msg as 'message'
END
.I am not able to find any solution for this.Any help would be a great help for me.
i joined a new project , and this is the first task for me.
thanks for all
priyaram
Hello there,
I have created a login page for users. The login page contain <FORM action="verifyuser.asp" method="post">. The verifyuser page verify that the user exist in the database. All the pages, home, login, memberspage, updatemember, seems to be working properly except for the verifyuser page. This is the code for the page:
<%
Dim objConn, oRSu
Set objConn = Server.CreateObject("ADODB.Connection")
objConn.Open "Provider=SQLOLEDB.1;Persist Security Info=False;"& _
"User ID=sa;Password=test12345; Initial Catalog=members;Data Source= Kai-PC;"
dim varUsername, varPassword
varUsername = Request.Form("Username")
varPassword = Request.Form("Password")
set oRSU=server.CreateObject("adodb.recordset")
SQL = "Select * from Users where Username = '" & varUsername & "' AND
Password = '"& varPassword &"'"
oRSu.open SQL, objConn
If oRSu.EOF Then
response.redirect "Login.asp"
end if
Session("Username") = oRSu("Username")
Session("password") = oRSu("password")
Response.redirect "memberspage.asp"
oRSu.Close
set oRSu=nothing
%>
---------------------------------------------
Whenever I try to login a HTTP 500 Internal Server Error appears... I have no idea whether that caused by the codes or because I'm using Vista? Thanks
I keep getting this error when trying to create one:
This "CREATE ENDPOINT" statement is not supported on this edition of SQL Server.
I am running sbs2003 r2. Is this not supported on this server?
I have been given a requirement to post data to a Peoplesoft Http gateway, using SSIS.
To be completely honest I havn't got a clue where to start with this, can anybody give me any pointers?
Am I going to have to use a script component?
Are there any decent examples / samples.
Sorry about the open nature of this question, but I really dont know where to start.
I think Biztalk may be a better option as in integration tool for this work.
I have read a million documents on this question and I still don't get it. I would greatly appreciate any insights.
I start a new WebSite. I put these specs in web.config:
<authentication mode="Windows"/>
<identity impersonate="true" userName="AIBablh" password="blah" />
<authorization> <deny users="?"/> </authorization>
I put a ReportViewer control on my only page.
I set the URL and the ReportName and run the application which returns HTTP 401, authorization error. What else do I have to do to make this little demonstration work?
I have read entries about credentials, about delegation, about application pools, about just about everything.
Isn't this just supposed to work? This works without difficulty on a Windows form.
Much thanks.
hi,
I am new to sql so i created this http endpoint int sql 2005.
now how to use it?
for example i create stored procedure and i can use it by "execute procedurename"
how it works on endpoint side?
Is it possible for SQLServer to make a http web request in a stored procedure? I know that you can configure it to send email, but I'd rather do that on the webserver side, and that needs to be triggered by a request of some sort. I have a sp that runs nightly, and I'd like it to send out a http request when its done so that I can do further processing/send email/what have you. I haven't been able to find anything on this subject in any of the books I have, and my google-fu isn't strong enough. Thanks for any hints.
Rob
The @IMGRPNAME, if it is two words, the second word is not a weblink. ANy idea? @IMGRPNAME is declare as varchar(1000)
****************************
Set @IMGRPNAME = (select IMGrpname from IM where IMID = @IMID2)
Set @IMEmail = (select IMEmail from IM where IMID = @IMID2)
Set @IMID3 = (select IMID from IM where IMID = @IMID2)
SET @MsgText = ' has been without a last resort implementer for the past 24 hours. Please click here to assign a last resort implementer: http://ssx_emps.aspx?imid=' + @IMID3 + '&imgrpname=' + @IMGrpName
SET @FullText = @IMGRPName + @MsgText
EXEC master.dbo.xp_sendmail
@recipients = @IMEmail,
@Message = @FullText,
@Subject = 'SAMS Implementation Group needs attention'
Hello SQL gurus.
I just wanted to kmow if we can connect a SQL server DB , located at some remote geographical location, via HTTP protocol.
Thanks in advance.
Ankit
Ok What I am looking to do is add http:// to all fields in a table that do not already begin with http://.
The query I have come up with so far is the following.
However it does not work and I am hopeing that somone that knows what they are doing can give a new guy a hand please.
UPDATE Company
SET Company.URL = 'http://' + CompanyURL
WHERE Company.CompanyURL
IN(SELECT Company.CompanyURL
FROM Company
GROUP BY Company.CompanyURL
HAVING (((NOT LEFT(Company.CompanyURL,7) = 'http://'))))
Hi, I need help.
I created a report via Rpt services wizard.
I can execute the report via Start Debugging.
I would like to deploy the report so that i can view it via http://
I need to call the report via external app & pass parameters.
This is what i selected in wizard.
Report server: http://za001b78ad82c4/ReportServer
Can anyone please assist or have an example on how to.
Regards,
I have the need to have a client application connect to a remote database server for retrieval of large datasets (~13000 rows at time) and am trying to leverage existing technologies to build my solution.
To test the difference in retrieval times I created 2 test apps - testA and testB. I created an HTTP endpoint in SQL Server (2005) that exposes one web method corresponding to a sproc that executes one select query and configured testA to execute query and bind the results to a data grid. I exposed my SQL Server so that I could connect directly to the SQL Server using a connection string and configured testB to execute the same SQL statement in an ad-hoc fashion, binding the results to a data grid.
On average, the HTTP endpoint would take ~ 34 seconds to return the 13,000 row data set whereas the direct connection returned that same result set in 4 seconds or less.
I have a bunch of questions:
* Why would I be seeing such a dramatic difference in the retrieval times?
* How is SQL Server communicating when there is a direct connection?
* What are the immediate disadvantages to connecting directly to the remote SQL Server?
* If I were to consider allowing my client application to communicate directly with the SQL Server, is there any way to secure the communication without VPN?
* In addition, is it even possible to create a SQL login that has all of these requirements?
** select and update only
** cannot view schema (cannot connect to the SQL Server using SQL Server Management Studio)
** cannot view any system tables
** cannot retrieve any information about the schema of the database whatsoever
I guess I'm wondering if there is a way to overcome the obvious serialization overhead that comes with the HTTP endpoint to get the speed of the direct connection while being secure at the same time. Is that being greedy? :P
Anyhow, what are your opinions? I'm very interested to hear experiences and/or advice.
Thanks,
Paul
Hi. Does anybody know why I'm getting the following error when I go to http://localhost/reportserver in a browser? is there a problem with how to setup permission or Windows Vista?
Server Error in Application "Default Web Site"
HTTP Error 404.0 - Not Found
Description: The resource you are looking for has been removed, had its name changed, or is temporarily unavailable.
Error Code: 0x80070002
Notification: MapRequestHandler
Module: IIS Web Core
Requested URL: http://localhost:80/reportserver
Physical Path: C:inetpubwwwroot
eportserver
Logon User: Anonymous
Logon Method: Anonymous
Handler: StaticFile
Most likely causes:
The directory or file specified does not exist on the Web server.
The URL contains a typographical error.
A custom filter or module, such as URLScan, restricts access to the file.
What you can try:
Create the content on the Web server.
Review the browser URL.
Create a tracing rule to track failed requests for this HTTP status code and see which module is calling SetStatus. For more information about creating a tracing rule for failed requests, click here.
More Information... This error means that the file or directory does not exist on the server. Create the file or directory and try the request again.
Server Version Information: Internet Information Services 7.0.
Hi,
I'd like to know how can I setup the SSL so I can secure my HTTP Endpoint.
I saw in the documentation that some settings such as SSL_PORT and PORTS should be set to SSL port number and SSL but I did not find out anywhere where they explain how to enable SSL.
Do we enable SSL the same way we enable it or SQL Server 2005 or does that have to be done through the MMC - Certificates.
I don't have any IIS server running on this server, so I was wondering if IIS is a requirement to generate and import the certificate.
I appreciate your help and comments.
Bruce.
Hi All,
I met some problems when I walk through a example for Native Http SOAP in SQL Server 2005 for Developers. after I create the HTTP EndPoint in the Management Studio using following code:
USE AdventureWorks
GO
CREATE PROCEDURE EmployeePhoneList
AS
SELECT C.LastName, C.FirstName, C.Phone
FROM Person.Contact AS C
INNER JOIN HumanResources.Employee AS E
ON C.ContactID = E.ContactID
ORDER BY C.LastName, C.FirstName
GO
DROP ENDPOINT HRService;
GO
CREATE ENDPOINT HRService
STATE = STARTED
AS HTTP
(
PATH='/HumanResources',
AUTHENTICATION=(INTEGRATED),
PORTS=(CLEAR)
)
FOR SOAP
(
WEBMETHOD 'EmployeePhoneList'(name='AdventureWorks.dbo.EmployeePhoneList'),
DATABASE='AdventureWorks',
WSDL=DEFAULT
)
then I can see the web service is indeed created by using following cmnd,
SELECT *
FROM sys.endpoints
SELECT *
FROM sys.soap_endpoints;
SELECT *
FROM sys.endpoint_webmethods;
but when I want to use the web service in the VS2005, I can't find it and add the web reference. Any help will be greatly appreciated. and could you please tell me how to check web services in the local computer? Thanks.
Chris
Hi everyone,
I am currently using the OPENROWSET command to read a XML file.
-- Use OPENROWSET to read an XML file from the file system
SELECT @xml = BulkColumn
FROM OPENROWSET(BULK 'c:file.xml', SINGLE_BLOB) TempXML
However, the file I wish to process is being generated externally and published through a web server. The file is constantly being updated, and I need to have the latest data frequently. Is it possible to do something along the lines of:
-- Use OPENROWSET to read an XML file from the file system
SELECT @xml = BulkColumn
FROM OPENROWSET(BULK 'http://webserver/file.xml', SINGLE_BLOB) TempXML
If it is not possible, can someone recommend the best method to copy/download the file? I have considered standalone Windows Services and utilizing SQL Server. Are there significant pros or cons to either approach? Are there other methods I am not awere of? Any feedback on this would be greatly appreciated.
Thanks,
Matt K.
Hi
View 10 Replies View RelatedI'm looking for a way with Integration Services in SQL'05 to upload a file. How could I do this? Is there any examples out there?
This partuclar HTTP Server has WEBDAV configured so if I could just point to the URL location and new FILE that would be excellent.
Thanks
Hi,
I'm looking into hosting SQL Server endpoints on Vista. Unfortunately they don't work nicely because, as far as I know, they require http.sys which is part of Windows Server 2003. Hence, I can create my endpoint but i can't browse to it over http.
So, siple question (not so simple answer) how can I access SQL Server endpoints on Vista?
Thanks
Jamie
Hello, I have problems consuming webservice, I was following this page.
http://codebetter.com/blogs/raymond.lewallen/archive/2005/06/23/65089.aspx
but in the intelisense the method returns an array of objects[], So I have a problem with this line.
localhost.GetEmployees sd = new localhost.GetEmployees();
sd.Credentials = System.Net.CredentialCache.DefaultCredentials;
DataSet ds = (DataSet)(sd.EmployeeList());------> IT CANT CONVERT.
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
Error 1 Cannot convert type 'object[]' to 'System.Data.DataSet' c:inetpubwwwrootatlas1Default.aspx.cs 18 22 http://localhost/atlas1/
Hi I have problems when I try to see http://localhost/Reports/ send the follow message:
Failed to access IIS metabase.
Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.
Exception Details: System.Web.Hosting.HostingEnvironmentException: Failed to access IIS metabase.
The process account used to run ASP.NET must have read access to the IIS metabase (e.g. IIS://servername/W3SVC). For information on modifying metabase permissions, please see http://support.microsoft.com/?kbid=267904.
I tried diferent commands
aspnet_regiis -u
aspnet_regiis -i
aspnet_regiis -ga ASPNET
that I found in the web but the problem is the same.
Someone can help me please?
Thank you.