Windows app in C# doesn't run if not SQLSer ins.

Question

0.00/5 (No votes)

See more:

I will really apreciate any help.
This is my case.
I have created a simple application that ask for a email and a selection from a combo box. using this information and "using Microsoft.SqlServer.Dts.Runtime" conect to an ftp and executes SSIS files. My application is working just fine if i run it locally or in any pc that has instaled sqlserver 2005 on it. But if i try tu run it in a clean pc (with not SQL server instaled) it won't run. What is fanny is that doesn't even show an error message or anything. It just doesn't run, i try look into the event viewer and not message are left either and in the task manager i can see how it start to run and inmediatly is stoped.
since it doesn't run in a pc with no sqlserver i tought that has to be with me using the component to run SSIS files, so i tried generating a SETUP project and all the dependencies are added including Mricrosoft.SQLServer.ManagedDTS.dll so I was pretty sure this will work it out. But what a sorprise, it just keeping doing the same.

Any one that can help me? i will really apreciated, i have look over the internet for almost 3 days now and i haven't found anything usefull specially because i don't have any error message to start from.
Thanks.

Posted 21-Jun-11 6:25am

Camilo Serna

Add a Solution

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Vivek Krishnamurthy · Answer 1 · 2011-06-21T07:05:00

Solution 1

Take a look at the following link. This has a detailed example and sample app.

Running an SSIS Package Programmatically on a Remote Computer[^]

Posted 21-Jun-11 7:05am

Vivek Krishnamurthy

Comments

Camilo Serna 21-Jun-11 15:31pm

Thanks Vivek, but i don't really have a problem with the execution of the SSIS package. My application actually runs great on my computer. I don't use the server agent but i do use the api mentioned on the article you sent: Microsoft.SqlServer.ManagedDTS.
My real issue es when i created the setup aplication for the one that runs the ssis files. Me setup application run ok and generates the application on any machine. But it will only work in pc that has SQLSERVER 2005 instaled otherwise will not even run.

Any ideas. Thanks a lot
any ideas