Yes, I want to update the primary key that is...

Thanks Phil, that is the one I needed, it has all the msdb packages. Not sure how I missed it.

I am in SQL Server 2008. There is no table sysdtspackages90 in that version. Also, I would have posted this to 2008 forums, but...

I had to resolve registry permission issues, and...

The DBA informed me that the system user is a startup user for sql server and agent service and has "SA" rights, so it should have more rights than I...

So I have changed my connections to ADO.net and I did a test where I downloaded one date column and it works for both me and the Agent user. Now,...

Thanks Phil, I actually had a lightbulb go off before I saw your post, but you would have directed to the correct solution if I hadn't figured it out.

I figured this one out. I put the following line of sql at the end of my code, and did a result set looking for the RowCnt and populating my...

I check the ValidateExternalMetadata to False and that error has gone away, now I am getting this error:

Description: The connection manager failed to defect from the transaction

I have come up with a query to dynamically crosstab your xml fields, I posted it on Jack's discussion, the link is below. Thanks

http://www.sqlservercentral.com/Forums/Topic487637-1254-11.aspx

Jack, I was able to come up with a way to crosstab the xml values. You could also use this to run a report I guess.

Make sure to change the...

I was able to create a dynamic query with the following code, it works great. I am using different column names different amount of columns.

The key to make this...

@mister.magoo,

I tried replacing your column names "for inner_table.name in" with sub select sql below, which runs correctly on its own, but doesn't work within the whole query. Any ideas? This...

The query would have criteria on another column in the table, so the field names from the xml column would all be the same within the query. The table would...

Great article! I have a question, is there a way to query the xml column and have the field names and values be cross-tabbed?

So here is my error detail below...