InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 19 Jun 2013 07:35:43 GMT20http://www.sqlservercentral.com/Forums/Topic1075700-364-1.aspxDon't worry, I'm not easily offended :-)It does indeed make sense to incorporate it in SSIS if it is part of a bigger solution.Thu, 10 Mar 2011 12:33:51 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1075700-364-1.aspx[quote][b]Koen Verbeeck (3/10/2011)[/b][hr][quote][b]BobMcC (3/10/2011)[/b][hr]I suppose it would be an option, but why would I want to?[/quote]Well, I don't really see a difference between running a SQL Server Agent job or running an SSIS package. :-)Both are a means to an end.Anyway, glad you found a solution.[/quote]Koen, On reflection my question about why I would want to, may have sounded snotty and I hope you know I didn't mean it that way. I was genuinely asking why I might want to use an Agent job, in case I was missing something. To explain why I wanted it into an SSIS task is because it's but one task of several related tasks in an SSIS solution I'm building, but I didn't add that as I didn't feel like it was part of the problem. Thanks for the reply.Thu, 10 Mar 2011 12:28:57 GMTBobMcChttp://www.sqlservercentral.com/Forums/Topic1075700-364-1.aspx[quote][b]BobMcC (3/10/2011)[/b][hr]I suppose it would be an option, but why would I want to?[/quote]Well, I don't really see a difference between running a SQL Server Agent job or running an SSIS package. :-)Both are a means to an end.Anyway, glad you found a solution.Thu, 10 Mar 2011 12:06:01 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1075700-364-1.aspxI suppose it would be an option, but why would I want to? I just want to run a single command line utility, not much different than using the Execute Process Task to run a command line option to unzip a compressed file.I recently found out solution: in the Arguments box i put: "(get-content 'C:\YetAnotherFolder\MyFile.txt')| foreach-object{$_+',,,,,,,,,'}|set-content 'C:\YetAnotherFolder\MyFile.txt'"and it looks like it works perfectly.Thu, 10 Mar 2011 11:53:27 GMTBobMcChttp://www.sqlservercentral.com/Forums/Topic1075700-364-1.aspxYou can run Powershell commands from SQL Server Agent. Is that an option?Wed, 09 Mar 2011 12:41:36 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1075700-364-1.aspxI occasionally run a Powershell command that add characters at the end of each line in a text file. From a Powershell prompt I run the following command: (get-content "C:\Some Folder\someFile.txt")| foreach-object{$_+"xxxxx"}|set-content "C:\Some Folder\someFile.txt"I tried to set that up to run from an Execute Process Task, but I'm not doing something right.I put the the powershell command in the Executable section and the remainder of the the command in the Arguments section, but I don't have it delimited or quoted correctly (I think).If I execute the above from a DOS command prompt i.e. c:\>PowerShell (get-content "C:\Some Folder\someFile.txt")| foreach-object{$_+"xxxxx"}|set-content "C:\Some Folder\someFile.txt"I receive the following error: 'foreach-object{$_+"xxxxx"}' is not recognized as an internal or external command, operable program or batch file.Suggestions?Wed, 09 Mar 2011 10:21:17 GMTBobMcC