How did you want the results to appear? Are you trying to sum something up, get a distinct list of employees?, ...

If you are trying to get a distinct...

With no ORDER BY clause in your SQL, you're not guaranteed any particular order; SQL is set based. If the data is the same between both servers, then you're...

It looks like MS has moved/removed the 2008 .msi installer as near as I can tell. All of the historical links I found showed a redirect message that the...

I think a little Bing or Google work could have found this for you.

Try looking at:

http://msftdbprodsamples.codeplex.com/

Download & follow the installation instructions.

HTH,

Rob

Are you trying to run the SSIS package in the same place (same machine, same account) the second time where you get the connection error as when you ran it...

You can parse out the pieces of the string you need using the Derived Column Transformation inside a Data Flow Task.

If you are just beginning with SSIS, take a look...

So your source system's natural/business keys contain non-printable (e.g. ASCII character(0)) characters. ...

I think the answer is to remove the non-printable characters from the underlying data in the DW and reprocess. Is there a reason why you want to preserve these...

Let me see if I understand what you're saying: You have a dimension, let's call it Customers that's the same on your two servers' SSAS dbs (let's call them...

I like the ideas that Andy Leonard has incorporated into his SSIS framework and have rolled these into my package design templates. He uses a parent package to loop...

Like previous poster said, keep your eyes open while you learn the new technologies. Having a SQL Server background along with some Oracle/Cognos knowledge could make you even more...

Can you try running them sequentially? Load all of Table 1, then Load all of Table 2. Give this a try. Does this shed any light on...

How many tables are you writing to the Access db? Are you writing the records in parallel or in sequence?

Simple question, but if it works for one table, does...

In a Derived column transform, you can do something like:

[font="Courier New"]RIGHT(Field1,1) == "," ? SUBSTRING(Field1,1,LEN(Field1) - 1) : Field1[/font]

I didn't check for an empty string or other possible problems, but...

If you're just looking for documentation purposes, I've just opened the OLE DB Destination (or whatever destination you're using in your Data Flow Task) and did a screen capture with...