Call a DTS from a DTS then FTP it 2

[VBRookie]

A merry morning to you all!

I have 6 dts packages that I'd like to consolidate into one and then FTP the resulting text files to a remote server. Is it possible to call a DTS from a DTS? If so how? I've been googling without finding very many practical examples.

Many Thanks,
- VB Rookie

 

[jbenson001]

Yes, you can use an Execute Package Task that allows you to run saved DTS packages.

 

[DotNetGnat]

http://www.sqldts.com/Default.aspx?215

-DNG

 

[VBRookie]

Many Thanks!

Execute Package was the ticket ...

- VB Rookie