I would prefer the full-featured... but the time limit needs to be a least a month. Like you mentioned, all it takes is getting caught up in a few things...

If you have all of the record types, we can probably work something out. 🙂

Glad I could help.

Of the 2942 lines in that file, there are only 3 where Field9 starts with "User Account Enabled". Do you only want to run this for just those lines?

If so,...

Actually, your original code only had one closing parenthesis also.

Just one question though, in this case the...

I don't know if you can install it on a Pro version... I had to upgrade my Vista laptop from Home to Ultimate to be able to install Dev (Ent...

You have a parenthesis mismatch... make the final ")" be "))".

Provide additional rows of data - especially the ones that aren't loading.

Qjlee, apparently you don't know how to do this in...

TriggerMe (6/3/2010)

---

I have the following query as an expression in the dataset properties.

="SELECT A.AssetID, A.ComputerName, A.AssetNumber, A.SerialNumber, VIT.VendorItemTypeID, VIT.ItemTypeDescription AS AssetType, V.VendorName AS Vendor, VI.VendorItemDescription AS...

Anan,

With 380+ points, you should know how to post data here in a readily consumable format so that all of us volunteers can just cut-and-paste it, and start working. Seems...

Please check out the first link in my signature, and then try posting your data in that suggested format. Then, based on the sample data you provide, show what the...

Okay, with all of this new information, you won't need the DelimitedSplit function.

Change to a temp table, and then use this code:

-- drop the table if it already exists

IF object_id('tempdb..#CSVTest')...

Thanks for the followup.

A clustered instance (named or not) has it's own computer name, and you should be able to connect to that instance with just that.

I'd recommend this one