Search results for query: *

Hello, I have a question: I have a Table with information: create table info1 ( ID, name, address, .... ); Now I want to import those data to another table, except in this format: create table info2 ( ID, label, data ); Say if i...

Hello, I have a question: I have a Table of certain items create table item ( IdItem int, Item varchar(64), ... ); a lookuptable which defines some properties create table property ( IdProperty int, Property varchar(64) ); and...

Hello, I have a question: I have a Table of certain items create table item ( IdItem int, Item varchar(64), ... ); a lookuptable which defines some properties create table property ( IdProperty int, Property varchar(64) ); and...

Hi, I am trying to implement a trigger that run a dts package when something is inserted. My trigger is like this "CREATE TRIGGER [RUNupdateDTS] ON [dbo].[temp] FOR INSERT AS exec master..xp_cmdshell 'DTSRUN /S (local) /e /n import_iqvc_inventory ' " In my dts package, one of the step is...

Hi, This is a simple thing? I am a beginner and not sure how i would go about doing it.. What i want to do is, I want to create a form in access that would 1) let you browse thru the file directory to select the file that you want 2) have a button that, after you select the file, when you...

I have a question, I have a dts package that connects to a foxpro table (iqvc.dbf) and insert data to it, the package is called "Import_iqvc_inventory" I generate this line from the dts run utility "DTSRun /S "(local)" /N "Import_iQVC_Inventory" /G "{59D31918-D2CC-438A-89A5-18E745E07905}" /W...

I have created a DTS Package to Transfer Data from a SQL Server Table to Visual Foxpro Table. And every time data goes from SQL to Vis.FoxPro Table, it should first delete all the records permanently in Vis.FoxPro Table and it should append SQL Data. Everything is fine in designing and...