• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 241
  • Last Modified:

Importing data from jet to SQL7

I would like to import data from a mdb batabase into sql server 7
I would like this to accure on a daily basis and it works fine.
I would like to edit that proccess, however in the jobs step
I can see only a weard line like that
DTSRun /~S 0x1ADD01AF863DC773A60B7331826CA064 /~U0xF814..
Is there a way to edit the import proccess?
0
mAmitai
Asked:
mAmitai
  • 3
  • 2
1 Solution
 
mAmitaiAuthor Commented:
Edited text of question.
0
 
f4817Commented:
hi,

when you use the wizard to create the import of data, in the jobs you can see the schedule of the job, but the process is a DTS that in the data transformation tree. You can edit this DTS to make any change.
0
 
mAmitaiAuthor Commented:
Where do I find this DTS?
0
 
mAmitaiAuthor Commented:
Founf it...
Post an answer so i can grade it.
0
 
f4817Commented:
you can find it in the SQL Server Entreprise Manager, under your server (Icon with green arrow) the second level in the tree, expand Data Transform Service and then you can find your package in the 'Local' or 'repository'.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now