471,607 Members | 2,536 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,607 software developers and data experts.

Problem with executing DTS package !

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'.

Expand|Select|Wrap|Line Numbers
  1. Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application();
  2. Package dtspackage = app.LoadPackage("C:\\Package.dtsx", null);
  3. DTSExecResult result = dtspackage.Execute();
i use the code above for this...

please help...

Thank you!!!
Nov 1 '06 #1
1 2107
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'.

Expand|Select|Wrap|Line Numbers
  1. Microsoft.SqlServer.Dts.Runtime.Application app = new Microsoft.SqlServer.Dts.Runtime.Application();
  2. Package dtspackage = app.LoadPackage("C:\\Package.dtsx", null);
  3. 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
Nov 2 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

reply views Thread by J.Bijleveld | last post: by
2 posts views Thread by J.Bijleveld | last post: by
1 post views Thread by Jennie | last post: by
reply views Thread by wugon.net | last post: by
1 post views Thread by XIAOLAOHU | last post: by
reply views Thread by leo001 | last post: by
reply views Thread by MichaelMortimer | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.