mahesh.yerragonda (3/24/2014)

---

For ssis configurations,I used sql server table where the password gets picked from table.

Right now it is encryptsensitivewithuserkey,I tries using donsavecasesensitive but when open the package with admin account...

aaron.reese (3/24/2014)

---

Thanks Koen, If its good enough for you, then I will take that option 🙂

Next question. Which files need to be in SCC and which one don't....

dan-572483 (3/21/2014)

---

I'm working in SSIS 2012 and I'm trying to use a query in an Excel Source to bring in only the data I want to use. My query...

When I worked with SSIS and TFS, I used the second option.

I'm no TFS expert, but can't you configure it to ignore some extensions? I don't recall to have much...

mahesh.yerragonda (3/24/2014)

---

Hi,

I created proxy login for user and created job to run the package.

below is the error im gettng.

"Description: Failed to decrypt protected XML node "DTS:Password" with error...

+1 for simplicity 😀

Yes, tempdb can be moved to ssd....

How did you try to run the package in the first place?

What is the error that you got?

Nice follow-up question, thanks.

How exactly did you implement the multi-select for the companyID parameter?

Without any clue on what the desired output is, how the query looks like et cetera, this question is impossible to answer.

You might get rid of your LEFT OUTER JOINS,...

In your second query, you also left out the data range where clause in the subquery on [dbo].[tblClientLog].

This means you will now have the entire table of tblclientLog as a...

Maybe you can use the Google Maps API?

http://stackoverflow.com/questions/1502590/calculate-distance-between-two-points-in-google-maps-v3

Regarding point 1: web will not suffice, you need at least standard for SSIS.

1) Express only has the import export wizard, but you cannot edit SSIS packages or run them directly.

2) Maybe they use the DTS task inside SSIS to run the DTS...