Executing TextPipe Bat file from SSIS

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

chetankumarh
Posts: 3
Joined: Fri Feb 06, 2009 3:10 am

Executing TextPipe Bat file from SSIS

Postby chetankumarh » Fri Feb 06, 2009 3:19 am

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

User avatar
DataMystic Support
Site Admin
Posts: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Executing TextPipe Bat file from SSIS

Postby DataMystic Support » Fri Feb 06, 2009 2:19 pm

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.
Regards,

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments

chetankumarh
Posts: 3
Joined: Fri Feb 06, 2009 3:10 am

Re: Executing TextPipe Bat file from SSIS

Postby chetankumarh » Tue Oct 27, 2009 3:39 am

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

User avatar
DataMystic Support
Site Admin
Posts: 2138
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Executing TextPipe Bat file from SSIS

Postby DataMystic Support » Tue Oct 27, 2009 8:55 pm

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

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

Simon Carter, http://DataMystic.com/forums/index.php
http://PredictBGL.com - Insulin dose calculator for Type 1 diabetes
http://DownloadPipe.com - 250,000 free software downloads
http://DetachPipe.com - send huge email attachments


Return to “TextPipe Tips and Tricks, Questions and Support”

Who is online

Users browsing this forum: DataMystic Support and 1 guest