Problem with executing DTS package !

[helloitsme]

Hello!

I have a DTS package that copies data from a flat file source to a OLEDB destination ( a table in SQL server database). The package executes fine when the .dtsx is executed (by double clicking it), but when i try to execute it through my VC# code, the records are not copied in the database, though the result shown (by DTSExecResult) is 'success'.

Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application();
Package dtspackage = app.LoadPackage("C:\\Package.dtsx", null);
DTSExecResult result = dtspackage.Execute();

i use the code above for this...

please help...

Thank you!!!

[NandiAparna]

Hello!

I have a DTS package that copies data from a flat file source to a OLEDB destination ( a table in SQL server database). The package executes fine when the .dtsx is executed (by double clicking it), but when i try to execute it through my VC# code, the records are not copied in the database, though the result shown (by DTSExecResult) is 'success'.

Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application();
Package dtspackage = app.LoadPackage("C:\\Package.dtsx", null);
DTSExecResult result = dtspackage.Execute();

i use the code above for this...

please help...

Thank you!!!

Check to see if the file from where u are reading and writing has enough read write permission