Database

select all_constraints.index_name, all_ind_columns.column_name, all_ind_columns.column_position from all_constraints, all_ind_columns where all_constraints.owner = all_ind_columns.index_owner and all_constraints.constraint_name = all_ind_columns.index_name and all_constraints.constraint_type = 'P' and all_constraints.owner = 'DBO' and all_constraints.table_name = UPPER('VARTABLE') order by all_constraints.index_name asc, all_ind_columns.column_position asc, all_ind_columns.column_name asc

//Start the SSIS Here
Application app = new Application();
Package package = null;
package = app.LoadPackage(@"C:\O!WEB_SETUP_VERSIONS\SSIS_Compiled\OMEGA.dtsx", null);
Variables vars = package.Variables;
vars["Time1"].Value = time;
vars["Time2"].Value = time;
vars["Time3"].Value = time;
vars["TTBLTYPE"].Value = THREAD_DATA[1].ToString();

ConnectionManager Omega = package.Connections.Add("OLEDB");
Omega.Name = "OLEDBConnection";
String Strcon = obj.GetConnectionString(THREAD_DATA[0].ToString());
Omega.ConnectionString = Strcon;

//package.Connections["SQLNCLI10.1"].ConnectionString = obj.GetConnectionString(THREAD_DATA[0].ToString());
//Excute Package
Microsoft.SqlServer.Dts.Runtime.DTSExecResult results = package.Execute();
String Log;

if (results == Microsoft.SqlServer.Dts.Runtime.DTSExecResult.Failure)
{
foreach (Microsoft.SqlServer.Dts.Runtime.DtsError local_DtsError in package.Errors)
{
// Log = local_DtsError.Description.ToString();

//CommonFunctions.writeLogFile(Log,true);

}
}

}

SSIS Error Code DTS_E_OLEDBERROR.   An OLE DB error has occurred. Error code: 0x80004005.\r\nAn OLE DB record is available.   Source: \"Microsoft SQL Server Native Client 10.0\"   Hresult: 0x80004005   Description: \"Login timeout expired\".\r\nAn OLE DB record is available.   Source: \"Microsoft SQL Server Native Client 10.0\"   Hresult: 0x80004005  Description: \"A network-related or instance-specific error has occurred while establishing a connection to SQL Server. Server is not found or not accessible. Check if instance name is correct and if SQL Server is configured to allow remote connections. For more information see SQL Server Books Online.\".\r\nAn OLE DB record is available.   Source: \"Microsoft SQL Server Native Client 10.0\"   Hresult: 0x80004005   Description: \"TCP Provider: No connection could be made because the target machine actively refused it.\r\n\".\r\n

startdate="23-Feb-2010 4:00PM"
startdate="24-Feb-2010 4:00PM"

select * from tablename where startdate between '23-Feb-2010' and '23-Feb-2010'