Recent content by flora9090

Hi, mkal That helps. Thanks I tried to convert this global variable to the format as yyyy/mm/dd, then it can be taken and inserted into table. In fact, the smiliar issue happened before. so just give the idea here, in DTS, it's better to convert to date format as yyyy/mm/dd or yyyy-mm-dd if...

Hi, Not very sure what you want to validate. Normally, I run store procedure ( sql query) to do loading validation. Flora

Hi, I use Execute SQL Task to insert my loading audit message into the table. The sql is : insert load_msg values( ?,getdate(),'load sucessfully') I set input parameter to get data from one global variable which gets the value by reading content from one control file. (This global variable is...

Hi, That's good point. It is ok now by selecting different delimiter for row and column. Thanks a lot , SQLDenis Flora

Hi, I used TextFile (Destination) Connection to export file from the table to the text file. For TextFile Properties, I set ‘Row delimiter’ and ‘Column delimiter’ as ‘Tab’, the file has been created successfully. But when I create a TextFile (Source) Connection and try to open this file...

I met this same issue several times. Source file is a text file, but it is text file by uploading excel file into mainframe to create using 'Transform Data Task' to load data into SQL Server table, it finished successfully, but the last row is losted. Is there anyone has the same issue...

Hi, thanks for your guys tips. In fact, I have to make the macro to do it.

Want to save Excel file as text file. Since there are double quotes ,comma and space in the original excel file. and all needs to be kept as its original format. so it doesn't work save as csv or Text(tab delimited) or Formatted text(space delimited). Is there any other way that excel file can...

Hi,Chiennk, Thanks for your idea. I'll try it. It would be very helpful Flora

Hi, thanks all of you. It's really the database's problem. Those all tables have not been created. I am working on it. Once I solve it, I will post the result here. anyone's idea aslo would be appreciated. Flora

HI, christen thanks for your reply. Yes, I got that error message when I typed that one. And as your way,it looks like that Tomcat just stopped in one point. No error message or other message prompted. And checked the log file, it is " DPR-DPR-1035 Dispatcher detected an...

Hi, For open "Cognos Connection Portal". The Error encountered is "DPR-ERR-2058 The Dispatcher cannot service the Request at this time . The dispatcher is still initializing. Please Try again .Contact your administrator"" And I checked crnserver.log file, the message is below: Thread-24...

Hi,I already figure out this issue. It is because I have not configured my web server properly before.

After I ran cognos configuration, when I tried to open the page by typing "http:<localhostname>/crn"from IE, it showed "The page can not be found". And I already configured and created alias in web server(in the same pc)as Congnos installion and Configuration guide indicates. Anyone can give me...

Hi,ianhawksey, I got it. Thanks a lot Flora