|
I've successfully created an xls import (using the wizard) via SSMS and saved it in sql under msdb on the sql server. I'm able to see it and run it via the sql integration services under stored packages/msdb successfully. The import package locates and retrieves the xls file automatically (no variables - it's always saved and named the same)
I'm trying (unsuccessfully) to run the package through asp.net via an sql stored procedure. I've been futzing with it a bit trying different things... nothing working yet, I keep getting at -1. Can anyone help me out? I've read the articles, but I'm a bit lost.
The .net is:
Dim cmd As New Data.SqlClient.SqlCommand("gme.dbo.sp_housingImport", cn)
cmd.Connection.Open()
myReturn = (cmd.ExecuteNonQuery)
Response.Write("myReturn=" & myReturn.ToString)
Stored procedure:
DECLARE @ServerName NVARCHAR(100)
DECLARE @cmd NVARCHAR(4000)
DECLARE @jid UNIQUEIDENTIFIER
DECLARE @jname NVARCHAR(128)
DECLARE @jobName NVARCHAR(128)
DECLARE @FileLocation as varchar(500)
-- Create a unique job name
SET @ServerName = CONVERT(sysname, SERVERPROPERTY(N'myServerName'))
SET @jname = CAST(NEWID() AS CHAR(36))
SET @jobName = @jname
SET @FileLocation = 'E:\\myfolder\excel.xls'
--set the name and location of the ssis package to run.
SET @cmd = '"F:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTExec.exe" '
SET @cmd = @cmd + '/DTS "\MSDB\housingImport" '
SET @cmd = @cmd + '/SERVER ' + @ServerName + ' '
SET @cmd = @cmd + '/CHECKPOINTING OFF '
-- Specify ssis variable value in the package that represents the location of the input file to load
SET @cmd = @cmd + '/SET "\Package.Variables[User::varInputFile].Value";"' + @FileLocation + '" '
-- Create job
EXEC msdb.dbo.sp_add_job
@job_name = @jname,
@enabled = 1,
--@category_name = 'housingImport',
--deletes the job when it is done, regardless of whether or not it was successful
@delete_level = 3,
@job_id = @jid OUTPUT
--Add the job to the Sql Server instance
EXEC msdb.dbo.sp_add_jobserver
@job_id = @jid,
@server_name = '(local)'
--Add the step to the job that invokes the ssis package
EXEC msdb.dbo.sp_add_jobstep
@job_id = @jid,
@step_name = 'Execute DTS',
@subsystem = 'CMDEXEC',
@command = @cmd
-- Start job
EXEC msdb.dbo.sp_start_job @job_id = @jid
|
|
|
|
|
|
Nope, that doesn't do it.
|
|
|
|
|
|
Vuyiswa Maseko,
Thanks for the reply.
Tried to follow these two articles:
http://www.dotnetfunda.com/articles/article786-how-to-execute-ssis-packages-in-csharp-aspnet--part-i-.aspx[^]
http://www.dotnetfunda.com/articles/article795-how-to-execute-ssis-packages-in-csharp-aspnet-part-ii-.aspx[^]
And I'm still having problems. I went back using BMI and created the package. Executes fine. Went into VS2008, and ran the following code:
Try
Dim pkg As New Microsoft.SqlServer.Dts.Runtime.Package
Dim app As New Microsoft.SqlServer.Dts.Runtime.Application
'Dim sResultDts As DTSExecResult
pkg = app.LoadPackage("F:\Program Files\Microsoft SQL Server\90\DTS\Packages\housingImport2\housingImport2\Package1.dtsx", Nothing)
pkg.Execute()
Catch ex As Exception
Response.Write(ex.ToString)
End Try
I have no rows in my table and no error written to the screen. If I go into the SQL Mgmt Studio under Integrations Services, store packages, file system, housingImport2, housingImport2 and run package1.dtsx, I get 89 rows.
Any help?
|
|
|
|
|
Good Evening janetb99
Does your package Accept any parameters ?
If you run your package from SQL as a job it runs fine. I suggest you stepinto the code and debug it and see when it fails and tell me if it go through the exception.
One more thing i see you have used a different class for exception try to mimic my code a little bit and use
catch (DtsException ex)
and you will see there is somewhere in your code where it will give an exception.
Vuyiswa Maseko,
Spoted in Daniweb-- Sorry to rant. I hate websites. They are just wierd. They don't behave like normal code.
C#/VB.NET/ASP.NET/SQL7/2000/2005/2008
http://www.vuyiswamaseko.com
vuyiswa@its.co.za
http://www.itsabacus.co.za/itsabacus/
|
|
|
|
|
I have created my reference.cs and Reference.svcmap from a wsdl file without having the site. While I can see under service references the service name however I can't open it in the browser. Can I create a site in my localhost just from the wsdl? If yes then how can do it?
Thanks
|
|
|
|
|
First, wsdl as a title is insufficient. Keep the subject line brief, but descriptive.[^]
gerom77 wrote: Can I create a site in my localhost just from the wsdl?
You apparently need to learn much more about web services. No, you can't create a site from a wsdl file. This file is generated by the service to describe its functions.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Thanks for that Mark,
Sorry I am new to it.
Mark Nischalke wrote: You apparently need to learn much more about web services. No, you can't create a site from a wsdl file. This file is generated by the service to describe its functions.
Does it mean if I call the functions inside the reference.cs will not work? How can I test it then?
At the botton of the wsdl has the following end point
<wsdl:service name="ProcessflowServiceService">
<wsdl:port name="Processflow" binding="impl:ProcessflowSoapBinding">
<wsdlsoap:address location="http://localhost:8080/Work/services/Processflow"/>
</wsdl:port>
</wsdl:service>
What is the use of it if I can't create it under my localhost?
Thanks again
|
|
|
|
|
gerom77 wrote: Does it mean if I call the functions inside the reference.cs will not work?
How did you obtain this wsdl file?
If the service is not available at the location specified then of course it won't work 
If you have a webservice or WCF application at http://localhost:8080/Work/services/Processflow, then yes, you can test it, if not, you need to create the service at that location.
Have you done any research on web services at all?
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Thanks again Mark,
Mark Nischalke wrote: How did you obtain this wsdl file?
It was send to me via email, so I put it into my c: drive and that way I have created the proxy
Mark Nischalke wrote: you need to create the service at that location.
Can I create it based on wsdl?Is it possible?
Mark Nischalke wrote: Have you done any research on web services at all?
Yes, but this is my first time I try to use web services from wsdl
Your help is much appreciated
|
|
|
|
|
gerom77 wrote: Can I create it based on wsdl?Is it possible?
I've already answered that, NO!!
gerom77 wrote: Yes, but this is my first time I try to use web services from wsdl
You have no clue what you are talking about.
Now go away learn about web services, how to create them and use them.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Mark Nischalke wrote: You have no clue what you are talking about.
Nice way of putting it
Mark Nischalke wrote:
Now go away learn about web services, how to create them and use them.
Keep the advice to yourself
|
|
|
|
|
gerom77 wrote: Keep the advice to yourself
I don't have to go away and learn about web services, you do 
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
Hi..
I have a requirement, I want to set Analog clock and display it on screen as per the time I enter in textbox.
I will be entering the time in HH:MM:SS, and clicking the button will turn the analog clock as per the given time.
Do we have any control in asp.net, or do u have any free source control, Pls suggest me.
thanks,
By:
Hemant Thaker
|
|
|
|
|
|
You can also use java script analog control from dynamicdrive.com
|
|
|
|
|
Hello
I'm new to Web based technology and i have to decide whether to implement using ASP.net or PHP
Here is my requirement
There will a be a Web based software which would be sold via website download.
There were 2 options
1. There will be one Web Server controlled by one person where you have the link to purchase the software. When user purchases the software, in the same Web Server virtual directory will be created and user will start using software.
2. Allow user to download the software with the setup and he will decide to host the software on his own Web Server.
I decided to go for 1st option considering the following points
If i develop my software in asp.net then since I have one Web Server which can host on IIS.
If I allow user to download and host on their web server then if they have Unix server, my website software developed in ASP.net might not work, their UNIX server might not have IIS
I understand that if it PHP based then it works on both Windows & Unix
Is my understanding right.
Please help me to decide how to go about. Are there any other points I need to consider while designing the software
Thank You for your help in Advance
|
|
|
|
|
See here [^]for a recent discussion on the merits of each platform.
In this case I would choose option 1 as it follows the software as a service model and would be better for support and maintainabilty. If you allow the software to be downloaded and installed in users system you will have to supply support for the multitude of configurations that an end user may have in addition to providing patches and and upgrades.
I know the language. I've read a book. - _Madmatt
|
|
|
|
|
In my opinion you need to go for PHP.
By developing it in PHP you are providing flexibility
to your customers in hosting aspect.
HTH
Jinal Desai - LIVE
Experience is mother of sage....
|
|
|
|
|
Instead of allowing customers to download your software and host it for themselves, sounds like you prefer to host it yourself. Given that option, your software is Software As A Service (SAAS). There are many advantages to you by going this route. #1 You only have to worry about one code base and installation, you are in complete control.
What you should consider is Multitennancy, read this on WikiPedia for general understanding, then google the topic for more (and possibly better) articles on the subject.
http://en.wikipedia.org/wiki/Multitenancy[^]
It's not easy to design and maintain SAAS, but in the long run I think you will be better off.
Good Luck. 
|
|
|
|
|
sallam 2 all;
tat is my code
<asp:Button ID="btnCaseDetailsAttach" runat="server" Text="Attach" CssClass="ButtonBlackCss" OnClientClick="return triggerFileUpload();" onclick="btnCaseDetailsAttach_Click" />
<asp:Button ID="btnCaseDetailsDetachFile" runat="server" Text="Detach File" CssClass="ButtonBlackCss" onclick="btnCaseDetailsAttach_Click"/>
<asp:HiddenField id="pathpicker" runat="server" />
<input type="file" id="File1" style="visibility:hidden;" onchange="LoadPath();" />
<asp:Label ID="lblSendMail" runat="server"></asp:Label>
<asp:GridView ID="gvCaseDetailsWebFileName" runat="server" CssClass="hor-minimalist-c" Enabled="false">
</asp:GridView>
<script type="text/javascript"language="javascript">
function triggerFileUpload()
{
document.getElementById("File1").click();
}
function LoadPath()
{
var a=document.getElementById("File1").value;
alert(a);
document.getElementById("<%=pathpicker.ClientID%>").value=a;
alert(document.getElementById("<%=pathpicker.ClientID%>").value);
return true;
}
</script>
on attach btn
gvCaseDetailsWebFileName.DataSource = null;
gvCaseDetailsWebFileName.Visible = false;
string value = pathpicker.Value;
objCaseGeneration.FilePath(value.ToString());
gvCaseDetailsWebFileName.DataSource = objCaseGeneration.dsMissingDateOfServices.Tables["CaseGeneration"];
gvCaseDetailsWebFileName.DataBind();
gvCaseDetailsWebFileName.Visible = true;
tis code only browses files bt not works and not places file name in gridview
n tis browses in internet xplorer not in mozilla y?
|
|
|
|
|
I think there is some problem in your javascript, that is why it is not
showing browse in internet explorer not in mozilla.
You need to check the error console of mozilla to track what is
the problem
Just go to Tools>Error Console in mozilla or press
Ctrl+Shift+J.
And the grid is also not binding because of the same problem.
HTH
Jinal Desai - LIVE
Experience is mother of sage....
|
|
|
|
|
te error is on tis line of code
document.getElementById
bt what should be tere i hav no idea
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
