Click here to Skip to main content
15,915,019 members
Home / Discussions / C#
   

C#

 
GeneralRe: How to sort arraylist ? Pin
Martin#4-Apr-07 22:12
Martin#4-Apr-07 22:12 
GeneralRe: How to sort arraylist ? Pin
DavidNohejl4-Apr-07 23:06
DavidNohejl4-Apr-07 23:06 
GeneralRe: How to sort arraylist ? Pin
Martin#4-Apr-07 23:09
Martin#4-Apr-07 23:09 
QuestionSoftware live update help needed Pin
pashitech4-Apr-07 0:35
pashitech4-Apr-07 0:35 
AnswerRe: Software live update help needed Pin
Christian Graus4-Apr-07 0:54
protectorChristian Graus4-Apr-07 0:54 
GeneralRe: Software live update help needed [modified] Pin
pashitech4-Apr-07 1:02
pashitech4-Apr-07 1:02 
GeneralRe: Software live update help needed Pin
Not Active4-Apr-07 3:23
mentorNot Active4-Apr-07 3:23 
QuestionHow ToExecute DTS using C#.Net Code behind ?[modified] Pin
SrinivasanPrabakaran4-Apr-07 0:35
SrinivasanPrabakaran4-Apr-07 0:35 
Hi,Smile | :)

My name is srinivasan and I am new to this DTS concept.
I have to execute the DTS package from the C#.Net Code behind.
I managed to create a small DTS Package in SQL server and execute it from SQL Server Enterprise Manager.
But I can not execute that Package from C#.Net.
Can any one help?

I’ve written a small Class for Executing the DTS but it's not working.

CLASS: Class1
Function: DtsPackage()
---------------------------------------
public void DtsPackage()
{
try
{
Package2Class Package = new Package2Class();
object pVarPersistStgOfHost = null;

Package.LoadFromSQLServer
("<server name>","<user name>","<password>",DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection,"","","","Test Package",ref pVarPersistStgOfHost);

Package.Execute();
Package.UnInitialize();

System.Runtime.InteropServices.Marshal.ReleaseComObject(Package);
Package = null;
}


--------------------------------------------------
And when I execute this I am getting an error.
__________________________________________________________________
ERROR:Sniff | :^) Sigh | :sigh:
Login failed for user '(null)'. Reason: Not associated with a    trusted SQL Server connection.                                  

__________________________________________________________________

What could be the reason?
The 'server name', 'user name' and the 'password' was also correct.
Server name is SQL Server's Name.
User Name is SQL Server's User Name.
Password is SQL Server's Password.

Thank you in advance,
Seenu.




-- modified at 6:41 Wednesday 4th April, 2007

SrinivasanPrabakaran.
Trainee Software Engineer.
Metrica Systems.
Bangalore.

Questionproblem. Pin
amaneet4-Apr-07 0:27
amaneet4-Apr-07 0:27 
AnswerRe: problem. Pin
Christian Graus4-Apr-07 0:38
protectorChristian Graus4-Apr-07 0:38 
GeneralDifference between protected and internal protected Pin
amaneet4-Apr-07 0:45
amaneet4-Apr-07 0:45 
GeneralRe: Difference between protected and internal protected Pin
Sathesh Sakthivel4-Apr-07 1:00
Sathesh Sakthivel4-Apr-07 1:00 
AnswerRe: problem. Pin
Hayder Marzouk4-Apr-07 2:52
Hayder Marzouk4-Apr-07 2:52 
QuestionAdding .dll file to C#.NET 2005 application ? Pin
Software_Specialist4-Apr-07 0:17
Software_Specialist4-Apr-07 0:17 
AnswerRe: Adding .dll file to C#.NET 2005 application ? Pin
Christian Graus4-Apr-07 0:37
protectorChristian Graus4-Apr-07 0:37 
QuestionDataset Pin
yaminilatha4-Apr-07 0:00
yaminilatha4-Apr-07 0:00 
AnswerRe: Dataset Pin
rah_sin4-Apr-07 0:39
professionalrah_sin4-Apr-07 0:39 
GeneralRe: Dataset Pin
yaminilatha4-Apr-07 1:48
yaminilatha4-Apr-07 1:48 
GeneralRe: Dataset Pin
rah_sin4-Apr-07 2:05
professionalrah_sin4-Apr-07 2:05 
QuestionHow do i access MDI parent data from MDI child? Pin
sinosoidal3-Apr-07 23:54
sinosoidal3-Apr-07 23:54 
AnswerRe: How do i access MDI parent data from MDI child? Pin
originSH4-Apr-07 2:16
originSH4-Apr-07 2:16 
GeneralRe: How do i access MDI parent data from MDI child? Pin
sinosoidal4-Apr-07 4:00
sinosoidal4-Apr-07 4:00 
Questionhow can get my friend in yahoo messanger? Pin
B.A3-Apr-07 23:28
B.A3-Apr-07 23:28 
AnswerRe: how can get my friend in yahoo messanger? Pin
Christian Graus3-Apr-07 23:47
protectorChristian Graus3-Apr-07 23:47 
AnswerRe: how can get my friend in yahoo messanger? Pin
Sathesh Sakthivel3-Apr-07 23:49
Sathesh Sakthivel3-Apr-07 23:49 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Praise Praise    Rant Rant    Admin Admin   

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