Post reply

New to DTS - Cant find a step???

  • June 11, 2004 at 1:07 pm

    #60166

    I created a job by right clicking on a database and selecting "import data".  I went through all the steps, including modified the create table command to add constraints, some renames, etc.  Then I scheduled the package and copied the operating system command out of the scheduled job and added it as a step to another job that houses many such steps.  This is only way I know to do this.

    Today, I needed to add a column to the import so I went to my package under DTS.  The package shows two connection objects and one create table object.  However, the import/copy data step does not show up anywhere.  Yet, if I execute the job, it copies the data.

    Can anyone tell me how to get into the data copy/transfer task?  I had to restart from scratch because I could add the column to my created table (step in the DTS job)....but I couldn't tell the existing job to add the column to the select statement I use to get the data.

    Thanks in advance.

    Ryan Hunt

  • June 14, 2004 at 8:00 am

    This was removed by the editor as SPAM

  • June 15, 2004 at 12:36 pm

    #510524

    Was there an arrow connecting the two connection objects?  If so, double-click on the arrow.  That's the Transform Data task.

    This is another guess.  Could your package have more than one version and you edited the wrong version?  To see, right-click on the package and select versions...

     

    Greg

    Greg

  • June 15, 2004 at 12:46 pm

    #510528

    Greg, thanks so much.  That was it.  I didn't know that the arrows connecting the objects were objects as well.

    Thanks

    Ryan

  • June 16, 2004 at 8:46 am

    #510660

    Hey, glad I could help!

    Greg

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply