Executing TextPipe Bat file from SSIS

Get help with installation and running here.

Moderators: DataMystic Support, Moderators

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

Executing TextPipe Bat file from SSIS

Post by 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: 2211
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Executing TextPipe Bat file from SSIS

Post by 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

Post by 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: 2211
Joined: Mon Jun 30, 2003 12:32 pm
Location: Melbourne, Australia
Contact:

Re: Executing TextPipe Bat file from SSIS

Post by 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

Post Reply

Who is online

Users browsing this forum: No registered users and 7 guests