calling sql ssis package through asp.net - ASP.NET Discussion Boards

While developing Web based software application using Software as a Service model which is the best option for development whether to go with ASP.Net or PHP
I'm experience with ASP.net but are there any issues implementing in ASP.Net

I am not sure I clearly understand your question. But one suggestion when it comes to deciding how and where to deploy your application, espeically if you want to plan for scalability, is to consider Windows Azure:

http://www.microsoft.com/windowsazure/[^]

Azure supports both ASP.NET and PHP.

Hi,

We upgraded from 4.6.2 to 4.9 recently. All is working well, it seems, except for the login / authentication module. When attempting to login, no username/password box appears and instead we are greeted with a module load warning:

Module Load Warning
One or more of the modules on this page did not load. This may be temporary. Please refresh the page (click F5 in most browsers). If the problem persists, please let the Site Administrator know.

I would recommend you to post this on their discussion forum.

On a different note, you are inviting spammers by keeping your mail id as your user name. You may consider changing it.

..Go Green..

modified on Friday, July 2, 2010 8:47 AM

Go to the module setting and check the login module is available or not. You can try with re-register the module. ( Uninstall and install it again )

Thanks !

Cheers !
Abhijit Jana | MVP
Web Site : abhijitjana.net | Follow Me @ twitter
Read my Latest Article :Mastering Debugging in VS 2010

Hey,
I've registered to the ASP.NET 70-562 MCPD exam, and I wanted to know, did someone know about http://www.ucertify.com/[^]?
Because I want to buy study guide and I wonder if that is a good one

Thanks for you help, and sorry if its not in the correct place.
Yahav.

Gindi Bar Yahav - Web & Software developer.

i don't know about that but some one reffered me this one.
http://www.transcender.com/[^]

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

Maybe you need to set the command type to StoredProcedure.

I believe it would be the 3rd Parameter of Data.SqlClient.SqlCommand

Refer to:

http://msdn.microsoft.com/en-us/library/system.data.commandtype.aspx[^]

Hope this helps.
Cool | :cool:

Nope, that doesn't do it.

I have a simple way of doing this. i have written an article months ago , where i demonstrate how you can do that in ASP.NET C#

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[^]

Hope it helps

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/

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 Roll eyes | :rolleyes:

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 Poke tongue | ;-P

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

A quck search of CodeProject gave me this ...

Analog Clock Control[^]

You can also use java script analog control from dynamicdrive.com

Gaurav Dudeja
http://www.gdinfotechindia.com

Dont be afraid of changing your life to better !

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