You can try to convert the pdf to an image and add that one in your report:

Reporting Services 2008 – Embedding a PDF Document

What kind of authentication do you use in the connection managers? Windows authentication or SQL Server authentication?

If the first, you can safely set the protection level to DontSaveSensitive.

If the second,...

This is probably due to indexing (if you remove the cast the query optimizer might use an index, while first he didn't) and to caching.

You'll need to check out the...

As I said, in the package properties.

Click on the control flow, hit F4.

What is the protection level of the package? (check the package properties)

This means your package is encrypted. If the protection level is EncryptSensitiveWithUserKey (the...

I see no reason to do this in SSIS.

SSIS will not "remember" the values you stored in the variables. It only maintains the values of variables during runtime. You'd still...

It exists, but the offering varies per country. Where are you from?

The clustered index is the table. In other words, the data is logically stored in the pages as defined in the clustered index definition.

pksutha (7/22/2013)

---

Hi friends,

I've a problem in sql server 2012, like i've one table, table name is "tblA".

In that Identity field Name is ID bigint not null identity[1,1].

Now i'm making few...

Very nice question, thanks.

OK, what if you add a simple line of code, for example declaring a variable. Still got the error?

What if you recreate the script and add lines of code piece by piece?

When in the script editor, try to build the script and see if an error pops up.

SSDTBI is also released for SQL Server 2012: it integrates within Visual Studio 2012.

Put all the flows back together with a UNION component and write it to the destination.