How can we do with SQL Server Management Studio?

No one have the ideas to do this task?

Please share if you have any type of Idea?

steveb (11/18/2008)

---

to do a count(*) for each table you can use;

sp_MSforeach table

create table #rowcount (tablename varchar(128), rowcnt int)

exec sp_MSforeachtable

'insert into #rowcount select ''?'', count(*) from ?'

select...

Thanks for you reply Lowell.

I am try both the solutions. I will prefer the accurate one.

Accuracy is more priority than performance so the SP must have to provide the accurate...

Howard Hung (11/17/2008)

---

Hi all,

Problem:

SSIS package failed many times.

Reason:

However, there are blanks in some of the columnName.

At first i thought they are spaces, even using the expression substring(columnName,1,1)=" ",...

Thanks Pritesh.

But the problem is that only. I can not use the Send Mail Task.

The DBA has prepared on SP to do the mailing. I have to give the parameter...

OK. I found the solution.

Here is the query to get the all the primary key and Foreign key coloumn...

Quatrei.X (9/11/2008)

---

Hi there,

sorry if what I will, give you is not what you want. I didn't finish reading the code cause I was just given a new task. Anyway, I...

Could some one help me out please?

Tim Mitchell (7/9/2008)

---

I believe you are confusing the raw file destination with the flat file destination. A raw file is a special kind of SQL Server data file storage,...

crazy4learn (7/9/2008)

---

Hi

I have 4 tables ,all have same fields like emp_id,ename,joindate

3 out of 4 table have same this 3 columns ,but have different data set

table 1 have data...

Thanks a lot Frank. Now it is working:)

Could some one help me out please...?

If you tell what you are doing in SSIS probably I can tell you where is the problem?

What you are doing in SSIS? What is the source and what is...

ivanaperic (7/3/2008)

---

Hi all!

I am getting this error, when I try to insert data in OLEDB destination:

[OLE DB Destination [4316]] Error: SSIS Error Code Hresult: 0x80004005 Description:...