Nice article.

However, I've yet to see a "real world" example for Service Broker, anyone got any links?

So what is the exact syntax you used for the shrink command?

From my script you can see what properties I'm using to get the information. You just need to modify the script to update those properties to the new values you...

Records that can not be imported are re-directed to the log file.

In SSIS (DTS in 2005) you can actually direct these to a database table.

Sorry but I have to be "bookish". If you can't read Books Online you should put up with "bookish" replies.

What recovery mode is...

Set the transaction properties on the Advanced Tab of the Package Properties dialog.

Check the workflow properties for the preceeding steps to make sure they "Join Transaction if Present" ticked.

You can run reporting services on a seperate server, but then you need an additional SQL license for that server.

Check the licensing FAQ at Microsoft website.

Ahhh ... dumb question, but you never know ... what is the datatype of the field you're updating?

As a test to rule out a SQL task problem. How about running...

You could also save the package the wizard creates. Then edit the saved package. On the Options tab of the datapump properties, setup the logging of source and destination error rows,...

You'll need to write a short VBScript to bulk change all your packages. Take a look at my script over here and modify as necessary,

http://www.sqlserver.org.au/resources/ViewResource.aspx?resourceId=40

For setting up your packages...

If you did a defaut install of MSDE then you will need to manually enable the appropriate network protocols before the server is accessible on the network.

Use the Server Network...

You can use OPENROWSET to get the xml data into a variable.

EG:

DECLARE @var Varchar(8000) 

SELECT @var = CAST (a.[XML_F52E2B61-18A1-11d1-B105-00805F49916B] as VARCHAR(8000)) 
FROM OPENROWSET('MSDASQL', 
   'DRIVER={SQL Server};SERVER=<YOUR_SERVER>;UID=<USERID>;PWD=<PASSWORD>', 
   'Select *...

You can't decrypt the DTSRUN command line. It's a combination of package name, package guid, server connection details and any necessary parameters.

You cuold try running SQL Profiler to see what...

Please don't cross post.

http://www.sqlservercentral.com/forums/shwmessage.aspx?forumid=169&messageid=194572

Just to back up sushila, I was helping a friend import some genealogy data. She had a lot of data where she knew the year of birth and sometimes the...