Can you be a bit more specific?

How are we supposed to answer a question like this?

Yes you can get data...

Please do not crosspost, it wastes peoples time and fragments replies.

Original thread can be found here:

http://www.sqlservercentral.com/Forums/Topic1472425-1633-1.aspx

First of all, wrong forum. This is the forum for DTS, which is the predecessor of SSIS and it's a totally different product.

Secondly, why only one DFT? You can add...

Good question, oldie but a goodie.

Explanation however is incorrect. The problem is not that the value exceeds the upper limit of an integer , I'm pretty sure 5555555 can fit...

What you usually do is creating an English column and a French column. For example English Product Description and French Product Description.

After you deployed the cube to production, you can still change the impersonation level to a dedicated domain account.

You could also do it during the deployment by altering the XMLA...

Technically, Flemish does not exist as a language. It is a dialect of Dutch. More...

Adi Cohn-120898 (7/9/2013)

---

Jeff – Sorry for disappearing, but for some reason I missed your response. What I wanted to do was very simple. I was working on improving...

Welsh Corgi (7/10/2013)

---

For instance I have a job that basically stops loading records. If I kill it it messes up the data if I do not let it finish because...

This MSDN page gives an overview of the permissions:

Select an Account for the SQL Server Agent Service

However, since it probably worked before it is maybe not a permission issue.

A little more detail.

1. Use an Execute SQL Task to retrieve the LastUsedNumber and store the result in a variable (let's call it @LastUsedNumber :). See this article on how...

No sorry. There is a tool on codeplex, SSISDowngrade[/url], but SSIS 2012 support has not...

acraddock (7/9/2013)

---

Hi,

For a while now we have been running SQL for our ERP system.

Recently i have noticed that a rebuild indexes task has not been running on the SQL database.

On...

Can you explain your scenario in a bit more detail?

SQLKnowItAll (7/9/2013)

---

We have upgraded a dev server from 2008 R2 to 2012. Because 2 apps are staying on 2008 R2, we have installed a named instance on the same box....