Recent content by jialian

Thanks for your help ... it will work for now :-)

Thanks for your response. The dts package was created using the GUI interface in SQL Server's enterprise manager. Basically, a source (SQL Server database) and a destination (another SQL Server database) and selected both of them, right click and selected transform data task. Using the...

Hi, I have an after insert trigger on a table. If I insert data into the table by writing an insert SQL statement, the trigger fires normally. If I insert data into the same table using a DTS package, the trigger does not fire. The DTS package does insert the data into the table. Is it...

Thanks for your reply. Yes ... open STDIN does force it to the terminal's keyboard. Someone else wrote "script1" (there is other logic in it) and I wanted to reuse in it without changing it so I was wondering if there were any unix shell script command that can change STDIN to read...

Hi, I have a script, named "script1", which reads from STDIN: print STDERR "Enter a character:"; open STDIN, "/dev/tty" or warn "couldn't open /dev/tty $!\n"; my($c); $c = getc(STDIN); There is a unix shell script, named "script2&quot...

You could refer to Article ID: c2009720 on Crystal's Knowledge Base. http://support.crystaldecisions.com/library/kbase.asp But have not tried it out. Hope it works.