I would suggest that you click on the body of the report, then open the Properties window, find the "Width" property and change the value to something between 0in and...

How about this situation?

Our customers are using Third Party software, which is not supported on a database using Snapshot Isolation and which frequently holds locks for minutes or even hours,...

opc.three (4/11/2013)

---

😛 I just realized something...converting a file from ANSI to UTF-8 is pretty much non-sensical unless you truly need the BOM. UTF-8 covers all 255 ANSI characters with the...

Thanks for that - will take a look.

Much appreciated.

Because I couldn't get it to do it.

I tried.

Lots.

If you know how, and have actually seen it work, I would seriously love to know...

Ok, ignore that...I found my answer.

Apparently ADODB.Stream for reading the file is terrible in this code.

This worked much much much better:

function ansiToUtf8(fileName) {

var indir = "ansiin";

...

Hi, did you find a solution?

I have one using scripting to convert the file...

The wonders of C#...

Whatever language you use though, that is one horrendous method call!

Thanks for that, it really wasn't necessary, but much appreciated.

I will take a look later.

Yep, installs just fine for me, both in 32bit and 64bit environments.

edit: changed picture to show it was enterprise 64 bit.

extra...

Here's some code to generate a Broadcast Calendar table:

CREATE TABLE BroadcastCalendar (

[dated] [datetime] NOT NULL PRIMARY KEY

,[Media_Week] [bigint] NOT NULL

,[Media_Month] [int] NOT NULL

,[Media_MonthName] [nvarchar](30) NOT NULL

,[Media_Quarter] [int] NOT NULL

,[Media_Year]...

I just tried it in C# script

ConnectionManager myCM = Dts.Connections["MyFlatFileConnection"];

...

You might need to iterate through the connections collection to find yours then, assuming you have spelled it right?

Can you post some code to show what you are trying to do? it might help.

All I can show for now is this:

get your connectionmanager from the dts.connections collection and...

I am also on PRO, so it worked, but if I get a chance I will throw a quick enterprise VM up and see...