What do the logs and the build-in reports say?

I believe you cannot set an internal parameter with a drillthrough from another report, while you can set a hidden parameter in a drillthrough.

Great question.

Although, the first X returned is not just X but X with 19 spaces. SSMS doesn't really show it that well, but if you copy paste the value you'll...

As mentioned by Reza and me on the MSDN forum, there isn't an event handler that can achieve this.

http://social.msdn.microsoft.com/Forums/en-US/sqlintegrationservices/thread/db384aee-0041-46a2-b855-b60a74f6e0bd

Also post the error message. It's kind of hard to troubleshoot without it.

How exactly do you transfer the rows? Can you describe the dataflow?

When you run the job on a server, the package will be copied to that server. So the package itself will not be executed on the HA/DR environment where it...

And I wouldn't exactly use the word "new" anymore, they are around for over 4 years 😀

Can you post the error?

I picked no because of the COUNT_BIG requirement, but also because it is not known if ANSI_NULLS and QUOTED_IDENTIFIER were ON when the table was created. (and ANSI_NULLS when the...

Jan Van der Eecken (5/7/2012)

Revenant (5/7/2012)

The Dixie Flatline (5/7/2012)

L' Eomot Inversé (5/3/2012)

Snarking...

Don't know the answer by heart, but you can easily test this yourself.

Duplicate post. Original thread can be found here:

http://www.sqlservercentral.com/Forums/Topic1295778-148-1.aspx

You can run the reports in .NET using the ReportViewer and use a fixed set of credentials to run the reports.

You get all question marks in table 2?

How do you load the data into table 2?