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 .adp, dts package (.bas) fails for txt

Status
Not open for further replies.
simonB2006

simonB2006

Programmer
Jan 11, 2006
11
EU
I have successfully saved DTS packages as .bas files, imported them into my .adp and run then to import .xls data into SQL Server.
This way i can also change the source files etc within the code.

However, when i save a '.txt file to SqlServer' Package and use it in the same way ... nothing happens !

When the code is executed, it seems to run through the DTS code but nothing happens on execute.

Any ideas anyone .. i'm assuming it's somethign to do with txt drivers but no idea where to start looking !!!

Appreciated
Simon
 
Status
Not open for further replies.

Similar threads

arodri
  • Locked
  • Question
MSVisual Studio - DTSX Package creating new text file
Replies
0
Views
159
arodri
arodri
Fsoumia
  • Locked
  • Question
DTS Logging
Replies
2
Views
173
Fsoumia
Fsoumia
kat50
  • Locked
  • Question
How to import a txt file based on position
Replies
0
Views
191
kat50
kat50
ashleybyrdnc
  • Locked
  • Question
DTS Package Failing
Replies
1
Views
84
mrdenny
mrdenny
WordTechinc
  • Locked
  • Question
DTS disable Daily Run 1
Replies
1
Views
90
drlex
drlex

Part and Inventory Search

Sponsor

Back
Top