Sure....

ahmed_elbarbary.2010 (12/6/2012)

---

I have two databases these two databases have same structures and objects but different only in data

Are there are any way to transfer data(only) from one databases to another.i...

CptCrusty1 (12/6/2012)

---

Ok... this might get lengthy... so please bare with me.

I have a DTSX package that has over 30 steps/containers, etc. I'm using Sequencing events, groups, etc. ...

bobd125 (12/6/2012)

---

So ignore the Derived Column and just used "((DT_I8)DETAIL_REC_CNT == (DT_I8)[INT_SENT-REC-SNT] ? TRUE : FALSE " is the Conditional Split. And how do I set the Error...

Snargables (12/6/2012)

---

I have to update 9 million recs. I've buildt a loop that does N updates per loop. I dont wnat to use trasactions because i dont want to block...

Is anyone else wondering how long ago...

robert.gerald.taylor (12/6/2012)

---

bobd125 (12/5/2012)

---

What is the best way to make your SSIS Data Flow to fail upon a data condition check. What I'm doing is reading a flat file...

DBA12345 (12/5/2012)

---

I want to insert values in to “Table B” from “Table A”. Both the tables has only two columns and same.

Table B is destination table and it's constant. Table...

rburko (12/5/2012)

---

I tried this method this morning, but I must be missing something.

We have SQL Server 2005 running on a 64 bit server. I loaded Microsoft Access Database engine...

I found the answer - just add [master] as a database reference in the database project and the warnings go away.

I would hate taking over the maintenance of a database which contained triggers like this. On behalf of those who may have to maintain your code in future, please reconsider....

inmallinath (12/4/2012)

---

I had tried this a while ago. This messes up the use of office applications.

When you launch any of the office applications, it starts to install the software.

Am I...

Saintmount.Sql (12/3/2012)

---

Thanks for your reply,

But I want to insert below selected values to another table by random way.

Ex:

select Distinct code_id from Pri_codes_master

where code_description like '%assignment%'

--ORDER BY NEWID()...

As far as I know, the format of files generated by either the 32-bit version or the 64-bit version of Excel is exactly the same - so referring to '32-bit...

You've made it more complex than it needs to be - no need for the SQL Server variable. Just this should be fine:

select top 1 code_id from Pri_codes_master

where code_desc...