See the attachment...

There might be a way to do this. Look at the properties of the Data Flow task itself...it will allow you to change the properties of the connections within the...

AmcAmx (8/9/2010)

---

Martin,

I was able to complete the following items:

-- Create one permanent staging table

-- Create an SSIS package that does the following:

-- Truncate the staging table

-- Select all data from...

AmcAmx (8/6/2010)

---

Martin,

Yes the tables all have the same layout. I was considering doing a massive UNION but even that comes with problms as the Resulting table has...

As Pablo said, you shouldn't have to do anything...because at the time you populated the FACT, it should have pointed to the relevant DIM record (via the surrogate key).

Unless you...

Hi Chris,

It is definitely possible to do it with a loop in SSIS.

Another question though...

Do all the source tables (and temp tables for that matter) have the same layouts?

If...

Hi,

From the error msg it seems like the connection timed out. You might have to manually configure the timeout by adding it to your connection string.

Are you using SQL or...

Hi,

I don't fully understand what you mean by "moving between systems"...maybe you can elaborate.

Aside from that, the connection manager has properties for every column and you can specify explicitly what...

Hi,

You can use an expression in your ftp task to dynamically build the remote path, and replace the value of the property.

It sounds to me like you had a linked server set up between your SQL2k and SQL2k5 servers. You should create the same linked server setup on the SQL2k8 for...

That's pretty weird...

For consistency I would log into Management Studio with the same user that Reporting Services use (unless you are already using Windows Authentication).

The only other alternative I can...

Are you using an ODBC connection in Reporting Services rather than the native OLEDB connection? That could be the reason...

Rebuilding indexes also updates statistics. My guess is that your statistics weren't up to date and the query optimizer therefore did not use the index.

Regards,

Martin.

Reporting Services, which is free with SQL Server is the best way to go...much better than Excel 😀

Well, if you still have the data and log file on the D:\ drive you can just attach them again. In Enterprise Manager, right-click "Databases" go to "All tasks" and...