manickam (10/9/2013)

---

Even i am interested to have status and priority as dimensions, but does it have any impact on ETL layer.

Also the status and priority table would be having very...

You should give the user only SELECT permission on the view.

GRANT SELECT ON viewname TO username;

Not that I know of.

You could take a screenshot of course 😀

Or write an XML query or some .NET code that parses the XML and retrieves the variables.

Pragmatic Works has a documenting tool, but it is not free.

http://www.pragmaticworks.com/Products/BI-Documenter.aspx

SQLBlog.com also has quite some good bloggers.

Are we talking about SSIS or about DTS?

Interesting... Thanks.

Yes. And you need...

Shaun2012 (10/8/2013)

---

ok.. but when i execute it it goes to green but when it reaches to the look up the package complets but i see the look up is still...

hoolash (10/8/2013)

---

Hi all,

I understand that PowerView forms part of the Enterprise edition of SQL Server 2012, which I just installed on my local machine. As I am very interested to...

Shaun2012 (10/8/2013)

---

It fails when it inserts from look up with match output .but

i just removed space from 1 column and when succesess but did not update as gave...

SQLRNNR (10/8/2013)

---

Koen Verbeeck (10/8/2013)

---

Stefan Krzywicki (10/8/2013)

---

SQLRNNR (10/8/2013)

---

Stefan Krzywicki (10/8/2013)

---

Well, time to polish the resume and start looking for work. Just given a 1 month notice.

They want to keep me on...

Normally packages should be compatible between different versions of the same edition.

For example, it should not matter if the destination is SSIS 2005 sp1 or sp2.

However, SSIS is not backwards...

Allright, I did a small test and it seems that if you do not specify a full path, but only a directory name, the directory is created in the directory...

etl.laptop (10/8/2013)

---

Koen Verbeeck (10/8/2013)

---

What is the actual value of the string in the parent? Does it change when you run the parent package? Are configurations still applied in your development...