I'm using Sql Server configuration. I am also using a global variable called ServerName which tells the package what server to pick up the configurations from. Maybe this...

Can you please tell me how you set up the alias and if you don't set up configurations how does your package pick it up?

my configuration includes the connection strings.

This would make it easier but we do not have localhost available in Prod

I use Don'tSaveSensitive. I did realize that in this new package that I'm getting ready to deploy, I had the wrong ProtectionLevel. I will change that and...

Thank you. You answered my questions.

I didn't think so but you never know if someone has found a way around this.

Thanks again.

Thank you so much.

My source is a Sql Server table. The only way I can think of deleting rows from my destination sql server table is to have an 'Execute Sql Task'...

The result set returned by the stored proc looks like this

Project PivotHeader PivotValue

1 ...

We are at the beginning stages of creating a data warehouse because we have reports that run slow (and often time out) due to the complex logic in the sp,...

Let's say the result set is 50K rows and has 50 columns. I want to split up the columns among different tables. I think I can use a...

Rick,

I'm trying to set up an SSIS package to do the following:

1) Run a stored procedure against an OLTP db (Sql Server). This sp will basically denormalize the data.

2)...

Your suggestion were very helpful. Thank you!!

For anyone needing help with this, I got it to work building the string like this:

Add the following string to the 'Jump to URL' function.

="void(window.open('http://localhost/reportserver?/foldername/reportname&rs:Command=Render&ParameterName1="& Parameters!EndPeriod.Value &"&ParameterName2="& Fields!ACCNT_CODE.Value &"&ParameterName3="& Fields!ANAL_T0.Value...

The function works perfectly but I can't use it because I have to work off of a temp table.

This data (the ledger info) will be used in a drill through...