you could also have a look at the following articles and thier discussions on this site...

http://www.sqlservercentral.com/columnists/jyao/howtobeagooddbastrategyandtactics.asp

and http://www.sqlservercentral.com/columnists/sjones/whatsadbaanoverview.asp

Yes that's the problem, I can't see the screen print becazuse it's still pointing at your H:\(right click veiw source and I think you'll find your local path).  To include...

Just out of curiosity what is the source database platform ie. MySql, PostgreSQL, db2, Oracle? 

Thanks.

Can you tell us exactly what the error is?  Are you using a data source that is not SQL server, and if so are the Servers all using the same...

If I understand your question correctly, you're looking to compare just the date portion of FromDate not the time portion?  If so the easiest and fastest way I've seen to...

You could script the installation of the outlook client using an administrative distribution point and then using a cutom MST you should be able to script just about everything pertaining...

Have a Look at this thread.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=49&messageid=172440

No Problem, Happy to Help.

-Luke.

In DTS designer Click Package, Properties.  Set up loggin on the logging tab.  This should help captue the error.  Also you should be able to see what happened if it's...

Check out this thread also on Colation issues...

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=9&messageid=252711

heres another one...

http://www.experts-exchange.com/Databases/Q_21048175.html

hope these help.

-Luke.

I'm not really sure what you're trying to do with this one... Are you trying to Set UserWeightFactor = UnitConversion.Factor WHERE ...?

If so why not something like this...  (Btw check this...

No problem, happy to help.

-Luke

I'm sure there is a better way, but you could do it like this...

UPDATE t

set UserWeightUnit = 'kg', UserWeightFactor = 1

FROM @Tmp t

WHERE UserWeightUnit is null

UPDATE...

believe it or not you can have access to a SQL Server.  Go download the MSDE.  Or a trial version of SQL Server 2000 so that you get enterprise...

a Lot of your options depend on what kind of "import facility" your ISP offers.  You could for example if you have an ODBC datasource created to talk to your...