Search results for query: *

Hi unclerico, If the source file is empty EXCEL file, how to handle? Your solution example seem not work for excel file. The value of variable: line = f.ReadLine is not blank when read content of empty excel file. Wait for your reply. Thanks in advance.

Thanks unclerico, It works fine.

Hi All, My DTS package reads data from a csv file and populates it into the database. Now, if the csv file is empty, I get an error. What I need is, to check whether the file not contain any records. I know if import txt file, I can use AX Script as Set fso =...

Thanks TheJFM, It seem have to code transformation procee, I am not good at this. Can you give me some example(link).

Hello group, I want DTS import several CSV files automatically, but the source files maybe mistakenly added some additional fields by customer. I don't know how to auto-maping transformations when importing the whole file (known normal fields+unknown additional fields) to a table(predefined...

Thanks SimeonJ, Actually I find solution, Set first row and last row in DTS.

Thanks Mutley1. I have tried as you said. Works fine.

Hello friends, My project: when runing, DTS check the files in a folder,then import to Database and move away the imported file, then loop to check having any other files in folder, if no files exist, the job end. But when end, it show a message box "Successfully complete execution package...

Hello friends, I hope import the first several Rows from a Text files to database, because the first row just stores column name, I want analyses it in advance. Anyone give me a direction, I am just starting to learn DTS. Thanks

Thanks rac2, it works fine

Hi Rac2, Using union is right direction, but how to show 'Col'. For example, suppose @Col='Column', I want to using select like this: select 'Column',Column from whatever. How to do? select '@col',@col from ... , not work.

Thanks Rac2, Maybe I didn't say clearly, the Col name is unknown(col1,col2...), TableA is produced by dynamic SQL, these fields are the 'Wrong' fileds mistakenly added by customer. I got col name by checking system table(and can get number of column), they are saved in @Col. TableB is...

Hello everyone, I met a very difficult point when processing data transformation. The case is : Need import customer's data files(text) to database, the files should have certain fields(columns), but sometime customer give additional fileds. These additional fields should be recorded to...

Thanks friends. Your solutions work fine. Thanks

Hello, All I get the column names of a table, using system table/system stored procedure. Now the column name(for ex, 'ExtraField', but actually unknown) stored in @col, I need check its value, but 'select @col' not work, it just show ExtraField. Anybody give me direction. Thanks

Hello All, I want to check Printer ready or not(including the printer cable is connected). I've searched all threads about printer status in this Forum and try the codes. But it still can't check Status of printer, for example, when I disconnect the printer cable, or network cable(for...

Thanks, I will try

Hello All, I use MaskedBox to input date (##/##/#### HH:MM ??). After end (lost focus), I can't change the MaskedBox text, I have to delete and reinput. I hope to change the text using backspace and input what I want to modify. Can anybody give me direction. Thanks in advance.

Hi JC, I try my code again in local server, it works fine, the SMTP is defaultly setup and I didn't use SmtpServer IP as dvannoy's code. But you should note this sentence: objMM.From="Whatever", the sender email, it must be VALID email address. And try different type of receiver email...

Hi JC, I didn't set up SMTP intendly, I am sure this code works fine to send email. I use it in our living web site. Regards znet