http://msdn.microsoft.com/en-us/library/ms141053(SQL.90).aspx

I don't believe this is possible. Even when calling SQLMaint utility directly it doesn't seem that this can be done.

http://msdn.microsoft.com/en-us/library/ms162827.aspx

You could possibly do some post-processing after the maintenance...

>>I can't pick and choose what tables to restore from a backup, correct?

I believe third party tools can do this. For example with HyperBac you can run your test...

You have to pre-process the file outside of SQL Server. Search for 'convert pdf csv' and there may be some options. Once you have a csv file all the normal...

Less than a mb and I only need to process monthly so performance is not an issue. I have complained to...

How about pre-processing the file? Just replace "" with ' (for example) and then continue with , as column delimiter and " as text qualifier as you feed the file...

Even if the backup says successful you really don't know for sure until you can successfully restore it.

After you get through this first step you may want to consider an...

I am not very familiar with OPENROWSET BULK.

I also should have mentioned that not every record would have embedded quotes. The following would be more representative.

"A","Is this a ""valid"" file...

You could also export to csv and then open the csv file in Excel.

Maybe the default trace can provide additional info.

http://www.mssqltips.com/tip.asp?tip=1739

May also be a security issue. Can you run the package directly from SSMS or does this prompt for a password?

Export the package to dtsx file format. Open in a...

Try explicitly setting the server name.

/SERVER "SERVERNANE\INSTANCENAME"

This may be an authentication error as the error message indicates. To test firewall and port issues use ping and telnet.

http://www.outlookpower.com/issues/issue200506/00001576001.html

If you can telnet to the server port...

This needs work. What are you going to do when you have...

More of a logical/business requirement than a traditional database constraint unless check constraints can perform complex checking way beyond > 100. There seems to be some branching logic going on.

Perhaps...