use sqlconnectionstringbuilder class:

http://msdn.microsoft.com/en-us/library/system.data.sqlclient.sqlconnectionstringbuilder.aspx

basically, what you want to do is use the above class to set username/password for connection string.

use try/catch block to open a connection, and if try works...

I've had a similar problem on 2005sp3 box, and while I'm not sure if your causes are the same, I'll post what I found out. One of our applications kept...

you can have ssms do that for you. right click on the table name, script table->select to->new query window. then just search and delete your extra columns.

Forgot to mention that the destination database resides on SAN. I'm currently looking into getting SAN IO and network utilization tested. It still doesn't explain a table of 2 mill...

see if someone else had the same issue:

http://www.google.com/search?hl=en&client=opera&rls=en&ei=vehyStWWDY-MNqrd6bAM&sa=X&oi=spell&resnum=0&ct=result&cd=1&q=A+transport-level+error+has+occurred+when+receiving+results+from+the+server&spell=1

@chandu, I'm pretty sure the code will throw an error message.

From BOL syntax for dropserver: sp_dropserver [ @server = ] 'server'

...

I found the root of the problem. One of the applications that was using the database server ( a ticketing system ) has ticket as an object. the problem with...

here're the results:

Sometimes it's hard to convince AD admins to allow delegation. Are you scheduling jobs on that cluster? You could set up jobs on the same server as your ssis package...

probably should've asked from the beginning: why are you trying to read data in batches of 100?

does the tblUser have a column to hold "unreal" PK from the spreadsheet...

navenis4u (7/29/2009)

---

Hi,

I have a excel file with multiple data sheets . Each data sheet represents a table of data. each tables in the data sheet is related by the integrity...

phumlo1 (7/28/2009)

---

Hi All,

I have an SSIS package which i have scheduled to run as a Job in SQL SERVER 2005. My question is how do I add alerts? if i...

32 bit with PAE/AWE enabled;

3Gbs ram...

Thank you! I'll post with the results and/or any findings in a couple of days once i have more information.

Thanks everyone for the ideas. A couple of things I should've mentioned is that I have read-only access to the oracle table, the oracle side will not change any of...