I appreciate the information mrdenny.
The reason i am using the Ole DB task is because I need to issue an update statement. Actually, it is an Ole DB Statement transformation within a dataflow task.
I am wanting to duplicate the functionality of oracle sqlloader badfile. When loading a flat file, if a row in the flat file fails to load, the row is written to another flatfile called the bad file. After the loader is complete, the bad file should contain all the rows from the input file...
I have a C# application calling a .dll I created with VB6. When I execute the application interactively from explorer, it works. If I run it from the Windows Scheduler using the same credentials that I was logged on with, it fails. Is there any reason it would fail whether I ran it...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.