468,771 Members | 1,976 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,771 developers. It's quick & easy.

Execute DTS package from asp.net

How can I execute a DTS package from an asp.net page?

I found the code below online, and altough it throws no errors, it doesnt
execute the dts package either?

What am i missing?

Package2Class package = new Package2Class();
object pVarPersistStgOfHost = null;

this.iptFile.PostedFile.SaveAs("C://temp//test.xls");

package.LoadFromSQLServer(
"SERVER",
"sa",
null,
DTSSQLServerStorageFlags.DTSSQLStgFlag_Default,
null,
null,
null,
"dtsTest",
ref pVarPersistStgOfHost);

package.Execute();
package.UnInitialize();

System.Runtime.InteropServices.Marshal.ReleaseComO bject(package);
package = null;
thanks

Nov 17 '05 #1
0 1221

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

10 posts views Thread by bdwgarth | last post: by
reply views Thread by Peter Afonin | last post: by
3 posts views Thread by Peter Afonin | last post: by
1 post views Thread by rAinDeEr | last post: by
2 posts views Thread by pvong | last post: by
1 post views Thread by Marin | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.