Yes that would be the problem. You need to tell DTS the datatype of the parameter as well as the value.

Given the time it takes to perform maintenance and the size of the backup files, there is no reason why you can't do it nightly.

The CSV output from Reporting Services is in Unicode format. There is a trick to make it plain CSV but I can't recall it at the moment.

Why don't you just...

Best thing you can do to save future headaches is to remove Outlook and MAPI from your server.

Get a replacment like xp_smtp_sendmail

http://www.sqldev.net/xp/xpsmtp.htm

This was a problem with the original release of reporting services. Applying service pack 1 fixed it for me.

Jones

The best strategy involves not coding stored procedures until the database schema is finalised. Realistically this will probably never happen

To make the changes...

Just to try and understand your question.

If you have 100 records to migrate, does that mean you want to update the other table 100 times, or do you just want...

Now that would be a silly thing to do if the database is operational 24x7

Congrats

Now come on, it's never a holiday with a new-born is it

0)
:-)



%)

0)

🙂

At the moment its 9am here. Busy organising my workload for the day.

Wish I was sleeping though

Yes, now that is a funny site. How many of the tests have you done Frank??

In the input parameters dialog, you can specify the same global variable for each of the parameters.

The only way you could get SQL Server to use date sorting is to convert the column to datetime.

Other options would be

a) add a new field to hold an...

Straight MS shop at my place

1 x W2k3 running SBS 2003 Premium (Exchange, Sharepoint, Streaming Media)

1 x W2k3 running SQL 7.0/2000/2005 (virtual servers)

2...