I'd probably just set it up - use a file like C:\MyDTSPackageName_Error.txt for the exceptions and let it run. When there are errors, the output (and the row? -...

If you need to have things consistent and no gaps, you probably won't want to use IDENTITY for that column. You can do some searches on how to find...

That actually doesn't change the settings of the table - the table will still store trailing spaces because ANSI PADDING is still on for the table. As others noted,...

Any way you can get the text quoted with "" or something similar? Perhaps have it generated with a different delimited (tab or pipe)?

If not, I don't think there's...

Is there an easier way to do this? I was bitten by this a while ago and ended up copying lots of XML and changing the code there to...

Security. I think that Jamie Thompson blogged about this when he was talking about whether to use encryption when saving to a file and similar things. Saving without...

Could you design one SSIS package to loop through all of the databases with a ForEach loop, then have separate SSIS packages that could use parameters from the parent to...

First thing I would recommend would be to limit your batch size so that you're not trying to commit the entire transaction at one time if you haven't already done...

Open the table - hit the red "Stop" button at the bottom. Edit the query the way you used to. There's no more option to Query or get...

I don't think that's going to work for you in any way I can come up with. Perhaps another file with the password. Perhaps embedding in an ActiveX...

Another possibility would be to look at the xp_smtp_sendmail extended proc written by Gert Drapers. You can use SMTP mail to send attachments directly without the CDO and profile...

One other thought on the programming aspect. It's amazing what you can do with a database, some stored procs, DTS, and a little ingenuity. I've built some apps...

Well, if you've been following the MS official DBA path, they've split it into three paths: DB Admin, DB Developer, DB Knowledge Worker (Bus Intel, reports, OLAP type stuff).

What...

Thanks. That's kind of what I suspected, but wanted to verify. I have other routing in a lot of my jobs such that we don't want the whole...

OK - I'll admit that I knew a lot of those according to their facts, but I will disagree with the ADHD quote. ADHD is quite real, if seriously...