Search results for query: *

John: I would like to say yours did. Thanks a bunch for your help

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

It worked!! THanks a million for the info

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

HAve you figured out this problem yet??

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

Thanks to both of for your help. I found what the problem was and it was data related...Thanks again

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

Thanks sqlserverbest.. I'll try it

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

Thanks for the advice ski. Unfortunately there wasn't a registry that went back far enough to when the problem occurred. I'll be getting Windows XP (Full edition) shortly. Hopefully, installing it will resolve the problem. Thanks again for your help...

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

Greg: Have you found a solution to your problem with connecting to SQL Server from Paradox?? If so, I need your help. I'm basically trying to do the same thing. Do you have any sample Paradox script that allows you to insert records from Paradox 9 into a Sql Server table real-time...

Steve: Unfortunately, I don't have a solution to your problem, but I would appreciate your help. I am trying to insert records into a SQL Server table that have been processed in Paradox via an ODBC connection. It's fairly simple to create a system DSN, but I have little knowledge in creating...

Lance: I spent all day looking through the Intersolv SQL forum and found nothing. Unfortunately, I've been unable to go to the Intersolv.com website because of technical difficulties. But thanks for the reference points... You mentioned that you were able to run multiple SQL statements in...

Okay, thanks for the info. But tell me, since my client application can call a stored procedure in SQL Server, is it possible for a Paradox record to be inserted into a SQL Server table via OLE?? If so, can the insert to an SQL Server table happen instantaneuosly when an add/update to a Paradox...