Get Great Plains' database schema, build a mapping document, then write the conversion in SSIS.

Use a UNC path rather than a mapped drive.

--edit

You could also try changing the Success Value to 1 - if you think that the batch file is executing OK.

Tim Weintz (3/24/2010)

---

Another option is to load all data into a single column and write custom code to parse it, afterwards. Similar to the idea of loading it into an...

If all else fails, you could always look at using one of these[/url].

No I haven't - I've just read about other people's pain with XML. I try to stick with good old CSV's wherever possible. So I'm not the voice of experience...

Try creating the table first (outside of the package) and then importing, to try and narrow down where the error is occurring.

That is incorrect. Full debugging features are available for...

🙂 er ... perhaps I should have...

Or add @@SERVERNAME to your SELECT statement?

I presume you meant faster.

I'd like to see the proof. 'Always' is a big call.

SSIS is optimised for data flows pretty much by default. An...

Expressions allow you to use variables, but not to assign their values.

Thanks for posting back & glad to hear of the happy ending 🙂

If you physically log in to the server as user XECC\Administrator and then execute the package through BIDS, does it execute OK?

me too!

No problem, well done for figuring it out.