My...

sqlfriends (11/22/2011)

---

I have a ssis package with data flow tasks etc.

I would like to do incremental import and update instead of using truncate or delete to import data from staging...

Debbie Edwards (11/23/2011)

---

Quick updaet,

I tried and tried but failed to get it working. I really didnt understand the script stuff onm the last post but I nearly got it sorted...

Debbie Edwards (11/22/2011)

---

I think I have done it (Hopefully)

I just ran the test and obviously it failed.

Im getting errors such as Error: The type of the value being assigned...

Debbie Edwards (11/21/2011)

---

Im just trying to copy and paste the bits out from one to another, Its gone a bit wrong so Ill need to do a bit of fixing

Ill...

I know it is extra work, but in order to see where you are going wrong it is better to look at the actual package.

If possible, please create a small...

Could you please post your package...I cannot get to your blog from here.

That's ok...it's a little confusing at first, so let me explain in detail.

Your SQL query (in the Execute SQL Task) returns an ADO Recordset object, which can contain rows and...

You don't need a separate variable for each field in the returned resultset. It can all be contained with the same object variable, and then used in the variables mapping...

Debbie Edwards (11/21/2011)

---

Its kind of there but it doesnt use a table to populate the variables. it seems to be focused on the Filename variable again, It seems to be...

or this...

http://www.sqlservercentral.com/Forums/Topic530435-147-1.aspx

Have a look at the following, and see if it explains it well enough...otherwise I can have another look: http://microsoft-ssis.blogspot.com/2011/02/how-to-configure-foreach-loop-file.html

Yeah...tough situation.

I think no. 3 would be your most sustainable option in the current setup. Sure, creating a hundred empty files is a lot of work but not as much...

Debbie Edwards (11/18/2011)

---

I had thought about that but couldnt find where to do it in the job.

So is the above not possible? Setting the parameters at the top level for...

Debbie Edwards (11/18/2011)

---

Ive had a thought but I dont know if its doable

A top level package which runs the package with the SPs in

Set the parameters up at this level

Delete...