Search results for query: *

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 =...

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...

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

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...

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...

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,all I have several Dropdownlist controls(DDL1,DDL2...) in web page(for ex. Search.aspx). When select item of one dropdownlist(for ex DDL1), it redircted other page(for ex GetInfo.aspx). My question is in GetInfo page. If using browser's BACK button to return to Search page, and select...

Hi all, When I use SQL Server Enterprise, this error happen: Microsoft Management Console:mmc.exe - Application Error The exception Privileged instruction (0xc0000096) occurred in the application at location 0x00c8600c but other features such as SQL Query Analyzer work fine I thought to...

Hi all, When I use SQL Server Enterprise, this error happen: Microsoft Management Console:mmc.exe - Application Error The exception Privileged instruction (0xc0000096) occurred in the application at location 0x00c8600c but other features such as SQL Query Analyzer work fine I thought to...

Hello, in databse, a column: DrvSize nvarchar(10), the value like these: 1,2,1/2,1/4,3/8.... I need they are sorted by numeric value as 1/4,3/8,1/2,1,2. Any suggestions. Thanks in advance

Hi all, I have a page with a dropdownlist and a textbox and a button. I want the user to search product either by ID (using textbox and submit button) or by product type (using dropdownlist). But I can’t get the OnSelectedIndexChanged event to fire. If I not use the submit button, it works...

Hi, One day, when I open a table in SQL Server Enterprise, this error dialogue box popup. Must I setup SQL Server again? Thanks in advance. "The query cannot be executed because some files are either missing or not registered. Run setup again to make sure the required files are registered

Hi all, I use webhosting SQL Server, how to backup/restore database like in local server. Thanks in advance.

Hi all, I am newbie of .NET, I want to display images. The code like this: <script language="VB" runat="server"> Sub page_load() Dim fileid as String fileid="../imgs/myimage.jpg" end </script> <html><body> <img src="<%=fileid%>" />...

Hi, Does anybody know how to replace a string in a column (several hundreds records), for ex, I want replace all the string ('cat') contained in the column COL1 of table 'Tab' with the new string ('dog'). Can I only use SQL to do this. Thanks in advance