Execute SSIS package - ASP.NET Discussion Boards

Tirthadip11-Jun-07 18:10

11-Jun-07 18:10

ASPnoob wrote:
I don't understand three lines of the code above. what does the following mean?

Dim objConn As New OleDbConnection(ConfigurationSettings.AppSettings("myDB"))

There is a Configuration file(web.config in case of web application and App.config in case of Windows application) where we can set the connection string as well as other configuration settings of our .NET solution.This is an XML file.Under the appSettings node the connection string is written with the string variable name myDB.whereever in the project you need to reference the connection string you will get it by
ConfigurationSettings.AppSettings("myDB")

Tirtha

Do not go where the path may lead, go instead where there is no path and leave a trail.

Author: Ralph Waldo Emerson (1803-82), American writer, philosopher, poet, essayist

Request.form

seemamltn11-Jun-07 12:58

seemamltn

11-Jun-07 12:58

I have a classic asp page (webfor1.asp). I did this

and in proceesForm.aspx page I have to get the data from input fields
"fvFirstName" and "fvLastName" and have to show that data in some
lables in processForm.aspx.

Should I use Request.form("fvFirstName"). but where I have to use
this form objects in ProcessForm.aspx. and How can I reffer
ProcessForm.aspx to Webform1.asp

seema

Re: Request.form

Guffa11-Jun-07 19:13

Guffa

11-Jun-07 19:13

seemamltn wrote:
Should I use Request.form("fvFirstName")

Yes.

seemamltn wrote:
ut where I have to use
this form objects in ProcessForm.aspx

Anywhere you like. The Request.Form collection is available during the entire process of creating the page.

Page_Load is generally used for this.

seemamltn wrote:
How can I reffer
ProcessForm.aspx to Webform1.asp

What do you mean? In what way would you refer to it, and why?

---
single minded; short sighted; long gone;

Listbox multi-select

certuser7611-Jun-07 12:47

certuser76

11-Jun-07 12:47

I have a listbox with multi-select options.Upon selection some rows are displayed and then i have a form passed to a child form control and upon return i loose the values. I finally managed to get the values in an array,but now i do not know how to set the values of this listbox.
When i say Listbox.selectedindex it just highlights the last value
Any help?
thanks

Re: Listbox multi-select

Venkatesh Mookkan11-Jun-07 20:09

Venkatesh Mookkan

11-Jun-07 20:09

You have to loop into to the Array and do like the below,

ListBox1.Item(i).Selected = True

Here i would be the Index of the Item with is previously selected.

Regards,
Venkatesh Mookkan.
Software Engineer, India
My: Website | Yahoo Group | Blog Spot

Pass Data

seemamltn11-Jun-07 12:02

seemamltn

11-Jun-07 12:02

I have a classic ASp Page at server. How Can I transfer the data from classic asp page from server to a Asp.net (aspx) page.copuld you please provide me coding

seema

Re: Pass Data

Sathesh Sakthivel11-Jun-07 15:33

Sathesh Sakthivel

11-Jun-07 15:33

Here are two common ways to transfer data in an ASP/ASP.NET scenario. The first is a system in which servers transfer data based on a key provided by clients. This unique key identifier allows the two servers to contact each other directly and exchange the necessary information. You might see this in a passport-style authentication system. This article, however, uses a second method of transferring data. Instead of passing a unique token through the client, the data itself will be encrypted and transferred via the client to its destination server.

Inside the DataManager.dll file, the Encryption class contains all the methods needed to encrypt data that will be transferred via the client. Behind the scenes the Encryption class uses a hash table to store key-value pairs added by calling the EncryptValue methods.

public void EncryptValue(String strKey,
String strValue)
{
data.Add(strKey, strValue);

TextWriter tw = new StringWriter();
MemoryStream ms = new MemoryStream();

serializer.Serialize(ms, data);

encryptedData = Encrypt(
ASCIIEncoding.ASCII.GetString(ms.ToArray()),
"KEY");
}

Hope this will Help you.

Regards,

Satips. Rose | [Rose]

Execute SSIS package

alexfromto11-Jun-07 11:08

alexfromto

11-Jun-07 11:08

Hi.

I have a SSIS package named TESTPACKAGE on the 2005 SQL Server.
How I can exeucte it from ASP.NET?

I found some articels that refer to Microsoft.SQLServer assembly but I use older .NET Framework version (1.1) and this assembly is not availabe for me in Visual Studio (2003).

