It means there is something wrong with the last row of data in the file. Generally, in a text file, it means it needs a hard-return at the end...

Do you have the database in Full Recovery mode, and do you do backups?

SQL Express doesn't do well with more than 1 or 2 users. Shouldn't stop, but I bet if you check the error logs, you'll find some high-severity issue coming...

I think your best bet is load into a staging copy of the database, copy the files to the production server, then take the production database offline and attach the...

Cool biz.

Does it give you an error, or just do nothing at all? Have you tried running it without the "no_output" option to see what that tells you?

You might be better off having a "low authority" account, and a "high authority" account. Only use the high authority one where it's needed, use the low authority one...

gcopeland (1/12/2009)

---

GSquared (1/12/2009)

---

I understand the point you are making, that clothing can say something about someone. My point is that clothing can also lie about it. It's very,...

How big are the databases? (I have a couple of thoughts on this, but need to know database size before I can suggest anything that might be intelligent.)

Have you taken a look at this discussion on MSDN:

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/d0872fb1-f933-4b40-9c51-232fbce837de/

That might have what you need.

There was a burglary in the apartment complex where I live, about 1 week before I was going out of town for a week. So, while out of town,...

If it's an SQL 2005 SSIS package, it gets stored in sysdtspackages90, not in sysdtspackages. Try there.

When you're loading the monthly data, how heavily does that hit the server hardware? If, for example, you had two instances of SQL on one machine, and you were...

If you're doing the upgrade onto a different machine, you can have the same instance name. If not, you can't.

I would tend to separate them. One main reason is that, if you expand to a point where adding a second server makes sense, it's a LOT easier to...