Ricu, by the looks of it, you are getting this error because your two triggers are causing each other to fire, this is never a good idea as it'll just...

This is a pretty poor example of how to do this imho.

If you wish to do the dreaded "like" you should have two sets of params, one set when you...

Hi Anil,

I'm glad this helped

All the best

Dave

npothineni (7/6/2010)

---

Hi Dave..

We have millions of records ,so comparing with reference table must take more time,so we dont want to lookup,i will try with that solution what you have given...

SSIS.COM (7/6/2010)

---

I am not using any result set here. That option is set to none for my execute sql task. And I am just assigning a value to a variable...

Anil, really without referencing the base table this is the only real way around it as you can never know what you have already loaded

I suupose you could go...

Hi,

I'm pretty sure this is because, even if you set the ResultSet option to single row, your output can potentially still contain multiple colums (values) i.e. if you did a...

A work around would be to create a table with one column called last load and put the date and time of the last load you did.

Then simply only incrementally...

Hi derek,

a nice way of find out what is happening is to put a try catch block around the code and create a table to store the expection information

so...

Hi Ram,

If I have understood you correctly you want to look at a windowing function called RANK()

Look it up in BOL or google it, I think this should give you...

Hi Asif, could you give some more detail on what you are trying to achieve. i.e. are you trying to count how many hours per day ignition is "on" or...

Lowell (6/11/2010)

---

Stumpy D (6/11/2010)[hrSo other than indexing restrictions, there is no difference if I declare a varchar(8000) and a varchar(10) to store a 10 character string?

Seems odd as why even...

Lowell (6/11/2010)

---

i think the biggest impact on varchar sizes has to do with the ability to index the column.

if the column is bigger than 900 bytes, the index rasies an...

Gangadhara MS (3/30/2010)

---

Hi,

Should i use a File transfer task at the end to move the inserted file to another folder.

My initial requirement was in the common folder i will...

Phil Parkin (3/30/2010)

---

There is another option which does not require script. Put the whole process inside a FOREACH container. When the package executes, if the FOREACH container does not find...