how to write a connection for file type for a package RSS

• • Reply
  

  jagadeesh_sa...

  Member

  18 Points

  121 Posts

  how to write a connection for file type for a package

  Aug 07, 2012 01:33 PM|LINK

  hi i want to execute an ssis package file DTSX which is on remote machine using DTS dll by following code

  ConnectionManager adventureWorks = package.Connections.Add("FILETYPE");

  adventureWorks.Name ="FILETYPE";

  adventureWorks.ConnectionString

  but iam unable to establish connection .how to write the connection to that

  • Moved by Curt_C on Aug 07, 2012 06:18 PM
• • Reply
  

  bcanonica

  Contributor

  3082 Points

  595 Posts

  Re: how to write a connection for file type for a package

  Aug 07, 2012 07:11 PM|LINK

  Here is a good example of how to execute this in C#

  http://www.codeproject.com/Articles/14229/Execute-SQL-Server-2005-Integration-Services-packa

  Please remember to mark the replies as answers if they help. This can be beneficial to other community members reading the thread.
  
  Thanks,
  
  BC
  
  Blog Void Impossible