Any idea why you needed 6,4 in the...

Whoops, I...

I would loop through your files and use presedence constraints to determine which table to write to.

Do you know what the file definition will be for each table ahead of time?

shirishjani (11/11/2010)

---

If from folder i take file one bye one

suppose

1 is jann.txt then i have that table for that schema is ready so just want to insert in...

You could use the PIVOT relational operator to get the same result too.

PSB (11/11/2010)

---

Hi,

I have a phone field in the excel source. Sometimes it comes as xxx-xxx-xxxx and sometimes xxxxxxxxxx .

I have to check if the length of the field is...

Elliott Whitlow (11/11/2010)

---

tmitchelar (11/3/2010)

---

There is a solution property called Run64BitRuntime. You can set it to false to run in 32 bit mode. Note - I wrote 32 bit,...

Craig Farrell (11/10/2010)

---

@tmitchelar,

I agree with you it's possible, but the 4.xml statement was the one that got me. He's overloading the load with multiple types, which is gonna go...

conningtower (10/2/2009)

---

Hi All

I m trying to access an Oracle table and update a sql table based on a primary key match between the two tables.

What I ve done...

shirishjani (11/10/2010)

---

Hi

Want to make SSIS package

it will take file from folder and insert that file's data in SQL server

every day in folder i receive different type of...

You could perform a lookup to the destination table on the primary key, and then only insert records that fail the lookup. You could even redirect your records that...

Linda 44925 (11/9/2010)

---

I’ve never done any work with CTE’s before and I would very much appreciate it if you would give some more detailed explanations of why you changed the...

Have you tried changing your row delimiter?

A couple of things...

I would make sure there aren't any other processes running on or against that server at the same time your process is running.

Or you could...