I would suggest on issuing: DBCC checktable for that specific table and see if there are any rows that are corrupt that needs to be corrected.

thanks,

Fitsum

I would suggest finding what the underline cause for your transaction log file to increase by a lot, this could be caused by:

- Full Recovery Model DB without log...

Under option, make sure the "Verify backup when finished" is checked. At lease that will tell if the backup finished sucessfully and your backup data is good.

Thanks,

Fitsum

Here is a good article on how to set this up.

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

You can load the file name into a variable of the package and the rest is easy on...

Here is an article on how to do this:

http://merlecarr.wordpress.com/2011/03/29/ssis-select-distinct-from-excel-data-source/

Thanks,

Fitsum

As replayed earlier, you can change the database to single mode and then do your restore and change it back to multi mode, but the problem with that is, if...

I believe this is orphaned user, basically if you restore a production database to dev or staging, and the user only has access in prod it shows up in the...

You can use SwisSQL..

http://www.swissql.com/products/oracle-to-sqlserver/oracle-to-sql-server.html

You can right click on the properties for the SA user and show a screen shot that the password is not empty, even though it does not show for security...

You are right, I have tested it and it did not work, I ended up doing it using a temp table by creating an identity column after sorting them using...

sweet, that does it, thanks!!!

Beyond Compare does the job, we wanted to compare script task component within SSIS and this tool shows the changes between two packages.

thank you. I was hoping for a tool that does not depend on visual sourcesafe or Team foundation, but we have to go that route anyway... thanks..