Why not just add them to the db_datareader role in the database?

ISNUMERIC should get you most of the way there, but it will return 1 if it can be converted to any of these data types:

int

numeric

bigint

money...

Check out this article:

http://blogs.msdn.com/b/sqlcat/archive/2013/09/10/diagnosing-transaction-log-performance-issues-and-limits-of-the-log-manager.aspx

Create a table that has the same column definitions as your source and add 2 additional columns (ErrorCode int, ErrorColumn int). Add a destination connection in your package. grab the...

Have a look at sys.key_constraints, sys.foreign_keys, and sys.foreign_key_column

Sorry, I posted the wrong thing...

Not completely sure what your end results need to be, but to strictly get a list of EMPIds that are listed more than once without the same DOB, this would...

no, but you can do this:

alter schema DB_SQL transfer dbo.Tablename

create table DB_SQL.Table_new(col definitions)

or you could create the dbo table and do this:

alter schema DB_SQL transfer dbo.Table_new

Use the MAXERRORS option and set it to a really high number.

You need to go back to your original window to see the output. All output is sent to the original window (it says debugging on the tab).

Edit the job step and choose operating system (cmdExec) instead of SQL Server Integration Services Package. Then set your command line to something like this:

C:\Program Files\Microsoft SQL Server\100\DTS\Binn\DTExec.exe /F "c:\packagepath\packagename.dtsx"

Your...

Did the backup you restored come from a different server? If so, you probably have orphaned users. Try going through your users and running sp_change_users_login 'update_one','username','loginname'

The default trace keeps 5 files, and they roll over at about 20MB. This means the time frame that is available varies according to how many transactions you have going...

run dbcc opentran(databasename) to see what the oldest running transaction is. You can then use sp_who2 and dbcc inputbuffer(spid) to see what the transaction is doing and who is running...