Do you get wrong data if you connect with the regular OLE DB source?

Switching careers just for the money is usually not a good idea. You have to make sure you will actually like what you are going to do.

Being a DBA can...

Easy peasy. 😀

If I'm not mistaken, Excel uses MDX, Power View uses DAX.

You need to use the Unpivot transformation.

How To Use the Unpivot Data Flow Transform in SQL Server Integration Services SSIS[/url]

The unpivot however accepts only a fixed number of columns as...

1. File System Task

2. Execute SQL Task (SQL) or Execute Process Task (batch)

3. Data Flow with corresponding sources and destinations.

4. Send Mail Task

The SSIS development team really did their...

Dealing with NULL values can be tricky in SSRS, depending on the source.

What is the source? SQL Server , SSAS?

Normally I don't calculate conditional formatting, but when I do, I...

And...

arjan.hulshoff (2/4/2014)

---

That's basically the only solution. I did some more investigation, but it is not possible to assign a specific version to an environment. So the only solution is to...

Is it a possibility to deploy the project to different folders in the SSIS catalog?

Do they run Internet Explorer as Administrator?

Please do not crosspost. It wastes peoples time and fragments replies.

Original thread with replies can be found here:

http://www.sqlservercentral.com/Forums/Topic1537645-391-1.aspx

avdhut.k (2/4/2014)

---

but according solution part II in this article,

I had made this column as general,

But problem now is data 2011053006233 ...

Great, it will be nice to have some cartoons again.

Did you set the DelayValidation property on the connection manager?

If your package is so big, it is better to split it up in smaller packages. This is more manageable and it makes the guy who comes after you not...