etl.laptop (9/26/2013)

---

I want to make a package to load some text files into a database table. Any suggestions on how I can check if a file has been loaded already...

How about this?

Will the tables all have the same DDL?

If not, this is practically impossible to do without C#/VB.NET coding. Unless you decide not to use data flows and instead code the...

Indeed there is. The 'Add Poll' button is there for precisely this reason :hehe:

And in mine....

etl.laptop (9/20/2013)

---

Phil Parkin (9/20/2013)

---

etl.laptop (9/20/2013)

---

I know that it supports MS Visual C# and Visual Basic. Can we add more languages to it ? For example - Python, Java, JavaScript etc....

basic 79842 (9/20/2013)

---

There may be a function in there already but I use only the barest minimum of the features. So Please excuse my ignorance. I have a...

etl.laptop (9/20/2013)

---

I know that it supports MS Visual C# and Visual Basic. Can we add more languages to it ? For example - Python, Java, JavaScript etc. ?

Also, I have...

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...