Execute SSIS Package

Thank you Darren,
I will have to play around with SQL Server 2005 since I am new to it. I will
schedule a job and try to execute it via T-Sql as you suggested. I will need
some time before I can update you on this.
 >> Stay informed about: Execute SSIS Package 

Thank you Imran,
I don't even know how to use the SQL Profiler but I will try so I can find
an alternative solution. It I have any problems I will post again.
 >> Stay informed about: Execute SSIS Package 

Okay, I discovered what the SQL Profiler is all about. For execution of an
internal SSIS package I used:

[ Exec msdb.dbo.sp_dts_getpackage
N'NewPkg','00000000-0000-0000-0000-000000000000' ] but for some reason this
does not work.

I created a job and used the profiler to check the t-sql syntax. This is
what I came up with:

[ EXEC msdb.dbo.sp_start_job @job_name=N'packagename' ] this works fine.

And my original t-sql statement:

[ Exec Master..xp_cmdshell 'dtexec /f c:\data\packagename.dtsx' ] works as
well.

So I am quite happy with the help I received on this site. It was my first
post and I can say it was a great experience.

Thanks again to Darren and Imran.
 >> Stay informed about: Execute SSIS Package 

Thank you for stopping by Allan.
I wanted to execute an SSIS package at the click of a button from a web page.

I came across 3 ways of doing this, all from the click on a button. The
first was using DTExec, the second was by executing an unscheduled job and
the third was by using SqlServer.Dts.Runtime in Asp.Net 2.0.

I found that the last option was the fastest and speed is what I am looking
for.

What are your suggestions? I would really appreciate your insite.
Thank you for your intesest.
 >> Stay informed about: Execute SSIS Package 

Hello Ravi,

I would do it programmatically in that case as well. I would use the SSIS
object model to do the execution.

Allan

> Thank you for stopping by Allan.
> I wanted to execute an SSIS package at the click of a button from a
> web page.
> I came across 3 ways of doing this, all from the click on a button.
> The first was using DTExec, the second was by executing an unscheduled
> job and the third was by using SqlServer.Dts.Runtime in Asp.Net 2.0.
>
> I found that the last option was the fastest and speed is what I am
> looking for.
>
> What are your suggestions? I would really appreciate your insite.
> Thank you for your intesest.
>
 >> Stay informed about: Execute SSIS Package