Good choice, for me you can go further and remove the words 'all but'. It's usually too slow as...

Is that the source or target table? This table contains duplicates and (therefore) I am guessing that it has no PK.

As an aside, Day_Month_Year is not a good choice for...

compufreak (2/26/2014)

---

Hi phil

I have a ID column which is the primary key of my table.

the ID Column can be used to capture a record for the same ID as many...

compufreak (2/26/2014)

---

Hi everyone

if possible , can I create a package to send an email that will only show the new records that has been added to my table.

once the new...

Nice work, well done!

You asked for suggestions ...

I would have loaded the condition data into an array rather than named variables. It's much easier in code to loop round an...

Or, rather than ColumnName, use ordinal position for direct access to it in subsequent code.

Dave R (UK) (2/20/2014)

---

Thanks again Phil,

that is sort of where I have got to, the problem I am having though is using a variable for the found condition....it si getting...

Dave R (UK) (2/20/2014)

---

Thanks for the prompt response Phil,

I have looked at the script component, but couldn't get the condition to work...the number of splits will be totally dynamic and...

Dave R (UK) (2/20/2014)

---

Hi all,

I've been looking for the last couple of days, but have been unable to find a solution.

Situation:

I need to load and split a text file, however...

smasihullah (2/18/2014)

---

Hello,

I'm trying to publish a workbook in Tableau and its giving the the message.

Database error 0x80040154. class not registered.

Drivers necessary to connect to the database server fdxsql........\INST1 are not...

Koen Verbeeck (2/17/2014)

---

Maybe you can monitor the log? Or kick off a monotoring script in parallel with your data flow.

You insert a row into a log table before and after...

That...

What do you mean by this?

abhas (2/14/2014)

---

Hi All,

My source file is coma separated file having 6 columns. But some times two lines are merging i.e. eow containas 12 columns instead of 6 and my package...

jevogelsong (2/13/2014)

---

I think you got me in the right direction. The package was a SQL Server package not a file system. I used this package and saved a 2nd version...