I read something about DTEXEC command. Can I use it in the Stored Procedure to run SSIS. I used this code in the Stored Procedure to run DTS package on the previsous/older SQL Server version.

CREATE PROCEDURE dbo.exportData AS<br />
Exec master..xp_cmdshell <br />
'DTSRUN /SMYSERVER /NTESTDTS /Umyaccess /Pmypassword'<br />
GO

Thank you,

Re: Execute SSIS package

Sathesh Sakthivel11-Jun-07 15:39

Sathesh Sakthivel

11-Jun-07 15:39

Hope this will Help you.

DECLARE @cmd VARCHAR(255)

DECLARE @Wait INT

DECLARE @result INT, @OLEResult INT

DECLARE @ShellID INT

SET @Wait = 0

SET @cmd = 'DTEXEC /sq "TestSSPSPackageName" /ser <server name=""> /Set \Package.Variables[User::varTargetName].Properties[Value];"c:\dtsxTest\Test2.txt"'

-- create instance of OLE object

EXECUTE @OLEResult = sp_OACreate 'WScript.Shell', @ShellID OUT

IF @OLEResult <> 0 SELECT @result = @OLEResult

IF @OLEResult <> 0 RAISERROR ('CreateObject %0X', 14, 1, @OLEResult)

-- run package

EXECUTE @OLEResult = sp_OAMethod @ShellID, 'Run', NULL, @cmd, 0, @Wait

IF @OLEResult <> 0 SELECT @result = @OLEResult

IF @OLEResult <> 0 RAISERROR ('Run %0X', 14, 1, @OLEResult)

If @OLEResult <> 0 EXEC sp_OAGetErrorInfo @ShellID, @OLEResult

-- drop object

EXECUTE @OLEResult = sp_OADestroy @ShellID

-- I think this will run an an asynchronous process.

Regards,

Satips. Rose | [Rose]

Re: Execute SSIS package

alexfromto12-Jun-07 3:13

alexfromto

12-Jun-07 3:13

Thank you. As I understand this is a Stored Procedure, right? The other question I have is: can I just run this command separetly from my code:

EXEC master..xp_cmdshell 'DTEXEC /sq "TEST_PACKAGE_NAME" /ser TEST_SERVER'

Package doesn't accept any parameters. I created it when I was importing test.txt file and selected the option to create package on the fly. By the way how can I modify it if needed?

Thanks a lot.

Read/Writing removable HDD? [modified]

BlueChippy11-Jun-07 9:58

BlueChippy

11-Jun-07 9:58

Apols, this is probably a VERY stupid question!

I'm a C# programmer for a "living" (lol) and not done any ASP before...however I've written a couple of small apps as a hobby - but people have commented that they want to use them but don't because they don't want to download/install the .Net framework to their PC.
Seems lots of people are "scared" of .Net! Doesn't help when the app .msi is 350kb and .Net another 25MB!!

So, I thought ASP might be the answer.

The apps are for the Nike+iPod sports kit...and one of my requirements would be to read files direct from the iPod (user chosen filepath), do the processing and then write the amended files back to the iPod.

Is that possible in ASP?

Any advice VERY gratefully received...I thought I'd better ask now before diving straight in to something I know little about! lol

Thanks everyone.

-- modified at 17:22 Monday 11th June, 2007

OK, now I AM confused...I've been reading around and come across ActiveX!
What's the difference between ActiveX and an ASP.Net "control"?
Help!!!

server.tranfer

seemamltn11-Jun-07 8:37

seemamltn

11-Jun-07 8:37

When I use Server.Transfer["ProcessForm.aspx"]; my btn_click event
it gives me following error message

only assignments, call, increment, decrement, and new object expressions can be used as a statement

cannot apply indexing with [] to an expression of type 'method group'

seema

Re: server.tranfer

Tom John11-Jun-07 8:40

Tom John

11-Jun-07 8:40

Seema

Server.Transfer is a method, not an indexed property... you should use parentheses ( ) rather than square brackets [] around the parameters:

Server.Transfer("ProcessForm.aspx");

Hope this helps

Tom

Re: server.tranfer

Sylvester george11-Jun-07 21:11

Sylvester george

11-Jun-07 21:11

Please learn the syntax first before doing program.

Regards,
Sylvester G
sylvester_g_m@yahoo.com

asp:ChangePassword Failure Text

Brendan Vogt11-Jun-07 6:07

Brendan Vogt

11-Jun-07 6:07

Hi,

How do I dynamically change the failure text of the asp:ChangePassword control. Currently it displays the following text which I don't like:

