Accessing Result Set(ADO) through Script task

• vijay.msbi

  SSC-Addicted

  Points: 422

  More actions

  February 18, 2010 at 5:09 am

  #230070

  Hi,

  By using Execute SQL task, Result set stored in ADO.NET 2.0 Data Set object. used ADO.NET connection for the Execute SQL task instead of an OLE-DB connection with the Execute SQL task because with an OLE-DB connection the results will *not* be available in a downstream script task.

  My Requirement: I need to move files from C:\Newfolder to D:\Newfolder.

  C:ewfolder contains file names A,B,C,D.

  Have a reference table in data base with col1 ( rows represent file names in C:\Newfolder), Col2 (rows represent file names in D:\Newfolder).

  Col1 Col2

  A W

  B X

  C Y

  D Z

  When we move files from C:\Newfolder to D:\Newfolder . Target Folder(D:\Newfolder) should contain file names W,X,Y,Z respectively.

  Above reference table available in result set.( variable : "@MyADOResultset")

  Can any one please provide simple VB.net code in Script task to accomplish above task.

  I do't have even basic VB.Net scripting knowledge.

  Thanks in Advance.

  Cheers

  Vijay

• February 19, 2010 at 3:21 am

  This was removed by the editor as SPAM

• vijay.msbi

  SSC-Addicted

  Points: 422

  More actions

  February 20, 2010 at 3:11 am

  #1122290

  Thanks Stewart.

  I implemented through Package as you told. Thanks for your Reply.

  VIjay