PaulB-TheOneAndOnly (2/12/2012)

---

Jeff Moden (2/11/2012)

---

Gosh... it's a whole lot more than...

If there's an ODBC driver for IDMS, you could use that one to connect to the IDMS system.

You could use the slowly changing dimension wizard in SSIS, but it is a bit slow. Here's a list of alternatives:

Alternatives to SSIS SCD Wizard Component

[/url]

Also make sure you have the Oracle client installed and configured.

If any doubt, contact your Oracle administrator.

31 Days of SSIS – Generating Row Numbers (23/31)[/url]

Create a matrix and drag all the fields from the dataset into the rows area of the matrix.

Duplicate post.

Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1250988-391-1.aspx

Nope.

There is a feature request for that on Connect:

http://connect.microsoft.com/SQLServer/feedback/details/381741/add-digital-signature-to-a-pdf-document-in-reporting-services

Maybe it's possible using 3rd party providers.

Nice question Craig, thanks!

Chrissy321 (2/10/2012)

---

Thanks for you reply.

I end up getting the "cannot convert between unicode and non-unicode data types" error on a particular field.

If I do set the file to unicode would...

Jack Corbett (2/10/2012)

---

So I tried upping my activity lately to try to stay ahead of Paul on the total point count, but he has passed me. Congrats...

It would be really...

Eric Mamet (2/10/2012)

---

I get warnings in my package because I have some unused columns coming from a Union All task.

The "Union All" task gets all its columns from the...

At the beginning of the script, put

USE [OtherDatabase];

This will change the scope of the script to the other database. Make sure the script doesn't contain other USE statements that change...

Peter Howard (2/10/2012)

---

It wasn't so I ticked it but it didn't make any difference I'm afraid. I even closed MS and went back in just in case.

Thanks for taking an...