public override void AcquireConnections(object transaction)
{
bool pbCancel = false;
if (ComponentMetaData.RuntimeConnectionCollection["File To Write"].ConnectionManager != null)
{
ConnectionManager cm = Microsoft.SqlServer.Dts.Runtime.DtsConvert.GetWrapper(ComponentMetaData.RuntimeConnectionCollection["File To Write"].ConnectionManager);
if (cm.CreationName != "FILE")
{
ComponentMetaData.FireError(0, "Acquire Connections", "The Connection Manager is not a FILE Connection Manager", "", 0, out pbCancel);
throw new Exception("The Connection Manager is not a FILE Connection Manager");
}
else
{
_fil = (Microsoft.SqlServer.Dts.Runtime.DTSFileConnectionUsageType)cm.Properties["FileUsageType"].GetValue(cm);
if (_fil != Microsoft.SqlServer.Dts.Runtime.DTSFileConnectionUsageType.CreateFile)
{
ComponentMetaData.FireError(0, "Acquire Connections", "The type of FILE connection manager must be an Existing File", "", 0, out pbCancel);
throw new Exception("The type of FILE connection manager must be Create File");
}
else
{
_filename = ReturnConnectionObject(ComponentMetaData.RuntimeConnectionCollection, "File To Write", transaction);
if (_filename == null || _filename.Length == 0)
{
ComponentMetaData.FireError(0, "Acquire Connections", "Nothing returned when grabbing the filename", "", 0, out pbCancel);
throw new Exception("Nothing returned when grabbing the filename");
}
}
}
}
}
public override void AcquireConnections(object transaction)
{
if (ComponentMetaData.RuntimeConnectionCollection["File To Read"].ConnectionManager != null)
{
ConnectionManager cm = Microsoft.SqlServer.Dts.Runtime.DtsConvert.GetWrapper(ComponentMetaData.RuntimeConnectionCollection["File To Read"].ConnectionManager);
if (cm.CreationName != "FILE")
{
throw new Exception("The Connection Manager is not a FILE Connection Manager");
}
else
{
_fil = (Microsoft.SqlServer.Dts.Runtime.DTSFileConnectionUsageType)cm.Properties["FileUsageType"].GetValue(cm);
if (_fil != Microsoft.SqlServer.Dts.Runtime.DTSFileConnectionUsageType.FileExists)
{
throw new Exception("The type of FILE connection manager must be an Existing File");
}
else
{
_filename = ComponentMetaData.RuntimeConnectionCollection["File To Read"].ConnectionManager.AcquireConnection(transaction).ToString();
if (_filename == null || _filename.Length == 0)
{
throw new Exception("Nothing returned when grabbing the filename");
}
}
}
}
}
