Mostly he meant to say restore the database from a backup copy. Please confirm with developer if this what he meant. I guess you are new to DBA role. I...

Can you post your work in progress query. It will be easier to work on it

nice article.

Nice article. It really does not matter if things are all over the internet. I appreciate you taking the time and writting the article. I am sure atleast one of...

Q: What’s the different between char() and varchar()?

A: char() only holds letters while varchar() holds letters and numbers.

Experience: This DBA has 8yrs.

If I hear such answer even from a person...

I did the wrapper sp but wanted to know the reason. Thanks for the explanation of why xp_sendmail was not working

Thanks James Horsley . Though the vbs code works I will be still implementing the tool as it have the error logging feature.

You...

We do not need any VB or a tool to do this

SQlServer=WScript.Arguments(0)

Filename=WScript.Arguments(1)

UserId=WScript.Arguments(2)

Password=WScript.Arguments(3)

const TrustedConnection = 256

Dim PackageDate

Dim VersionId

Dim PackageId

Set oPackage1 = CreateObject("DTS.Package2")

For each PackageInfo in oPackage1.GetSavedPackageInfos(Filename)

 If PackageDate < PackageInfo.VersionSaveDate  Then...

Thanks for the reply I have solved the version problem by changing the scripts

SQlServer=WScript.Arguments(0)

Filename=WScript.Arguments(1)

UserId=WScript.Arguments(2)

Password=WScript.Arguments(3)

const TrustedConnection = 256

Dim PackageDate

Dim VersionId

Dim PackageId

Set oPackage1 = CreateObject("DTS.Package2")

For each PackageInfo in oPackage1.GetSavedPackageInfos(Filename)

 If PackageDate <...

I think I am able to restore the DTS from storage file even with multiple package. Will post the code after I complete the project.

Thank you to all of you...

Based on the following article 

http://www.databasejournal.com/features/mssql/article.php/10894_3417651_2

I am able to restore multiple package but the problem is if the package has multiple version it fails. To specify the version in LoadFromStorageFile I...

my question is how can I get the lastest version Id using TSQL or vbs.

In VBS when I use Set objPkgInfos = CreateObject("DTS.SavedPackageInfos"). I get error of cannot create object.

Anyone know...

COALESCE is fair better than isnull and I make my DBAs use COALESCE.

Example

DECLARE @a TinyInt

SELECT ISNULL(@A,256)

This will lead into Arithmetic overflow error for data type tinyint, value...

Guys

if you can telecommute then offshore your work to India or China by paying 50% of your salary

Tao

You are correct again. I guess I should have included this as part of the article. Good I am learning the art of writing