Search results for query: *

Hi, I have the following line in my ActiveX script in a DTS package, it keeps giving me compilation error. Can anyone tell me why? MyStringPosition = InStr( 1 , v_fullfilename , 'ABC' , 1 ) Thanks, mariayx

Hi all, My ActiveX script loops on file names in a file directory and passes file name in a parameter one at a time as input source file for process in DTS package instead of specifying a fixed file name. Can anyone tell me about the syntax on how to pass the parameter for the file name? Thanks...

Hi everyone, I need to read file names in a directory on an FTP server one at a time, pass the file name as a source data file in a DTS package, then load it into SQL Server tables. Keep on doing that until all the files in the directory are read and processed. My question lies with the file...

I use SUBSTRING(@data_string, 12, 17) to get a substring from the following whole string '140PTOHCO 2DTT707904 CCONTINENTAL AIRLINES 460120030822 N' But instead of getting '2DTT707904', I got only '2DTT707'. Can someone help? Thanks, mariayx

Hi all, I need to parse a char(97) string using substring and convert it into a date. The following substring is either in 'yyyymmdd' format or a null. SUBSTRING(@data_string, 54, 8) I tried CAST to convert it to a date. But it said "Syntax error converting datetime from character...

Hi DTS gurus, I have a text source file and the data in it is supposed to go to different SQL Server tables. Is there a way of doing it? Thanks in advance for any help.