Search results for query: *

MDX I almost got it. I am stuck with the synatax. I want some thing like: SELECT * FROM ODS.V_ADVANCES_EOM where as_of_DATE = to_date('2009/05/31', 'yyyy/mm/dd') So far I got till here: "select * from ods.v_advances_eom where as_of_date = "to_date("+ @[User::Param_AsofDate]+"...

I am still trying to figure out this. I will post the update as soon as I am done. thanks nath

Thanks RiverGuy. The harded coded date works. Instead of hard coding the date, I want to pass the date as a parameter. I kept the data access mode as "sql command" and clicked on "parameters" button. I got the following message: TITLE: Microsoft Visual Studio ------------------------------...

I tried MSDA0ra.1 and Oracle driver This is the issue: In the OLEDB source editor screen, I chose the access mode as "sql command" and I am trying to get the data for a specific as_of_date SELECT AS_OF_DATE, DEAL_NUMBER, SCID, FHLB_ID FROM ODS.V_ADVANCES_EOM where as_of_date =...

I don't see any "parameters" tab. Please see the attachement.

I am trying right now. nath

Thanks for the response. If I go down the route of using "Data flow task", what should it contain? 1. OLEDB Data source 2. Data Conversion 3. OLEDB Data destination Correct? Where should I specify the Date parameter? I don't see any place for specifying in the OLEB data source.

Howdy folks, New to SSIS. Here is the situation. Seems to be a very simple task but I need some guidance here. Both the source and destination are oracle tables. I have an oracle table. I need to read data from source oracle table (based on a "where" condition) and insert into another oracle...

How to get the text box sting value in an excel formula

thanks . It works

so If I want to pass a string called "authorized" to my vb application, then I would say Shell("c:\newapp.exe /authorized") is that correct? and if I read in newapp.exe then I should be able see the string "authorized". am I correct . thansk nath

I am launching a VB6.0 application from MS Access 2003 application using Call Shell("K:\newapp.exe") If I want to pass command-line parameter along with the application name. How can I do that? thanks nath

I am using Oracle 8i as back-end. Date and time is stored in a field . the content of the field is 3/10/2005 5:00:03 PM I am trying to write a query (in VB 6) where I want see if the today's date matches with the date (not the time) stored in that field. this is how I wrote and it doesn't work...

Thank you. It works. nath

I am using VB6 with oracle 9i as back-end. I am using the following code to update record which has a 'Date' data type (oracle) field. The update happens correctly, but how can I store even the time in the same field? strSQL = "UPDATE xxx.AT_VRC_ADVANCES SET strSQL = strSQL & " ...

I am using transfertext method of the Docmd to basically read the contents of an ascii file whose name & path is g:\apsdata\junk\dna_120104.old. right when it hits the following line of code, DoCmd.TransferText acImportDelim, , "tblGr_CallableDNIndexStage", nfile I get the error "3027 Can't...