Search results for query: *

I have created a DTS package that retrieves data from a SqlServer Table and inserts the data into an Oracle table via an Active X Script Task. The Active X Script Task invokes an Oracle procedure to insert records, passing the data retrieved from the Sql Server table as parameters. The DTS...

I have written a package that accesses a shared windows directory and imports a text file from it to Sql Server. When I run this package manually, it works fine. However, when I schedule it to run as a job, it fails noting that the file on the shared directory is not accessible. It turns out...

I've created a query against the following table: Table1: fld1 fld2 row1 2 2 row2 <null> <null> row3 1 2 The query: Select * from table1 where fld1 = fld2 or (fld1 is null and fld2 is null) My results set contains row1 but not row2. It appears that the...

I'm creating a scheduled DTS package that may run for hours or even days. Is there a way to check and see if the package is currently executing without re-executing it again? If so, how can I prevent the subsequent execution of the DTS package from occurring??

I am trying to import a delimited text file into a Sql Server table. The text file is about 40k. During the DTS import, I am getting an error during the transformation process indicating that a text file field (which has nulls in it) can not be transformed into a database table field. I've...

I created a DTS Package with 2 Active X script tasks. Both scripts invoke 2 other dts packages. To handle step failures from the other dts packages, I am using the GetExecutionErrorInfo routine. When a failure occurs in a step from the invoked dts packages, and the Active X tasks invoke the...

I have created 2 SQL tasks in a DTS package workflow. The first task selects/deletes from a table in database X one row at a time. The 2nd sql task invokes a stored procedure in database Y. Between the 2 SQL tasks, I have an Active X Script Task that begins the looping process, and at the end of...

Can a windows folder be generated dynamically during run time of a DTS Package?? If so, can someone provide sample Active X VB script code to do it?? Help is greatly appreciated...

Can a windows folder be generated dynamically during run time of a DTS Package?? If so, can someone provide sample Active X VB script code to do it?? Help is greatly appreciated...

I have Windows98 on my personal computer. When I right click on Start/Find, my computer stalls. I am then only able to reboot my computer. I also notice that if I click on Start/Control Panel, the same thing occurs. Any suggestions on what the problem may be and how I can resolve it???

I am accessing a Paradox (Version 7) table remotely from a client application. For connectivity to the Paradox database, I've created a system DSN using the Intersolv 3.11 32-bit Paradox File driver. I have no problems accessing the table using a single SQL statement. But when trying to process...