Executing TextPipe Bat file from SSIS

[chetankumarh]

Hi ,

We are trying to Automate the Textpipe conversion process by embedding the .bat file in SQL Server Intergration Services (SSIS) package. When we execute the .bat file from SSIS integrated Development Environment manualy, it works fine.

However when we schedule the SSIS package from SQL 2005 Agent , Text pipe exe will never get invoked.

can you please let us know the steps to schedule Textpipe using SQL Server Agent.

Also can we execute the textpipe in background ( without invoking GUI )?

Thanks,
chetan

[DataMystic Support]

Did you read the help file under Advanced/Command line options?

You need
/minimized

The Agent can't run TP as TP expects console interaction. For that you need to use TP Run Time or the TextPipe Engine.

[chetankumarh]

Hi,

Isn't TP run time or TP Engine part of the software package that we buy.

If no, What is the additional cost to buy this software.

The version that we are currently using is TextPipe Pro 8.4 Server Edition.

Thanks,
chetan

[DataMystic Support]

Please see http://www.datamystic.com/buy/textpipe.html for current prices.

Try using /minimized first - this may work for you.