Password incorrect or New Password invalid. New Password length minimum: 8. Non-alphanumeric characters required: 0.

Please can someone advise?

Regards
ma se

Re: asp:ChangePassword Failure Text

Not Active11-Jun-07 6:12

Not Active

11-Jun-07 6:12

For this and all your other questions
http://www.amazon.com/Teach-Yourself-ASP-NET-Complete-Starter/dp/0672325438[^]

only two letters away from being an asset

asp:LoginName Issue

Brendan Vogt11-Jun-07 5:53

Brendan Vogt

11-Jun-07 5:53

Hi,

I am using the asp:LoginName control, and it displays the user name corretly, but how do I modify this, or do a check, that it displays "Guest" if no one is logged on? I also want to add a <a></a> to the logged on user name so that the user is taken to his/her acount.

<asp:LoginName
ID="MySignInName"
CssClass="divider"
runat="server" />

Please can someone advise me what to do please?

Regards
ma se

asp:LoginStatus Not Displaying Sign Out Page

Brendan Vogt11-Jun-07 5:49

Brendan Vogt

11-Jun-07 5:49

Hi,

I have my asp:LoginStatus control's LogoutPageUrl property to ="~/Account/SignOut.aspx". But when I click on the Sign Out link then it takes me to the Default.aspx page. Why is this?

<asp:LoginStatus
ID="MySignInStatus"
CssClass="divider"
LoginText="Sign In"
LogoutAction="Refresh"
LogoutPageUrl="~/Account/SignOut.aspx"
LogoutText="Sign Out"
runat="server" />

Please can someone advise?

Regards
ma se

asp:Login Failure Text Colour Not Red

Brendan Vogt11-Jun-07 5:41

Brendan Vogt

11-Jun-07 5:41

Hi,

I am using a custom asp:Login control, and I am having difficulty in setting the colour of the failure text. This is what I have:

<asp:Login
ID="MySignIn"
DestinationPageUrl="~/Account/Default.aspx"
runat="server">

<LayoutTemplate>

</LayoutTemplate>

<FailureTextStyle ForeColor="Red" />

</asp:Login>

If there is an invalid sign in then the text is still black.

Please can someone advise?

Regards
ma se

Re: asp:Login Failure Text Colour Not Red

wEb GuRu...11-Jun-07 6:12

wEb GuRu...

11-Jun-07 6:12

Hey dude

You have posted lot of questions regarding login control n I hope u must have some more questions in ur mind. So its better to read about Login Control in detail from : http://msdn2.microsoft.com/en-us/library/ms178329.aspx[^].

Well if text color is always in Black then I think you have written some code for it in CSS that force label's color always to be BLACK.

All the way from Sialkot ...

How to locate controls on a web form

lune1211-Jun-07 4:22

lune12

11-Jun-07 4:22

Hi,

This is the first time I use ASP.net and I have some question:

1) I have some controls on a web form and I would like to change their location dynamically from the code based on user action. Is it possible? how?

2) Their is something that replace the MessageBox? I see that their is a snippet for MessageBox.show() but how can I use it?

Thank in advance for an answer.

Re: How to locate controls on a web form

Tarik Guney11-Jun-07 4:47

Tarik Guney

11-Jun-07 4:47

Every thing is possible but sometimes they are hard to make...

Re: How to locate controls on a web form

lune1211-Jun-07 5:05

lune12

11-Jun-07 5:05

Thanks, but this is not very helpful...
Can you give me at least, a tip or some keywords...

Re: How to locate controls on a web form

szukuro11-Jun-07 5:20

szukuro

11-Jun-07 5:20

1) Well it greatly depends how the layout itself is done. If you need a specific control, you can use the FindControl method. Then remove/add it from/to the desired collection or set its properties accordingly.

2.) Have a look at the javascript alert method. If you want to display a message after the page has loaded:

Page[.ClientScript].RegisterStartupScript(typeof(Page), "scriptname", "<script type=\"text/javascript\">alert('Your message');</script>";

For events:

CheckBox1.Attributes.Add("onclick", "alert('clicked');");

For situations where you might want to cancel postback depending on user interaction the confirm can be used

Button1.Attributes.Add("onclick", "return confirm('Are you sure you want a postback to happen?');");

How to use the function "CallByName" in asp?

Billypon11-Jun-07 4:08

Billypon

11-Jun-07 4:08

How to use the function "CallByName" in asp
Pay attention to it,please!
It is in asp,not in asp.net!!
Thanks!!!

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.