Database Discussion Boards

Run Time Error While Execute Sql Server 2005 Integration Services package from C#

Deepu M.I5-Jun-06 15:35

5-Jun-06 15:35

Hi

I am trying to Execute an SSIS Package from C# Dot Net.

Below the code i am using.

try
{
Application app = new Application();
Package package = app.LoadPackage("DTSPackage/WinServeMonitoring.dtsx", null);
DTSExecResult result = package.Execute();
label1.Text = "Package Execution " + result.ToString();

}
catch (Exception exp)
{
label1.Text = exp.Message.ToString();
}

I have added reffrence for DTS Run time (using Microsoft.SqlServer.Dts.Runtime;)

But I am getting an Error like this

Error 1 'Application' is an ambiguous reference between 'System.Windows.Forms.Application' and 'Microsoft.SqlServer.Dts.Runtime.Application' C:\Documents and Settings\vahqmd10\My Documents\Visual Studio 2005\Projects\WindowsApplication1\WindowsApplication1\Form1.cs 23 17 WindowsApplication1

Error 2 'Application' is an ambiguous reference between 'System.Windows.Forms.Application' and 'Microsoft.SqlServer.Dts.Runtime.Application' C:\Documents and Settings\vahqmd10\My Documents\Visual Studio 2005\Projects\WindowsApplication1\WindowsApplication1\Form1.cs 23 39 WindowsApplication1

Error 3 The type 'System.Windows.Forms.Application' has no constructors defined C:\Documents and Settings\vahqmd10\My Documents\Visual Studio 2005\Projects\WindowsApplication1\WindowsApplication1\Form1.cs 23 35 WindowsApplication1

Can any one Help me !

Regards

Deepu M.I

time in sql server

MohamadJaber5-Jun-06 9:28

MohamadJaber

5-Jun-06 9:28

I create a triggers but I need to add the time
how can I get the time NOW from sql server
thanks

dadax

Re: time in sql server

Michael P Butler5-Jun-06 9:53

Michael P Butler

5-Jun-06 9:53

GetDate() will return the current date and time. It is easy enough to just get the time portion from the returned DateTime

Michael

CP Blog [^] Development Blog [^]

Password !

MohamadJaber5-Jun-06 8:13

MohamadJaber

5-Jun-06 8:13

I have a table contain ( username,password )
and I'll save that password encrypted in the database

how can I do this ?
thanks

dadax

Re: Password !

Colin Angus Mackay5-Jun-06 8:37

Colin Angus Mackay

5-Jun-06 8:37

Encrypt the password first and then save it in the database like anything else.

"On two occasions, I have been asked [by members of Parliament], 'Pray, Mr. Babbage, if you put into the machine wrong figures, will the right answers come out?' I am not able to rightly apprehend the kind of confusion of ideas that could provoke such a question."
--Charles Babbage (1791-1871)
My: Website | Blog

Re: Password !

MohamadJaber5-Jun-06 8:48

MohamadJaber

5-Jun-06 8:48

How can I encrypt it ?
( from SQL )

dadax

Re: Password !

Colin Angus Mackay5-Jun-06 8:52

Colin Angus Mackay

5-Jun-06 8:52

MohamadJaber wrote:
How can I encrypt it ?
( from SQL )

As I already said "Encrypt the password first" then put it in SQL. You cannot encrypt it in SQL without using extended stored procedures in SQL Server 2000 or using CLR stored procedures in SQL Server 2005. Either which way the encryption process does not happen in SQL code.

Re: Password !

MohamadJaber5-Jun-06 8:56

MohamadJaber

5-Jun-06 8:56

sorry annoyance you but plz can you tell how can I enrypted and decrypted it using CLR stored procedures in SQL Server 2005
thanks anyway for you help

dadax

Re: Password !

Stephan Samuel6-Jun-06 3:53

Stephan Samuel

6-Jun-06 3:53

You don't want to do that anyway. From a security standpoint, there's practically no value of encrypting passwords on the server if you transmit them over plaintext SQL. Anyone with a packet logger (easy) can get as many passwords as they could by finding an admin password and reading them out of your DB (hard).

Re: Password !

albCode5-Jun-06 21:39

albCode

5-Jun-06 21:39

