/// <summary>
/// Gets the DTS package version info.
/// </summary>
/// <param name="serverName">Name of the server.</param>
/// <param name="packageName">Name of the package.</param>
/// <param name="userName">Name of the user.</param>
/// <param name="passWord">The pass word.</param>
/// <param name="Auth">The auth.</param>
/// <param name="LatestPackage">if set to <c>true</c> [latest package].</param>
/// <returns>Returns version information as a string.</returns>
public string GetPackageVersionInfo(string serverName, string packageName, string userName, string passWord, authTypeFlags Auth, bool LatestPackage)
{
int verMajor;
int verMinor;
int verBuild;
string verComments = null;
string retval = null;
oPackage.GetDTSVersionInfo(out verMajor, out verMinor, out verBuild, out verComments);
retval = "SQL Version information: " + verMajor.ToString() + "." + verMinor.ToString() + "." + verBuild.ToString() + "\n";
DTS.Application app = new DTS.ApplicationClass();
DTS.PackageSQLServer pss = app.GetPackageSQLServer(serverName, userName, passWord, ConvertFromAuthTypeFlag(Auth));
foreach(DTS.PackageInfo pi in pss.EnumPackageInfos("", LatestPackage, ""))
{
if (packageName == pi.Name)
{
retval = retval + "\nPackageName: " + pi.Name;
retval = retval + "\nPackageID: " + pi.PackageID;
retval = retval + "\nVersionID: " + pi.VersionID;
retval = retval + "\nOwner: " + pi.Owner;
retval = retval + "\nDescription: " + pi.Description;
retval = retval + "\nCreation Date: " + pi.CreationDate;
retval = retval + "\nPackage Data Size: " + pi.PackageDataSize.ToString();
retval = retval + "\n\n";
}
}
return retval;
}
/// <summary>
/// Converts from auth type flag to DTS SQL server storage type flag.
/// </summary>
/// <param name="Value">The auth type flag value.</param>
/// <returns>Returns DTS SQL server storage type flag.</returns>
private DTS.DTSSQLServerStorageFlags ConvertFromAuthTypeFlag(authTypeFlags Value)
{
if (Value == authTypeFlags.Default)
return DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_Default;
else
return DTS.DTSSQLServerStorageFlags.DTSSQLStgFlag_UseTrustedConnection;
}