To Database Pass, Create Table, Weird Error

[brandonbollin]

Hello all. I'm trying to create a table with a To Database pass. According to SAP documentation, if you use a To Database pass and the specified Database table name doesn't exist, IDM will create it. That doesn't appear to be happening here. I'm also dropping the table before that pass runs as I want a fresh table every time. Don't know if that counts for anything or not but, thought I would mention it.

I know the SQL query in my Source tab works because if I use this same query in a To ASCII pass, no problems. Let me know if you know what this error message means and if you can help me understand why IDM won't create this table. Thanks.

[brandonbollin · Accepted solution]

I figured this out. In my Entry Script, my return line was:

return "";

I cannot return nothing in my Entry Script, I need to return Par.

return Par;

Once I did that, everything started working.