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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Need help getting started in DTS use

Status
Not open for further replies.
bigSP

bigSP

MIS
Jun 11, 2003
1
US
I need to create a DTS package for the first time. The processes needed are as follows:
1. FTP data files on a nightly bases. Names of files change based on current date.
2. Files need to be unzipped.
3. A java program then runs against these files and creates .txt files that need to be BCP into a database.

How can I get started.
 
Status
Not open for further replies.

Similar threads

tekpr00
  • Locked
  • Question
Help with concatenation of BIG integers
Replies
0
Views
154
tekpr00
tekpr00
Rene1024
  • Locked
  • Question
Help with a Bulk insert statement
Replies
1
Views
193
drlex
drlex
ChewDoggie
  • Locked
  • Question
Help with Select statement Substring
Replies
2
Views
162
ChewDoggie
ChewDoggie
ItHurtsWhenIThink
  • Locked
  • Question
Using Distinct and count in same query???
Replies
4
Views
191
gk53
gk53
betachristopher
  • Locked
  • Question
Use IF/ELSE in Query 1
Replies
3
Views
173
drlex
drlex

Part and Inventory Search

Sponsor

Back
Top