469,133 Members | 1,022 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

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

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 2067
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 Mortomer39 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.