Here u got good example how to hash password
http://www.c-sharpcorner.com/Code/2003/Feb/HashPassword.asp

Re: Password !

r.stropek5-Jun-06 22:38

r.stropek

5-Jun-06 22:38

You don't need CLR stored procs to encrypt or decrypt. SQL 2005 has encryption built in. Take a look at my blog at http://www.cubido.at/Blog/tabid/176/EntryID/34/Default.aspx. There you can find an example including a mind map describing SQL 2005 encryption functions.

Regards,
Rainer.

Rainer Stropek
Visit my blog at http://www.cubido.at/Blog/tabid/176/BlogID/4/Default.aspx

What is the query to take value stored in variable

Syed Ali Raza5-Jun-06 5:01

Syed Ali Raza

5-Jun-06 5:01

hi
What is the query to take value stored in variable

this value comes from textbox control and then datagrid is filtered through this value
Thanks

Re: What is the query to take value stored in variable

Colin Angus Mackay5-Jun-06 5:26

Colin Angus Mackay

5-Jun-06 5:26

Something like this:

SqlDataAdapter da = new SqlDataAdapter();
da.SelectCommand = new SqlCommand();
da.SelectCommand.Connection = conn;
da.SelectCommand.CommandText = "SELECT * FROM MyTable WHERE filterColumn = @filterValue";
cmd.Parameters.Add("@filterValue", myTextBox.Text);
da.Fill(myDataSet);

Assumptions:
* You have an existing SqlConnection called conn
* The table is called MyTable
* You are filtering on a column called filterColumn
* You have a TextBox called myTextBox
* You have a DataSet called myDataSet

Does this help?

Re: Thanks

Syed Ali Raza5-Jun-06 12:05

Syed Ali Raza

5-Jun-06 12:05

Thank You Mackay

It is working ....

Thank You once again..

urgent sql, T-SQL help needed

Naveed Kamboh5-Jun-06 2:19

Naveed Kamboh

5-Jun-06 2:19

Hi Friends

I have parent child tables.

Paretnt has 10 records
child has 30 records i.e. all parent records got 3 child records.
date field in child record is unique.

Now i want to fetch records like this
parent record with last two dates of child records

Note: date is not in sequece for child records. i.e. data in child table may be entered with the gaps of years or months

help me please.

Naveed Kamboh

Re: urgent sql, T-SQL help needed

Rob Graham5-Jun-06 2:29

Rob Graham

5-Jun-06 2:29

"?Select top 2 child.date, parent.* from parent inner join child on parent.key = child.foreignkey order by child.date desc"

assumes parent has some field key that is used as 'foreignkey' in child to relate the proper records

Re: urgent sql, T-SQL help needed

Naveed Kamboh5-Jun-06 3:17

Naveed Kamboh

5-Jun-06 3:17

Thanks Graham,
it just fetches 2 recodrds
while i need 2 recods from child for each parent record.

Please if you need more explination email us. thanks

Naveed Kamboh

Problem in SQL2005 how to solve it ??

papa19804-Jun-06 22:08

papa1980

4-Jun-06 22:08

Hi every body i get this exception when i try to execude my web???

An attempt to attach an auto-named database for file C:\Web2005\BallonShop\App_Data\aspnetdb.mdf failed. A database with the same name exists, or specified file cannot be opened, or it is located on UNC share.
Please did u know where is the problem ?
good bye thank's

Transfer Data Over Phone Line

shoaibadshah4-Jun-06 20:27

shoaibadshah

4-Jun-06 20:27

I want to know how i can transfer data from one MS ACCESS table on one computer to another MS ACCESS table on another computer by using a phone line on each computer using VISUAL BASIC 6.0

Shoaib Hussain

Re: Transfer Data Over Phone Line [modified]

albCode4-Jun-06 21:01

albCode

4-Jun-06 21:01

Please read rules

Re: Transfer Data Over Phone Line

Rob Graham5-Jun-06 2:25

Rob Graham

5-Jun-06 2:25

Don't shout!

It's rude, and no one will answer you if you shout

Re: Transfer Data Over Phone Line

Garg Vikas5-Jun-06 4:34

Garg Vikas

5-Jun-06 4:34

Shoaib,
Please ..... !!!

<no comments="">

Vikas G

Vikas Garg

Re: Transfer Data Over Phone Line

