Hi Paul,

Thanks for the earlier replies.

A new issue just arose. I am getting the following error, when I am dealing with a large chunk of data.

Msg 512, Level...

Hey,

Can you tell me why do I get an error for the following?

Column name have been declared as Version Number. --This is fine.

When writing stored procedure,

Set Version Number =...

Thanks Paul!

Hi,

1) Can anyone tell me this difference in code?

Update Event_Person_Info

SET Cert_Status = Person_Info.Cert_Status

FROM Person_Info --Line 3

WHERE (Event_Person_Info.Names = Person_Info.Names AND Event_Person_Info.Country = Person_Info.Country AND Person_Info.Cert_Status = 'Y')

Update Event_Person_Info

SET Cert_Status =...

Paul,

You are awesome. Thanx for that code...I never knew of those syntaxes in SQL. I am going to use them for my code.

Steve, thanks a lot for the inputs.:)

You guys...

Robust in the sense that it will be more reliable, I mean with just ascending ordered numbers the app_IDs will have a biased numbering form. I mean it is like...

Hi Everyone!

First of all let me take the time to thank all of you guys, Paul, Steve, Old hand for helping with my case here. Really appreciate it guys 🙂

To...

Hey thanks a lot Guys.

I still wanted to use random generation, because I am a C programmer and was expecting to achieve same objectives using C codes and SQL. Basically,...

@steve-2: Actually what I need is unique number in AppID column, as a new row is entered.

Hi Guys,

In simple terms I am trying to generate random numbers and store them in AppID column. But every row must have unique numbers. The algorithm would be:

1)Generate random numbers.

2)Check...

Hey,

Thanx a lot. Its the exec Proc_name that I didn't give earlier.

Cool, works fine.

Thanx and best regards,

Tasnim

Hi could you tell me what setting I should use? Because I have created a stored procedure in the database. Now I want to run that stored procedure in the...

Hey,

Thanx for the blog...But it still doesn't answer my question...

I am interested to know when stored procedure is executed successfully in integration services, does it do the updates/changes to the...

Hi,

I have changed the connection string, as u showed in the picture. It is still not working, I guess I am missing something huge here. Look, I am simply doing...

Hi,

Correct me if I am wrong, the connection manager is the one part of Microsoft Visual Studio 2005 (or the SQL Server Business Intelligence Development Studio).. In that case, where...