I am new to DTS. I want to do below task with DTS any help will be
very much appreciated,

I want to map network drive with DTS and then create directory on that
drive and after successful execution of this task run other DTS which
I have created and after successful execution of called DTS disconnect
the Mapped network drive.

Thanks,

In message <a52fc9b0.0401211129.1f98508c (AT) posting (DOT) google.com>, Dushyant
<DMAKADIA (AT) SUNOCOINC (DOT) COM> writes
Don't bother mapping a network drive, just use a UNC path name, e.g.

\\Server\Share\Folder

You can create the folder using the File System Object in an ActiveX
Script Task rather than DOS as it will be easier to check for existence
and handle any errors.

The only time I would deviate from ActiveX and UNC is when you need to
use the NET USE command to supply and alternative set of credentials,
but even then you create the share mapping, but do not need a drive
letter. Using a drive letter leaves you open to letter clashes and such
like. Disconnect this share as you would a drive with NET USE.

--
Darren Green (SQL Server MVP)
DTS - http://www.sqldts.com

PASS - the definitive, global community for SQL Server professionals
http://www.sqlpass.org

you can use NET USE in an ExecuteProcess task or you could call a bacth file
that does this for you



--

Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.allisonmitchell.com - Expert SQL Server Consultancy.
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


"Dushyant" <DMAKADIA (AT) SUNOCOINC (DOT) COM> wrote