So your main package has an Execute Package Task that executes a 2nd DTS package that has an Active X Script task that uses the FileSystemObject to copy the files?

If...

Add a connection object that points to your sql server.

Add an Execute SQL Task to the package and enter the following SQL statement:

DECLARE @count int

SELECT @count = COUNT(*) FROM Employee WHERE...

If you're 100% certain that the path and filenames are correct and that the proper permissions on the folder the file resides in have been set, then most likely the...

You could always query the sysjobs & sysjobsteps tables and paste the results in a spreadsheet.

SELECT

 sj.[name],

 sj.[description],

 sj.enabled,

 ss.step_id,

 ss.step_name,

 ss.command

FROM

 msdb.dbo.sysjobs sj

INNER JOIN

 msdb.dbo.sysjobsteps ss ON sj.job_id = ss.job_id

ORDER BY

 sj.[name],

 ss.step_id

Use this instead:

Set oTSK = oPKG.Tasks("DTSTask_DTSExecuteSQLTask_2").CustomTask

Can you create a DSN for the server on your computer?

Is that a valid path on the SQL server when logged in with the account SQL Server runs on?  Does the account that the SQL Server Agent runs on have...

Create the following table and stored procedure.  Schedule the proc to run in a sql job:

CREATE TABLE [DBAFileInfo] (

 [HistId] [int] IDENTITY (1, 1) NOT NULL ,

 [SrvName] [varchar] (32) COLLATE SQL_Latin1_General_CP1_CI_AS...

You can store the .pdf file in an image field.

I don't see how you could import the contents of the .pdf file though.

I've found that if you execute a package step by step, it will run using the local and mapped drives on your computer.  If you execute the entire package, it...

The DTSRun utility can't be executed directly in a SQL statement.  You'll have to use the xp_cmdshell stored procedure to run it.

Also, if you're specifying the username & password, you...

You'll need the PGP command line interface installed on the SQL server the DTS package will be running on.  Use the following code in an Active X script task after...

Using this code in an ActiveX script transformation will do what you want:

Function Main()

 Dim strSource

 Dim strNumbersOnly

 Dim i

 strSource = DTSSource("Col001")

 For i = 1 To Len(strSource)

  If IsNumeric(Mid(strSource, i, 1)) Then

   strNumbersOnly= strNumbersOnly &...

Open your Data Transformation task and go to the Options tab.  Enter a path in the Exception File text box, then make the Max Error Count > 0. 

Any errors...

Make sure that the machine this is running on has Excel installed on it.   Also look at the processes running under Task Manager.  If you see EXCEL.EXE, kill it and...