Sounds like you need to use the Lookup Component. The Lookup Component is like a JOIN in SSIS. You define the source of the lookup and the column(s)...

Wow, I looked at this because I thought I might be able to help, but I can't because you apparently edited the post into nonsense. Plus you insulted...

GilaMonster (1/12/2012)

---

Bex (1/12/2012)

---

From someone who is a lurker on this site, I take the attitude that if I ask for free help and I don't like the reponses I am...

SQL Kiwi (1/11/2012)

---

:laugh: But seriously, the example code did not specify NOT NULL as...

Thanks Gail and Paul. I always learn something when y'all post.

Oh, and as far as inserting a NULL code, you shouldn't have NULL's:-P

SQL Kiwi (1/11/2012)

---

None of them for the reasons already stated, plus option 2 also contains a race condition.

DECLARE @MYCODE int = NULL

DECLARE @ID int = NULL

DECLARE @OUTPUT TABLE (ID int)

MERGE...

Dev (1/11/2012)

---

If somebody can login to Application Server & read configuration files, he can delete website as well (worst scenario).

SQL Server Logins are manageable for Web Applications. Few...

Little Nick (1/11/2012)

---

RESOURCE_SEMAPHORE_QUERY_COMPILE waits is high. My understanding, this nothing to do with my ASP.NET code technique

Let's, my same Stored Procedure is execute 500 a day. Did we have special...

GilaMonster (1/11/2012)

---

Jack Corbett (1/11/2012)

---

How about option 4:

Declare @ids Table (id INT);

IF NOT EXISTS (SELECT * FROM myTable WHERE CODE=@MYCODE)

BEGIN

INSERT INTO myTable (CODE)

...

You can't write directly to a table with a server-side trace. Even if you could it wouldn't be wise as it would not perform as well as writing to...

How about option 4:

Declare @ids Table (id INT);

IF NOT EXISTS (SELECT * FROM myTable WHERE CODE=@MYCODE)

BEGIN

INSERT INTO myTable (CODE)

OUTPUT Inserted.id into @ids

...

Dev (1/11/2012)

---

I don’t prefer Windows Authentication based database servers for Web Application. It’s better if user login with Application (Web) Login Name and Application Server translate its credentials...

AER (1/11/2012)

---

Jack,

Thank you so muck for your help. I totally agree that the Windows Authentication is the most secure way of handling the application pools.

Now since I'm more on SQL...

Little Nick (1/11/2012)

---

My current code as following,

Dim sqlNm As String = ""

Dim sqlNm2 As String = ""

...

Normally with SSIS you would do this using SSIS configurations or by setting a variable value using the command line options. Here are a couple of resources:

http://consultingblogs.emc.com/jamiethomson/archive/2007/03/13/SSIS_3A00_-Property-Paths-syntax.aspx

http://msdn.microsoft.com/en-us/library/cc895212.aspx