Load the whole lot and then do the insert/overwrite trick.

This will...

MattF (3/31/2008)

---

Hi,

We get an error running a SSIS package which calls another package. Both packages execute Ok independently. Error: "The LoadFromSQLServer method has encountered OLE DB error code 0x80040E09 (The...

Sanata Kumar Nayak (4/1/2008)

---

Hello All,

Can someone guide me how to achive this?

Requirement is : To backup a table to a file named as filename_currentdate.txt .This is to be done...

Kenneth Fisher (4/1/2008)

---

I'm trying to load a series of large text files using SSIS. The largest of them is around 30 million rows. The average will probably be...

You are right. It is confusing and they assume that you spend weeks and weeks on digging forums, asking questions, trying before you understand how to _effectively_ and correctly use...

Thank you. You are right. desc 'viewname' against the view which has calculations and aggregations in oracle gives a bald NUMBER agains the SUM and AVE and NVL and...

Hey. Thank you for help.

I just figured out. If using OLEDB source you could source the SQL statement from a user variable.

When using a Datareader you could create an...

I...

If you really need to use SSIS you are stuffed as you can see.

You need to do something else here. I am thinking about BCP into a dummy table and...

what da... itd be interesting to hear what microsoft say about it...

I run on 32bit. keep us posted.

Jeff Moden (2/22/2008)

---

Dunno... I loops were possible in DTS... I don't see why they wouldn't be in SSIS. My problem is, and I guess I should apologize for getting...

J.D. Gonzalez (2/22/2008)

---

Is SSIS a requirement? If not, why not use bulk insert to load the data. For our environment, we have a table that has the file...

I am thinking about it, but the management would argue that I am distorting/abusing the concept of ETL, SSIS and all the rest of it.

It would be great if it...

Valid comment, but it is not my decision to get rid of 2000.

Having legacy atavisms sitting in there and stuff is also not good for me who will be looking...

Thankx

This IS and is NOT what I wanted to see.

This is a solution but the solution "through the ar$e".