Recent content by newtechy

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