Importing data from jet to SQL7

Posted on 1999-07-05
Medium Priority
Last Modified: 2010-03-19
I wold like to import data from a mdb batabase into sql server 7
I wold like this to accure on a daly bases
I used the wizard in order to do this and it works fine.
I wuld 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?
Question by:mAmitai
1 Comment

Accepted Solution

rdrrichards earned 150 total points
ID: 1096144
You need to edit the package through the Data Transformation Services Designer.

Open the Enterprise Manager and go to the Data Transformation Services folder on the server where the packages you would like to edit are located. Then double-click on Local Packages, then double-click on the package you would like to edit. This will open the package in the designer. Make your changes and save the package.

Good luck!


Featured Post

Build your data science skills into a career

Are you ready to take your data science career to the next step, or break into data science? With Springboard’s Data Science Career Track, you’ll master data science topics, have personalized career guidance, weekly calls with a data science expert, and a job guarantee.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

This shares a stored procedure to retrieve permissions for a given user on the current database or across all databases on a server.
In this article, we will see two different methods to recover deleted data. The first option will be using the transaction log to identify the operation and restore it in a specified section of the transaction log. The second option is simpler and c…
Via a live example, show how to shrink a transaction log file down to a reasonable size.
Viewers will learn how the fundamental information of how to create a table.

619 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question