Wow you guys are fast! Now I have to dissect the code to understand it. Thanks!

Try to do this

--> Create temtp table

CREATE TABLE #Test(MonthOfYear int, Year int, Account int,Name varchar(255))

INSERT INTO #Test

VALUES(1,2013,1,'A')

INSERT INTO #Test

VALUES(12,2012,4,'B')

INSERT INTO #Test

VALUES(1,2013,4,'C')

INSERT INTO #Test

VALUES(1,2012,1,'D')

INSERT INTO #Test

VALUES(1,2013,5,'E')

--Build dynamic sql

DECLARE @Month int, @Year...

You probably need to modify your dynamic sql. Without seeing how you are actually building the sql (meaning we need to know how data is being passed in the...

I am so stupid...all I had to do was delete the missing RDL's that was showing up in Solution Explorer

It works fine if I create a new report. Some of the existing reports do have a sub-report but I am sure its pointing to another report since the...

So I went further with this but need more help. I created a report parameter called Expand_Collapse to hide/show the rows. Here is the code I am using...

I could've sworn I tested it without the dataset name yesterday and it error out. This script works but I...

The value is blank and your code didnt work. Its still showing the blank rows

Thanks that worked!

It works fine before without the Send Mail Task, once I added it and deployed to the server, I can see the SMTP Connection Manager was also uploaded

Thanks opc.three! I had our dba log in with the sql account and run the batch file to accept the keys and now it works 😀

If its a permission issue why doesnt the package error out?

btw, which type of permission?

so do I need to install VS 2008?

dtexec /f "H:\DEVL\SSIS\ADPR Import\ADPR People Import.dtsx"

ahhhh mucho gracias amigo! it was driving me nuts lol