It's in the server properties. You can right-click on the server in management studio and choose properties. It is in the security section.

Ok, so check if IIS is running in 64 bit. It can be installed and configured to run in 32 bit mode under WOW on a 64 bit machine.

Are you trying to get two rows returned, or one row returned?

Are you positive about the location of the .dtsx file? If you are importing into an SSIS server from Management Studio the file location is relative to the client...

That is odd. The error message seems to be indicating that IIS thinks it is 32 bit.

So, the first question is: are you are sure this is a 64...

The logical file names can be the same for two different databases. This happens most often when you restore a database from a backup to the same server as...

The best solution would be to nomalize your data. So, I just used a CTE to temporarily normalize it for the query.

[font="Courier New"]CREATE TABLE #tmpPoorlyDesignedTable

(IDK INT, LiderID CHAR(1), LiderSalary...

It will only be of benefit if you actually use the time without the date. If you query for records that have a time between 8 and 9 AM...

How dynamic does it need to be? Is there a pre-determined limit to the number of columns the result set can return, or do you need this to dynamically...

To cache that much data, you will need enough physical memory to hold all of it - or at least enough physical and virtual memory. It is just going...

First, a fact table should not be updated, it should only get inserts or you will not be able to incrementally process your measure group. Typically, a fact table...

Here is a CROSS APPLY solution:

[font="Courier New"]CREATE TABLE #tmpData

(Row INT NOT NULL

, Val INT NOT NULL)

INSERT #tmpData VALUES (1,12)

INSERT #tmpData VALUES (2,6)

INSERT #tmpData VALUES (4,8)

INSERT #tmpData VALUES (5,15)

INSERT #tmpData VALUES...

The answer is sort-of.

You could achieve the same importing and reporting end-products, but you would probably have to re-think your approach significantly.

First, SSIS is not a product designed for dynamic...

An SSIS package can only be run on an SSIS Server of the appropriate Edition Level. Although you can author a package using BIDS on a machine with only...

Not SQLCMD. SSIS is not built using T-SQL. There is a set of .Net objects for the SSIS object model. You can programatically create packages using these...