Great, glad that you got it solved.

Nice question, thanks.

I only...

SQLSteve (8/14/2013)

---

I have just saved the file into a CSV file and ran a bulk insert and it went straight in.

I wish I knew why the export wizard didn't work...

If you have only installed the 32-bit client on the new server, try setting Run64BitRuntime on the project to false.

wolfkillj (8/14/2013)

---

This could also be something as simple as a cold cache vs. warm cache in the database the report queries. The first time the user runs a report and...

Are you trying to put empty values (=NULL) into a non-nullable column?

THAT'S FINE BY ME! 😀

I shall take this as a compliment! 😀

Save the result of the wizard as a SSIS package and edit it in Visual Studio.

Change the data type to string instead of integer.

Erland Sommarskog (8/14/2013)

---

This is something you should do client-side, not in SQL Server. SQL Server serves the data. Formatting is best done elsewhere. I assume that this for some export...

And this post marks my 10,000th one on SSC! 😎 😎 :w00t: (and some of them were actually useful!)

Now that I'm one of the big boyz and Grant can finally...

A lot of functionality of SSRS is ignored when exported to CSV.

Exporting to a CSV File

How did you implement the switch between the two tablixes? The interactivity section in the...

Can you explain in more detail how you exactly pass the parameters to the stored procedure?

Screenshots might be nice.

You'd need to use dynamic SQL for this. You can query the INFORMATION_SCHEMA.columns view to find out which columns a table has.

Using this info, you can construct a SQL...