I believe that SQL browser listens on UDP port 1434 not TCP port 1434. That makes a difference.

I think the moral of the story is "don't let SQL decode...

I guess I'm wondering where we are in this process, do we have anything working, have we made any progress, please advise.. I've been busy during the day, its...

I think in the cases of OLEDB providers I'm not sure whether there really is a 2005 or 2008 except for the SQL DB Engine.. The MS DB2 OLEDB provider...

I believe the storage location to be as much a function of preference as it is policy. In most cases I store them in the package store, I build...

I think a lot of this question is preference. master I only do full backups on, its little, and it really doesn't change. Yesterday's copy will be almost...

Internally there are several ways to detect this, one of the best IMNSHO, is VersionBuild in the package properties, it is updated everytime the package is saved (if there were...

CLR in triggers.. I don't think I'm a fan of than.. I have built CLR UDFs, sprocs, and TVFs, but triggers and UDTs scare me some.. But I...

The way that is read is the row that has the value over zero is being blocked by the SPID listed.

I'm going to cut out a lot of...

Wow... That is so far over the line, that I can't even see the line anymore. Here, do you want my bank account passwords too while you are...

Permissions issue? Your user has permissions while the user that SQL runs under does not? I see it all the time..

CEWII

I would start at:

Microsoft Connectors for Oracle and Teradata by Attunity

http://www.microsoft.com/downloads/details.aspx?FamilyId=D9CB21FE-32E9-4D34-A381-6F9231D84F1E&displaylang=en

As to whether they are 64-bit or even SQL 2005 SSIS, I can't say.. But this is where...

Apparently it didn't exist on the default instance..

CEWII

My idea really only covers the if not exists go do something else process. You can use the multicast operation to generate two seperate paths for the data..

Not sure,...

Exec sp_who

Look at the blk column if this is zero it means no blocking, I'm betting your process is being blocked.. You need to know the SPID of the...

3 Stupid questions.. Sorry I have to ask (bad experiences when I didn't)..

1. Is the sproc actually owned by dbo, did you specify that when compiled..

2. Is the sproc...