Might be the ODBC driver. One way to find out is to set up Excel or Access and write some quick VBA with ADO to test the functionality...

With different chip sets, you couldn't just restore a backup of one at the operating system level on the other machine. You could restore a SQL backup, just...

Not that I know of. However, because it is well-known, most new implementations will take this into account and design the tables in such a manner that the...

Yep. Slightly unpleasant is a rather nice way to say it, though...

Well... I honestly don't know if SQL 2012 SSRS has that ability. I know the previous versions don't, and I would have to use something like Crystal Reports...

With what little I know about mirroring, this may be one of those. You have to point to a database that is NOT in the same instance. ...

While I don't know if that's possible or not, I'm not sure why that would be useful. Just because a USE statement is executed doesn't mean that one...

You didn't say what actually happens when you run this report, and what appearance you actually end up seeing. I've yet to see SSRS 2012, but previous...

antonela,

Any update on whether the ordering problem is resolved, and whether or not my post helped with that?

How about the following:

IF OBJECT_ID(N'PROVA') IS NOT NULL DROP TABLE PROVA

CREATE TABLE PROVA (

cod varchar(2),

des1 varchar(2),

des2 Varchar(2)

)

INSERT INTO PROVA VALUES (1, 'A1', 'A2')

INSERT INTO PROVA VALUES (2, 'B1', 'B2')

;WITH COLORDER...

I had to do something similar for tickets in a problem management system, but each ticket constituted a separate outage. The very fact that your setup is allowing...

You need to pre-format an Excel file with the correct format, and then use it as the destination file. Maintain a copy of the formatted, but empty file,...

You haven't stated whether you actually have a problem, but knowing the grief that NTEXT fields can cause, perhaps the best way around it is to transform the source via...

You indicated you can connect from your "local SSMS", but what I asked is if that could be done on the machine where SSIS is running. It might...

I'm sure plenty of people have encountered such a message, but you haven't stated what, if anything, you've checked to see if that item might be the problem. ...