I can certainly understand and agree with the point of view that case sensitivity, certainly on a whole database, is generally a bad idea. I think however, that the...

For loading significant amounts of xml I would strongly suggest investigating SQLXML.

Put simply, create a xml schema defining the xml document and the related database tables, then execute a script...

This looks like a relatively straight forward asp error message involving integrated authentication between the web server (running the asp page) and the sql server. There are a number...

I like phillcart's answer a lot. Very neat, however see my reply (certainly no where near as neat) to your other identical post (try not to cross-post) if you really...

Here's a stored procedure I use to return the FOR XML output as a resultset. I can't take any credit for this as I found it on some forum...

Khalid,

-Add a global variable to your package called OutputFilePath with type as string

-Add a Dynamic Properties task to your package and set the "Data Source" property of your destination data...

This might sound a stupid question but where are you setting the parameters of the stored procedure ? There might be a problem with the way they're being passed...

I think that we'd all agree with andy that Integrated Security would be the preferred option if available/possible. Depending on your development tools/expertise however it is possible to change...

Only by writing a separate .NET application/library and executing that using xp_cmdshell, the execute process task or an ActiveX script that uses the windows scripting host objects to execute your...

As far as I understand it (and this is not guaranteed to be spot on) but the server definitely takes additional load while the profiler is running however the size...

1. There is no way to update an existing record using this method. What I have found is that your bulk loading inserts everything into staging table(s) and...

This link may help which states you can bulk load or use an updategram to insert the base64 encoded data by using a schema and specifying the datatype as bin.base64.

There...

billsalkin,

I managed to create a VB.NET project which enumerated and fired DTS packages but had a bit of difficulty responding to progress events correctly i.e. when each 1000 rows were...

I've tried and used the SQLXML Bulk Load component provided by Microsoft with much success. It performs comparitively as fast as BCP and enables you to insert child related...

I'm not totally convinced that it is the recompilation of your stored procedures that is slowing the application down initially. The compilation of stored procedures happens extremely quickly, which...