Hi,

I made a very simple DTS Strutured Storage File with a connection to a SQL
Server and a bulk insert. If I try to use data file on drive C everything
is OK but if I try it On Drive D it failed. I checked permission on both
drive and everything are the same. I put full control to everyone on drive
D and it still failed. I put my DTS Strutured Storage File on drive D and
it still failed. The system are Windows 2003 Server without SQL Server. I
install DTS files and register it like they said (files from SQL Server
2000).

Does somebody have any idea to help me?

Thank you

Dany

Errors?

--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"Dany Drapeau" <dany.drapeau (AT) courrier (DOT) usherb.ca> wrote

"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in news:#r8IH7Z#EHA.1452
@TK2MSFTNGP11.phx.gbl:

I take a script from Microsoft and the only thing it said is failed or
succeed. I forgot to said that I use an ASP(vbscript)script to use a
DTS.Package object. I use LoadFromStorageFile method to use my dts file.

Dany

Make sure you have a look here then


Execute a package from Active Server Pages (ASP)
(http://www.sqldts.com/default.aspx?207)
--



Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP)
www.SQLDTS.com - The site for all your DTS needs.
www.SQLIS.com - You thought DTS was good. here we show you the new stuff.
www.konesans.com - Consultancy from the people who know


"abcdef" <abc (AT) abc (DOT) def> wrote

I used a similar script except for the method I use LoadFromStorageFile. So
why it Work from c:\ but not in the d:\ if the server has the same
persission on both drive?

Dan


"Allan Mitchell" <allan (AT) no-spam (DOT) sqldts.com> wrote in news:OkbDvMb#EHA.2876
@TK2MSFTNGP12.phx.gbl: