Your question isn't entirely clear for me.

How many servers do you have?

What is the "BI server"?

Please do not crosspost. It wastes people's time and fragments replies.

Original thread can be found here:

http://www.sqlservercentral.com/Forums/Topic1412112-147-1.aspx

What exactly are the package tasks?

Does the webapp user have the required privileges to execute the package?

If you don't have a lot of connections, I would set-up a configuration table and store the username and password there.

That way you won't have to use a password to...

This is very important. Since you specify you can't filter on aggregate values, the HAVING clause acts the same as the WHERE clause. In other words...

Apparently, there are 4 winter months? 🙂

Anyway, I don't have AdventureWorks 2012 installed on this machine, so I had to guess. Quite a pity, because the idea of the question...

So you get a csv file with a comma delimiter and a double quote text qualifier. What's the issue with SSIS?

NOLOCK will probably enhance performance,...

This was a collation issue, not a low memory issue.

CTEs are not always used for recursive operations. You can also just...

Maybe you can use the ACE OLE DB provider, this one is available in 64-bit.

Admingod (1/24/2013)

---

I tried with SSIS it didnt work. The data are separated with double and single codes, while loading from CSV table its not getting the data in right format.However,...

Didn't know you could install SSMS seperately. Isn't this an express edition?

I always install SSMS using the full SQL Server media.

I watched Total Recall, and it was OK. Nothing special, but a good night of "popcorn no brain needed" action. I liked the original better though.

My favorite geek movie of...

Easy Friday question, thanks!