Profile

Hello all I have a job which tests whether a table exists or not, and it not then it creates the table with an SQL step. On the first run it does not find the table and creates it, however on any subsequent run the Table Exists fails to detect the table and tries to create the table again with the following ...

Ah Petr, you're a superstar... thanks so much.

Thanks Petr, but that also does not resolve the field.

Thanks so much for responding Thomas. However Alert(["Date Imported"]); only prints the literal string "Date Imported".  It does not resolve the field by that name!

I have data coming from a CSV feed. Some field names have interspersed spaces. Normally you delimit them with backtick, ie `field name`, characters in SQL. In the Formula transformation you use [field name]. However, neither syntax works in the Modified Javascript Values transformation,     nor does ...