executing DTS packages in C#

M

Mike P

How do you execute a DTS package from C#? I have some code that doesn't
work because the structured storage file cannot be found :

[MTAThread]
static void Main(string[] args)
{
// TODO: Add code to start application here
Package2Class package = new Package2Class();

object pVarPersistStgOfHost = null;

//loadfromsqlserver
package.LoadFromStorageFile(
"c:\\TransferTxtFileToTable.dts",
null,
null,
null,
"Test Package",
ref pVarPersistStgOfHost);

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

package = null;
}

Has anybody else had this problem, and does anybody know how to solve
it? Any help would be really appreciated.


Cheers,

Mike
 
G

Guest

null out the name of the package, as below, or correct the name by specifying
the name you named the package when you saved it.

//sample with nulled out package name
package.LoadFromStorageFile(
"c:\\TransferTxtFileToTable.dts",
null,
null,
null,
null,
ref pVarPersistStgOfHost);

--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

DTS running in C# does not work when processing olap cube 3
executing DTS packages in C# 3
Creating DTS in C# 2
C#: method with ref-to-object argument declared 2
ScrollWindowEx and drawing in C# 3
Executing a DTS Package from Access 2003 (Visual Basic) 2
Exception thrown outside debugger but not in debugger 1
Problem with Garbage Collection 3

Top