Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

access directory

Status
Not open for further replies.
Bell1991

Bell1991

Programmer
Aug 20, 2003
386
US
I need to create a DTS package that reads in a file from a directory... however, sql does not have access to the directory.. I have a username and password.. Is there anyway i can use the username/password needed rather than the account sql uses?
 
Sort by date Sort by votes
figured it out..

Create batch file...

Thanks anyway
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

johnb1023
  • Locked
  • Question
Date conversions between Microsoft SQL Server and Viewing in MS Access
Replies
0
Views
242
johnb1023
johnb1023
Lost500
  • Locked
  • Question
Upsizing access 2007 db to SQL 2005: ODBC connection failed
Replies
1
Views
64
bburnell
bburnell
alorenzini
  • Locked
  • Question
Access 2007 in ActiveX script
Replies
0
Views
52
alorenzini
alorenzini
klewis10367
  • Locked
  • Question
Importing Active Directory with DTS
Replies
2
Views
31
mrdenny
mrdenny
babak2
  • Locked
  • Question
SSMA for Access
Replies
1
Views
20
babak2
babak2

Part and Inventory Search

Sponsor

Back
Top