kocamisu (9/20/2013)

---

Hi all,

I'm new using SSIS.But as i said at topic,had many success tests for these kind of things :

flat file to db or opposite db to flat file.For...

I think you meant 'semantic', unless your solution is proposing an unorthodox anti-virus methodology 🙂

BowlOfCereal (9/17/2013)

---

I gave up on this. I think the SMO transfer class (and therefore the SSIS transfer objects task) simply doesn't allow for changing certain object properties. My...

Have you tried using a data conversion task?

..back to SSIS.

If you want to update a row in SQL Server for every row that is transferred to Oracle, I'm not sure about this method. Are you trapping error...

Nice alliteration!

Or this maybe:

with MaxDates as (select id, MaxMod = max([Modified on]) from @Audit a group by id)

select a.id,a.Owner, a.[Modified on],a.Value

from @Audit a

join MaxDates m on a.id = m.id and a.[Modified...

Many servers have an additional layer of security which prevents file creation at the root of the c: drive...

nishav2 (9/11/2013)

---

I have deployed the package in my local file system and the file does exist.

Also the filename is stored in a variable and evaluated as expression:

Variable name...

Not sure what you mean. There's no equivalent 'empty integer' - just either values or NULLs.

+1

Does the c:\SSIS folder exist on the server?

azdeji (9/11/2013)

---

Below is the sample XML code which produces empty strings but to ssis they are null values -

<from></from>

And I try adding default values but they still showed...

azdeji (9/11/2013)

---

For the string data type, the XML source adapter converts incoming empty (zero length) strings to NULL. This means there's no way tell if the fields was present with...

I can see why they would embed the selection SQL at demos and presentations - keeps everything in one place & helps things flow more easily.

But in all the places...

You could use a 'numbers' table to do this (1,2,3,4,5,6,7,8,9,...).

Join to...