set dtsPackage = DTSGlobalVariables.Parent

Set sourceConnection = dtsPackage.Connections("Text File (Source)")

sourceConnection.DataSource = DTSGlobalVariables("PollingBaseDirectory").Value

The preceding 3 lines are in a DTS I use to upload a text file as specified in...

The release notes for SP4 say that it cannot be rolled back therefore take a full backup of everything before your attempt and install.

That said, I have not had any...

I don't know about that but I would jump to hotfix 2040 because SP4 (2039) has a bug that stops the SQL seeing all the memory in your server if...

You want to take a look at the SQLXMLBULKLOAD process. There are lots of threads on the site but I had a similar problem to you and got

The ZIP is on a local drive.

I will try and use StdOut but I am not optimistic.

Brian,

You forgot to mention the snippets!

type in ssf and press TAB and you get SELECT * FROM.

You can add your own as well so I have set up

derr to bring...

I should like to get my full MCDBA but it is expensive and ultimately I don't think it is reasonable to expect a company to pay for it all, however,...

If it is doing it during DEBUG I would suggest printing the LEN and the CODE() for the character that is being passed in.

Clearly DEBUG is translating the space in...

The only way that I can think of is to use an OPENROWSET and predefined connection but that isn't a way I would choose to do it.

Are you using Windows...

I can't speak for the clustered environment but SQL2000 does NOT require the service accounts to be local administrators.

The accounts obviously need full privileges to the directories that SQL uses...

I believe that each filegroup gets assigned its own thread so the only benefit you will get will be from whatever using separate threads gives you.

If you pass in a string containing nothing but spaces LEN will return 0.

UPDATE dbo.account

SET dbo.account.balance = DT.TotalAmount

FROM dbo.account

INNER JOIN (

select sum(amount) AS TotalAmount, account_num from atransaction

group by account_num

) AS DT

ON dbo.account.account_num = DT.account_num

Set up a role in DB2 explicitly to allow the execution of a stored procedure to insert the records into the appropriate table.

Add the user from DB1 to DB2 but...

Start reading up about the sp_makewebtask and sp_runwebtask.

In summary you can design a simple text template of what you want with tags where your source query should insert its...