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.

What happens after the Script Task - does the process try to run the dataflow, regardless of the existence of the file? Or have you used precedence constraints to send...

So bring the dates in as strings, and in the dataflow use a data conversion to convert to date. Then set the Error behaviour to be Redirect Row - to...

Lynn Pettis (3/17/2010)

---

Flat files would be smaller and faster to receive. It really comes down to preference. Not having had to work with XML files (yet) and having...

Maybe. You should check your data...

Thanks for posting that link - good info.