In DTS Designer go to the package properties, i.e.

Click package,....properties.

Click advanced tab

Also check the workflow properties of the step . You need to check the options tab.

I need to check...

If An error occurs in a job step you could specify that the job step to goto which would be the execution of the mail send stored procedure. See...

I have been working on a similar problem.

I tried to set up an alert on 'log file size used' to fire a job to backup the transaction log but the...

See if all intermediate results can not be inserted into temporary tables so that the only select statement is the final one. There is a way to cycle...

SQL server. no other connections unless Ftp task and ActiveX scripts influenses this.

Worked like a charm. Thanks.

The way I did this is not to use the FTP task.

Create a ActiveX script with all the FTP commands to execute and a batch file with just...

I used the same solution of creating a command .txt file with all the ftp commands and a .bat file to call ftp with the -s parameter. Easy and...

it is the max error count of the options tab of the Transformation properties. I actually had this error while doing some activeX script testing over the weekend. ...

I had a problem with the FTP Task, even with SP1 it was still deleting the last large file transferred. After reading Steve's article I wrote a ActiveX script...

I used NotesSQL as a driver just for the Data migration. Never had to migrate the code on documents. I believe I downloaded the NotesSQL file off the Notes...

The Service Pack has been applied and I am still seeing the same Problem.

The FTP task Downloads the data Then Deletes the last File Downloaded. Please Help. FTPing...

I foundd the Problem. This Is a / the problem Acknowledged by Microsoft. If the last file downloaded by a FTP task is larger than about 2MB it...

An Alternative is not to use the USE statement and fully qualify the objects you are refrencing. That works for me.