SQL Server Performance

Modify SSIS Package with VB Script in it

Discussion in 'SQL Server 2005 Integration Services' started by rupeshpatel, Sep 8, 2008.

  1. rupeshpatel New Member

    Hi,I started working on SSIS Package recently, I copied one working SSIS package, and modified VB.Net Script behind it. One SQL Server Job is calling this SSIS Package. Now, My trouble is, Even after modifying and saving VB.Net Script behind SSIS Package, When I run SQL Job, I don't see any change in the output. Am I missing anything else? Like Deployment or anything. There is an option in VBScript in the Debug menu Bar, says BUILD. Do i have to build this VB Script code?Please guide.Thanks in advance.Rupesh
  2. MohammedU New Member

    Make sure you deployed the package to sql server if it is stored in msdb...
  3. rupeshpatel New Member

    Thanks MohammedU,In fact, My logic was not behaving in intended behavior. I changed it and worked as requested. Thanks for your response

Share This Page