Stephan Samuel6-Jun-06 3:55

Stephan Samuel

6-Jun-06 3:55

1. Install hex viewer.
2. Load Access file in hex viewer.
3. Call person on other end of phone line.
4. Read hex codes to other person so they can type them in.
5. Save file on remote end.

Error converting data type DBTYPE_DBTIMESTAMP to datetime.

dabuskol4-Jun-06 18:53

dabuskol

4-Jun-06 18:53

Hi,

I am trying to retrieve data from Oracle database using SQL server but after running the statement I encountered an error message. Need help..

select tm_tfr_no from SMSS..NI.NI_TFR_MAIN a <br />
where tm_tfr_received_date_by_lt ='2000-05-21'

Error converting data type DBTYPE_DBTIMESTAMP to datetime.

Dabuskol

help with sql query.

aakar4-Jun-06 18:45

aakar

4-Jun-06 18:45

Hi,
I am writing a query that returns me the various figures all the salesperons:

My query goes like this :

Select Usr.user_name as SalesPerson,
isnull(ReqNo,0) ReqNo,isnull(ResSubToSalesPerNo,0) ResSubToSalesPerNo,
isnull(ResSubToClientNo,0) ResSubToClientNo,isnull(InterviewNo,0) InterviewNo,
isnull(ConfirmNo,0) ConfirmNo,isnull(RejectionNo,0) RejectionNo
from
xr_user Usr
left Join
(select sales_person_id,count(requisition_date) ReqNo from xr_sales_reqs where
requisition_date between convert(varchar,'5/1/2006',101) and convert(varchar,'5/29/2006',101)
group by sales_person_id) Reg on
(Usr.User_Id = Reg.sales_person_id)
left join
(select A.sales_person_id,count(date_sub_sales_per) ResSubToSalesPerNo
from xr_sales_reqs A left join xr_candidate_links B on A.sales_req_id=B.sales_req_id
where B.date_sub_sales_per between convert(varchar,'5/1/2006',101) and convert(varchar,'5/29/2006',101)
group by A.sales_person_id) cl1 on
(Usr.User_ID = cl1.sales_person_id)
left join
(select A.sales_person_id,count(date_sub_client) ResSubToClientNo
from xr_sales_reqs A Left join xr_candidate_links B on A.sales_req_id=B.sales_req_id
where B.date_sub_client between convert(varchar,'5/1/2006',101) and convert(varchar,'5/29/2006',101)
group by A.sales_person_id) cl2 on
(Usr.User_ID = cl2.sales_person_id)
left join
(select A.sales_person_id,count(date_interview) InterviewNo
from xr_sales_reqs A Left join xr_candidate_links B on A.sales_req_id=B.sales_req_id
where B.date_interview between convert(varchar,'5/1/2006',101) and convert(varchar,'5/29/2006',101)
group by A.sales_person_id) cl3 on
(Usr.User_ID = cl3.sales_person_id)
left join
(select A.sales_person_id,count(date_of_start_entry) ConfirmNo
from xr_sales_reqs A Left join xr_candidate_links B on A.sales_req_id=B.sales_req_id
where B.date_of_start_entry between convert(varchar,'5/1/2006',101) and convert(varchar,'5/29/2006',101)
group by A.sales_person_id) cl4 on
(Usr.User_ID = cl4.sales_person_id)
left join
(select A.sales_person_id,count(date_of_rejection) RejectionNo
from xr_sales_reqs A Left join xr_candidate_links B on A.sales_req_id=B.sales_req_id
where B.date_of_rejection between convert(varchar,'5/1/2006',101) and convert(varchar,'5/29/2006',101)
group by A.sales_person_id) cl5 on
(Usr.User_ID = cl5.sales_person_id)
Where isnull(ReqNo,0) > 0 or isnull(ResSubToSalesPerNo,0) > 0 or
isnull(ResSubToClientNo,0) > 0 or isnull(InterviewNo,0) > 0 or
isnull(ConfirmNo,0) > 0 or isnull(RejectionNo,0) > 0

now I need to join 1 more table i.e. xr_client cos I need to figure out how clients has each salesperson responded to :

xr_sales_reqs and xr_client have client_id as the common field.

can anybody help me out?

Thanks in advance,
Aryan.

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