hardcoding password instead of showing password box everytime

Dear all
Everytime, when my aspx application connect with the reports, it will also
show the password box for the input of username and password, however, can we
avoid it to show the password box? I want to implicity hardcoding the
username and password into the aspx and i don't want to show the password box
in the IEYou can use stored credentials for the data sources. In report manager, go
to the properties page of the report, click on the data sources tab and
specify a user name / pwd and click apply to store these credentials.
-- Robert
This posting is provided "AS IS" with no warranties, and confers no rights.
"Joe" <Joe@.discussions.microsoft.com> wrote in message
news:81E41716-A88F-4C3B-B785-6012F6767E9D@.microsoft.com...
> Dear all
> Everytime, when my aspx application connect with the reports, it will also
> show the password box for the input of username and password, however, can
> we
> avoid it to show the password box? I want to implicity hardcoding the
> username and password into the aspx and i don't want to show the password
> box
> in the IE
>|||No the password prompt is from I.E. it ask from the domain user password to
see whether it have the right to see the reports or not, not the data sources
password
"Robert Bruckner [MSFT]" wrote:
> You can use stored credentials for the data sources. In report manager, go
> to the properties page of the report, click on the data sources tab and
> specify a user name / pwd and click apply to store these credentials.
>
> -- Robert
> This posting is provided "AS IS" with no warranties, and confers no rights.
> "Joe" <Joe@.discussions.microsoft.com> wrote in message
> news:81E41716-A88F-4C3B-B785-6012F6767E9D@.microsoft.com...
> > Dear all
> > Everytime, when my aspx application connect with the reports, it will also
> > show the password box for the input of username and password, however, can
> > we
> > avoid it to show the password box? I want to implicity hardcoding the
> > username and password into the aspx and i don't want to show the password
> > box
> > in the IE
> >
>
>

Handling variables

I have a script task that has a ReadWriteVariable = FilePath. I am doing the following below to calculate the FilePath variable. Instead of the output being C:\Rapagator\Downloaded\RETS_Search_ResidentialProperty_20060403094343.txt, it just shows RETS_Search_ResidentialProperty_20060403094343.txt. Any ideas how to resolve this problem?

Imports System
Imports System.Data
Imports System.Math
Imports Microsoft.SqlServer.Dts.Pipeline.Wrapper
Imports Microsoft.SqlServer.Dts.Runtime.Wrapper

Public Class ScriptMain
Inherits UserComponent
Public GetFilePath As String = ""

Public Overrides Sub Input0_ProcessInputRow(ByVal Row As Input0Buffer)
GetFilePath = "C:\Rapagator\Downloaded" + Row.FileName
End Sub
Public Overrides Sub PostExecute()
Variables.FilePath = GetFilePath
MyBase.PostExecute()
End Sub

End Class

How do you know the variable value is only the filename part you state? You cannot debug inside the Script Component, so perhaps add a MessageBox or log an event to write out the values you have just to be sure. Perhaps set a breakpoint as well and add the variable to the watch window. You do know that the Variables window only shows design-time values during runtime, even when completed or stopped on a breakpoint. Use the watch window to get real values. This does seem rather strange, are you only expecting one row to flow through this component; otherwise you will only store the last row's value in the variable. Is that what you want?

Does the filename start with a "\" ? If not the path looks invalid - C:\Rapagator\DownloadedMYFILE. Top tip, use System.IO.Path.Combine(x, y) as that will sort out path qualifiers for you.