If you want exact copy and as long as you can see in EM both servers:

1. Setup DTSTask_DTSDataPumpTask with source MSDB database on the source server - destination MSDB database...

May be when you need to get one file which is already there it works fine.

In my project I had to get the certain number of files (differently named each...

If you use DTS object method to save on another server then you loose layout and annotations.

But you can use Transform Data Task to move selected packages (use SQL...

I fully agree - FTP task does not deliver, success is not proprly reported.

I abandoned the idea of using FTP Task and I have created whole system of DTS...

When you are at design mode and try to view properties DTS verifies the datapump task properties and when they are invalid (as at the moment of checking them) displays...

Yes they can.

I have the generic FTP packages run at the same time - and actually they (if the files are not where expected) will wait and restart in a...

I did try to use FTP task for a serious task (sort of generic FTP utility to get files from any given FTP Server with names that differ each day...

Hi Phil

If in your package there is only one task executed in any given time - then in your script you can reference your Package.

Then traverse the steps and find...

Hi CloseToDeath

You cannot do it with built in DTSFTPTask. Anyway there is a lot of problems with

the FTPTAsk if it does not get the right information.

But you can build an...

You have to set in child package properites logging Tab:

Fail Package on First Error.

Otherwise even the task (or rather step) fails the package does not - and your calling package...

Hi Dcurtis

Depends how deeply you use names of the columns in the packages.

eg imagine you have all the text you use in your tasks (eg when using disconnected edit)

when...

GianAngelo

I am using sql2000 server.

I do not know what you do exactly but I can show what I have done so you may find the answer:

I am using the...

Your code does not pass the parse

Try this one

Function Main()

If DTSSource("Q1") = "1" then

DTSDestination("HDA_Attitude") = "Poor"

elseIf DTSSource("Q1") = "2" then

DTSDestination("HDA_Attitude") = "Satisfactory"

elseIf DTSSource("Q1") = "3"...

It can be also for dbf files as used by Clipper

When you select from the list of available connection type you have dBase III, dBase IV and dBase5.

I used dBase...

Nico Verbaenen

You can set any property of your object (eg DTS package) using sp_OASetProperty this includes also Global Variables

like:

SET @GVName = 'gvName'

SET @GVValue = someValue

--

SET @Cmd = 'GlobalVariables("' +...