Have a look in INFORMATION_SCHEMA.VIEW_COLUMN_USAGE for the view-related info - you may have to join that to another i_s view to get everything you want.

david.ostrander (8/16/2012)

---

Hello -

I currently have an SSIS package being built where I want to upload rows from an excel document into a Recordset Destination in SSIS. What I'm having...

I'd like to nominate this as a candidate for the 'esoteric thread of 2012' award 🙂

If you've been able to derive the question, why not go ahead and answer?

raghuldrag (8/16/2012)

---

hi friends

i ve created on table create table rab(deptno number(33),

job varchar(22));

insert into rab ('22','clerk');

insert into rab ('25','manager');

insert into rab ('20','sales');

output:

deptno job

22 ...

It would be polite of you to answer mine and Anthony's questions - they are there for a reason: we are trying to understand your reasons for doing this, whether...

kishor.patgir (8/16/2012)

---

Hello All,

I have one table which have one field sr_no. in this field data up to 1.to ..100.

In this if i delete some record then sr_No not Maritain.

I want...

gayathri-b (8/15/2012)

---

Kindly Help me out ...Even I face the same Issue...

Is there anything to do with teh DB2 settings like time out etc.,

From SSIS do I have to configure the...

Teee (8/15/2012)

---

Hi,

I need to take the characters from the left before the '/' string and insert into a column and the characters on the right after the '/' string...

patrickmcginnis59 (8/14/2012)

---

Shadab Shah (8/12/2012)

---

Jeff Moden (8/10/2012)

---

Shadab Shah (8/9/2012)

---

Hi all,

I have come across various section on this website where it is mention that SQL Server is a set based programming language.

...

Sounds like you want to do the sort in SSIS rather than T-SQL - bad idea. One way or another, you should make the SQL engine do that work for...

priest Ivan Delic (8/14/2012)

---

Thanks laurie!

There is something else but I think I could work it out. One of the problem was a thing that I didn't entered few row data,...

I'll be honest, I don't know how to execute a scenario.

But if you're asking for a...

GSquared (8/13/2012)

---

Sounds like a serious step backwards in data management technology.

Don't call the database for each row of data. Use a script object to write each row to a...

Granted I don't know all the facts, but I really don't like the sound of what...