Again, we don't work in a perfect world. How many times do we have to make assumptions in our day to day work? Users don't tell us everything...

Is the off-line processing reporting only, ie no updates to the database?

😎

Unfortunately (or not), I disagree. By specifying SQL Server 2005 in the question, that should automatically eliminate SQL Server 2000 tools from the equation. In my environment, currently...

Two questions still. One, were you able to eliminate the cursor. Two, were you able to increase performance of the process?

😎

I'm still trying to figure out where the FTP server is in all this. You say the files are FTPed from the mainframe, so where does the FTP server...

Another question then. You say that the main frame guys FTP the file to your server. Does this mean that you have the FTP Service from IIS running...

Check out this site: http://www.sqlis.com/

I recall seeing there a File Watcher Task, and this may be what you need for your SSIS package.

😎

Even if nothing is inserted, the INSERT trigger still fires. You may want to add a test at the beginning of the trigger to test the number of rows...

If possible can you post what you came up? Others may have a similiar requirement.

😎

Okay, your turn. Would you please explain how you got it working (others may have a similiar problem to yours)? Also, are you still using a cursor?

😎

BACKUP DATABASE ADVENTUREWORKS

TO DISK= N'C:\AW.bak' -- Attempting to create backup file in root directory

WITH STATS= 5

BACKUP DATABASE ADVENTUREWORKS

TO DISK= N'C:\backup\AW.bck' -- Creating backup file in the backup directory

WITH STATS=...

It may be job security, but I too would have looked for a way that would not require a rewrite if it was not needed.

😎

Not really. The question specifically stated SQL Server 2005. The assumption here is that you are using SQL Server 2005 tools, not SQL Server 2000 tools to access...

brownsea (9/10/2008)

I have a problem with my test server when i generate a backup

BACKUP DATABASE ADVENTUREWORKS

TO DISK= N'C:\AW.bak' <-- is not a backup device

WITH STATS= 5

Msg 3201, Level 16,...

select

datename(mm, SalesDate) as Month,

sum(TotalSale) as TotalSales

from

dbo.SalesOrder

group by

datename(mm, SalesDate)

order by

datepart(mm, SalesDate);

Something...