You could try a derived column, using scripting to achieve this, or take advantage of the built in .Net scripting

This link may be of some assitance - http://stackoverflow.com/questions/18659418/ssis-transform-split-one-column-into-multiple-columns

The report works fine in IE 11. Using your query, I also see that when I run the report in IE 11, a log entry is added to the report...

This should get you what you want - I can't remember the exact post but this code comes from stackoverflow or somewhere similar SELECT 'PK',

kc.name,

...

To be honest, I'm not 100% sure...I guess it would depend on how you are doing it via SSIS. I would assume with the SSIS approach you are using...

Any other dependencies? i.e the table is replicated? Etc?

You could drop the primary key and the NCI's, and issue the ALTER TABLE <<TABLE>> ALTER COLUMN <<Column>> bigint - When complete,...

When is the assignment due? 😉

Typically you would use INTERSECT to compare the results of 2 queries/tables (data sets) - can you share what you have come up with so far, and what your expected...

I actually did see an improvement by disabling the NCI's but I believe this was due to the fact that I had all of them sitting on their own filegroup...

Perhaps I could just disable the NCI's? I believe this accomplishes the same thing or am I wrong in that assumption?

Open the working report up in SSRS, go to properties and click the "Edit" button, this will allow you to download the RDL file.

Go to the same report that's broken,...

Is it possible you had a typo somewhere? Please see this article for a similar issue

http://www.sqlservercentral.com/Forums/Topic465265-149-1.aspx

If the Agent can't start, the reason for it is logged in the OUT file,...

Did you check all logs (event viewer as well), if not errors reported, did you just run RECONFIGURE or did you specify RECONFIGURE WITH OVERRIDE?

Do other reports work/render properly?

Are you 100% certain the data sources are set correctly? It's typical when deploying SSRS reports from BIDS to turn off the "overwrite data sources"...

And here is a pain-free way to script them all out and store them into a table (for safe keeping) 🙂

http://www.sqlservercentral.com/scripts/Indexes/101725/

Keep in mind that the counters are reset with each server restart, so the results you see may be skewed/incomplete depending on how long your server's been up and the...