Eirikur Eiriksson (11/24/2014)

---

gravitysucks (11/24/2014)

---

create proc proc1 (@param1 int)

as

begin try

declare @param2 int

begin transaction

exec proc2 @param2

commit transaction

end try

begin catch

if @@trancount > 0

rollback transaction

end catch

i haven't had an opportunity to do...

Koen Verbeeck (10/29/2014)

---

The easiest way (in my opinion) is to create two environments. Each environment has the same environment variable, but with a different value. In the catalog, the parameter...

http://microsoft-ssis.blogspot.be/2011/05/referencing-custom-assembly-inside.html

Luis Cazares (10/20/2014)

---

The problem is with your way to handle errors. You need to have a try-catch block for each statement.

I guess that you have something like this:

BEGIN TRY

...

The proc loads multiple tables using a file at a time. I have try...

oops by bad-...

Thank You for this info-just one more curiosity- now...

Learner44 (6/14/2013)

---

try this one..

http://www.sqlservercentral.com/articles/EDW/77100/%5B/quote%5D

The Merge/Upsert will only work if there is (or create) defined set of unique key(s)-which according to the OP doesn't exist here.

SQL_Surfer (6/14/2013)

---

I have a view that pulls the data from severla large tables and then I load it to another table. Currently, the load takes about 40 mins as it...

AND SUBSTRING(LastName,1,1)<>'/' ---??

dan-572483 (8/24/2012)

---

If the length of the string might vary - but there will always be brackets - this will work:

declare @string varchar(max)

set @string = '{String you want to remove from...

Koen Verbeeck (6/25/2012)

---

It depends 🙂

Parallellism can give locking in your destination table if you are using a lot of indexes, but in such a large table you'd better drop the...

Rock from VbCity (6/21/2012)

---

Hi gravitysucks

Are you sure you are using a Package level variable to collect the value returned by your stored procedure instead of a task level variable?

If you...

Dung Dinh (6/21/2012)

---

I assume that you know how to retrieve value for SSIS variable from a store procedure

1- Create new a store procedure to insert SSIS variable into a table

CREATE...

Dung Dinh (6/21/2012)

---

If you want to receive an output value from a store procedure in SSIS package, you need to select

1- Create a SSIS variable such as MyVariable

2- Drag...