I'm new to SQL and would like to ask a few question..

I'm trying to automate upload data from a txt file to SQL table... Using the Import Wizard at first, followed the step-by-step procedure up to the portion where I'm ask to run it... I've tried to Schedule it on a later time... but somehow it does not run.. The SQL Server Agent is running and if I try to run the DTS package manually (right click then Execute Package) it runs normally and upload the data..

Hope someone could provide me a step-by-step procedure on to upload txt file to SQL table... Basically, what we want to happen is

1. We have a txt file via FTP scheduler dumped to a file server (Text File) which dumped hourly. (This portion works fine
2. The text file will now be uploaded to SQL server also via schedule (SQL table is already created).. (This portion somehow doesn't work or we are doing it wrong

Pls send email reply at jcdimacali (AT) smart (DOT) com.p

Thanks for the help..

Why use dts? see
http://www.nigelrivett.net/ImportTextFiles.html

Does the job run? Does it get errors?

Have a look at the schedule. Make sure it is enabled and the job is
enabled.
Common mistake is to schedule to run once to test - this will leave the
scedule diabled and it needs to be enabled before the recurring schedule
will work.
I would get rid of dts and use bulk insert - much simpler.


Nigel Rivett
www.nigelrivett.net

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Actually it does not work even during the first run (which is actually a
test).... I tried to make DTS schedule import and schedule it after 5
minutes to see whether it runs..... the result is it doesn't.... if you
check the Jobs at SQL Server Agent... it says "Failed" at the last run
portion... but if I manually run the DTS at the Local Packages in Data
Transformation Service folder (using right click then Execute)... the
importing will continue without any error...

If you check the error message... this is what it says..
"
The job failed. Unable to determine if the owner (smart\dimacali1) of
job hourly7898 has server access (reason: Could not obtain information
about Windows NT group/user 'smart\dimacali1'. [SQLSTATE 42000] (Error
8198))."

It says I don't have access... which is absolutely not true... can't
really figure out what is wrong.



*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!