Can anybody help me.

I am using an oledb source. the query is coming from a variable. The database to which oledb source is connected is Oracle.

Mt variable contains the following query:

"SELECT REQUEST_ID FROM COMPLIANCE_REQUEST

where LOAD_TMSTP between (select max(END_TMSTP) FROM BATCH_JOB_LOG) and

TO_DATE("'+RIGHT("0" + (DT_STR,4,1252)DATEPART( "dd" , @[System:tartTime] ), 2) + "-"+RIGHT("0" + (DT_STR,4,1252)DATEPART( "mm" , @[System:tartTime] ), 2) + "-" +RIGHT("0" + (DT_STR,4,1252)DATEPART( "yy" , @[System:tartTime] ), 2) + " " +RIGHT("0" + (DT_STR,4,1252)DATEPART( "hh" , @[System:tartTime] ), 2) + "." +RIGHT("0" + (DT_STR,4,1252)DATEPART( "mi" , @[System:tartTime] ), 2) + "." +RIGHT("0" + (DT_STR,4,1252)DATEPART( "ss" , @[System:tartTime] ), 2) +'",'DD-MM-YY HH24.MI.SS')"

I am getting error as :

Error at Data Flow Task [OLE DB Source 2 [2177]]: No column information was returned by the SQL command.

Error at Data Flow Task [OLE DB Source 2 [2177]]: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80040E4A.
An OLE DB record is available. Source: "OraOLEDB" Hresult: 0x80040E4A Description: "Command was not prepared.".

Error at Data Flow Task [OLE DB Source 2 [2177]]: Unable to retrieve column information from the data source. Make sure your target table in the database is available.

(Microsoft Visual Studio)

i CHECKED. THE TABLE TABLE NAME, COLUMN NAME ARE CORRECT.

pLEASE HELP ME RESOLVE THIS ISSUE.

Thanks

There are all these emoticons in your code....

And Yet ANOTHER Reason not to use SSIS

it is start time

The source database does not appear to be SQL Server. What platform (DB2, Oracle, MySQL, etc) is the source database running on?

-PatP

We are migrating/rewriting an application running on SQL Server 2000 to SQL Server 2008 R2. We were planning to migrate the many DTS packages to SSIS.

I can't tell if you were just kidding. Are there better ways to do batch processing than by using SSIS on a SQL Server?

hi pat

the database is oracle

Brett is decidedly "old school" on a lot of issues. He comes from a DB2 / COBOL environment where he's quite comfortable. His ideas work, and work well for him. Brett's ideas would cause the folks that are accustomed to GUI tools and automation to have fits.

Both camps (Brett's and the current tool based concept from Microsoft) work, and can work from very poorly to very well depending on their implementation. There's nothing wrong with 100% coded solutions and I often prefer them myself, but they require more disipline and training to make them work well. There's nothing wrong with using the GUI tools and code generators, as long as you understand what the tools are doing "under the hood" so that you can make good choices. It is easier for most people to pick one methodology (code versus tools) and stick with that methodology, but some of us do use both of these methodologies and more!

-PatP