Can I programically change the Directory Path property for where the FTP package downloads the file? Or must it be specified in the Package as is?

My package code...

package.LoadFromSQLServer("servername", "Data Loader User", "", DTSSQLServerStorageFlags.DTSSQLStgFlag_Default, null, null, null, "My Package Name", ref pVarPersistStgOfHost);

package.Execute();
package.UnInitialize();

Are you looking to change the SourceFileName property of the DTSFTPTask
object?


One of the best ways I think to understand how these things hook together is
to create a package and the save it out to a VB Module. You can then look
in the code for the properties in which you are interested. You then adapt
them to your needs in your code.



--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Dave" <Dave (AT) discussions (DOT) microsoft.com> wrote

Package Name", ref pVarPersistStgOfHost);

In fact just looking a little closer there is a code example at

mk:@MSITStore:C:\Program%20Files\Microsoft%20SQL%2 0Server\80\Tools\Books\dts
prog.chm::/dtsptasks_79ex.htm

I think you want the SourceSite property




--
--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
I support PASS - the definitive, global community
for SQL Server professionals - http://www.sqlpass.org


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote