zi (6/22/2015)

---

Dear Experts

Thanks for replying

I just want to schedule and automate this process without any intervention

some one advised me to use setting called MAX ERROR, but I couldnt find...

Or put a DEFAULT (GetDate() / GetUTCDate()) constraint on the new column.

In your source proc, include an isnull (column,-1) check on the column and use -1 (or whatever ) as your default member. The lookup will then succeed.

keshab.basnet (6/21/2015)

---

Previously same records exists in table having primary key and table having foreign key . we have faced 7 records were lost from primary key table but same record...

am_mal80 (6/22/2015)

---

Hello Eirikur Eiriksson;

I create the lookup task to check Filename in Table from database.

The problem is sometimes the file is created early than Filename generate in database table.

So, the...

Recreating the package manually is your only solution.

We are also using it for tables that have more configuration type data basically less data changes.

Using this in conjunction with FileTables to replace 100's of SSIS packages for importing...

No difference at all. Both of the proposed ideas pick up whatever is there at run time.

Alvin Ramard (6/19/2015)

---

Phil Parkin (6/19/2015)

---

In other...

Alvin Ramard (6/19/2015)

---

Phil Parkin (6/19/2015)

---

richardmgreen1 (6/19/2015)

---

Hi all

I've got an SSIS package that loads a block of CSV files from a specified folder and moves them to another folder after processing...

richardmgreen1 (6/19/2015)

---

Hi all

I've got an SSIS package that loads a block of CSV files from a specified folder and moves them to another folder after processing them. It then...

A brief search suggested this.

nidhi.naina (6/18/2015)

---

Hey..

Thanks.

removing the index helped by bringing down the time to 6 seconds.

Can you please help me with why it might have been used in first place. (possible...

Jonathan Marshall (6/18/2015)

---

Hello everyone,

I have been giving the task of profiling databases and all the tables within it.

Right now I'm collecting the following:

Null_Count

Null_Percentage

Total_Record_Count

I'm looking to capture Mean_value, Min_value,...

nidhi.mahajan (6/18/2015)

---

I have this simple select query in a proc and the query is taking approx. 30 seconds to return approx 35000 records.

I am a beginner. 🙁

Can you please...