Thanks for the help!

Email server is the problem. Even through email server was back, the job still hanging. Actual job steps did not do anything and there is no record...

Thanks for asking!

Go to the next step in "upon success action" and Quit job reporting failure in "upon failure action".

However, I found that Mail Server is causing the stuck...

Mail server is the problem.

I had the jobs stucked last weekend too, but has different status as 'Performing Compltion Action'. They have been hanged in this stage for almost two...

I had a similar project that daily import data from a flat text format with fixed 80 char length. Here is summary of what I have done:

1. Create a Temp...

Thanks Racosta!

Jie Ma

Thanks Racosta!

I do not know how fast data will be increased, but I can schedule more connection per day if data size grows quick. One fact is that the table...

What kind of connection between remote server and what purpose for that server?

I have a failover location with T1 connection with log shipping every 15 minutes working fine.

Jie Ma

Thanks Andy!

I tried it. I built a package to import the first 20030101.dbf and created table in SQL Server, but I could not figured out the way to rename the...

I use VISIO. New Visio xp has some good feature for database. It is easy to us to define tables and will create DDL for you to create them.

I normally...

You can not restore log if DB is using. One way you can try if DB application is allowed is to write script to kill the process before running restore...

Another factor for the database which not allowed to modify table structure for application reason such as Microsoft Business Solution(Great Plains), log shipping is the option for standby reporting purpose...

It is better to check the target table availability before insert the record.

Also have error handling to tell you weather or not the work is done.

jiema

I vote for option 2. Beside other person's comment, if your application gets more clients as well as process than one DB box can handle, you may have more than...