External SQL Data Sources (ESS)

[sqlagentman]

What is the work around for moving BLOB/Container data to SQL server,

Shadow Tables do not show/support BLOB fields at all.

I don't have Advanced server for ODBC.

Need possiblities other ideas.

Need to do it over the net.

Am I stuck?

Note:

DTS not an option.

Thanks

Edited January 31, 2008 by Guest

[Garry Claridge]

Have you tried it with the "ExecuteSQL" step in Scriptmaker?

This way you do not need a "Shadow Table".

I have not tried this, it is only a guess.

Good Luck.

Garry