I compared the datatypes and plan to use numeric since both numeric and decimal ranges are from -10^38+1 to 10^38+1.

Thanks

Murali

I have restored the old version and playing around to fix this issue.

Thanks

Murali

I researched and added the /De "<pwd>" onto the command line and got the error "command line syntax issue should be equal to variable=value". I am unable to edit the...

Thanks Mohammed.

I tried different resolutions. The first 2 resolutions failed citing "unable to write storage file".

The third resolution of "Set the SSIS package protectionlevel property to "EncryptSensitiveWithPassword" enabled me to...

Yes, you are absolutely right. The Admin user is a domain administrator and the domain is standard. To be a local admin, I added the domain administrator

login to local users...

Yes, you are right. I did uninstall the single instance.

I compared one of our other installations and here are the changes what I made.

1. Created 2 fileshares for installing the...

First let me clarify a few things first.

1. This server is a replica of the production server and not

    the production server.

2. I have taken steps to do complete db...

I would say, it depends. In my shop, I have sql from 7, 2000 and 2005 and most of the shops will have various flavors. The best way is to...

Sure, that would make life easy but if you work on an environment wherein you do not have this software, how would you deal with it?

Writing scripts is the only...

Thanks. That's a great script which is very useful.

The good side of this script is you can monitor individual db.

The downside is the drive and path is hardcoded and if...

Thanks to all.

I do write the job output onto the dts log file and there was always the DRIVER error.

It turned out that I have defined the ODBC connectivity as ...

Thanks for checking this out.

Don't know that's the cause. There were MS hotfixes installed at 11am and the server rebooted unexpectedly @ 1:48pm.

BB is installed on the server and the...

Thank you all for your inputs. Much appreciated.

Murali

Thx David,

Your suggestion does work. Appreciate your help.

Murali

Thx guys for the update.

We have a nightly DTS job which populates data from Oracle to SQL server.

It was designed to delete all contents on the sql tables before inserting...