sql server dts: Hi All,
I have a requirement to execute an SSIS package from within a stored
procedure. The package needs an incoming parameter, and from what I've
seen, I can't do this in T-SQL.

I wrote a simple c# class that uses the
Microsoft.SqlServer.Dts.Runtime objects to do this. I am able to
execute my package, and provide variables, using a test c# console
application.

However, to run this from a stored procedure, I need to create an
assembly for my code. But since my code references
Microsoft.SqlServer.Dts.Runtime, SQL Server wants me to also create
assemblies for every assembly that Microsoft.SqlServer.Dts.Runtime
references. That looks like a deployment headache and isn't likely to
fly with the DBA at our client.

Is there a cleaner way to handle this?

Hi,

I came across your post i want to do something very simalar where I
create aN C# app to do the foll.

Electronic checklist that executes SSIS packages & on completion of
package the package should return a parameter where I could update the
C# app with a Y falg or tick to indicate it was successful & then
continue with next external task, where I can manually execute the next
job as well on the c# app.

I read you post it is very simalar in what i want to do, the problem is
I'm a junior in C# & still actually studying the Teach yourself C# in
24hrs book.

Can you please assist me with this, your idea...
and I would like to know how you got to execute a SSIS package from C#.

Regards