"Chris" wrote:

>
> Depending on what you SQL is doing you can add it before your Prepare SQL
> Task, drag an Execute SQL task onto your Control Flow tab, then connect it to
> the Prepare SQL Task. Or if the Prepare must run first, you can delete the
> connection (green arrow) between the Prepare and Dataflow task, add the Exec,
> connect Prepare to Exec, then Exec to DAtaflow. Or... after do as final step
> - connect Dataflow task to Exec SQL...
>
> Now that's just on the Control Flow tab, if you wanted to add inside
> Dataflow you will need to use the OLE DB Command transformation...
>
> AS far as the BIDS designer question, you cannot manipulate data, you will
> need to use SQL Mgt Studio. YOu can however view data as it is moving thru
> your dataflow, right-click on any green arrow between transformations select
> Data Viewers..., then Add | Grid -
>
> Hope this helps...
>
> REgards,
> Chris MCDBA MCSE OCP
> www.MSSQLConsulting.com
>
> "Coop" wrote:
>
> > Hi. I created a SSIS package using the Copy Database Wizard. The package
> > copies four tables from a SQL 2000 server to a 2005 database on another box.
> > (BTW, I installed the Business Intel Dev Studio on my local workstation.) So
> > on the Data Flow tab in the package, there are four OLE DB sources and four
> > OLE DB destination objects. And on the Control Flow tab, there is a
> > "Preparation SQL Task" object with a connector to a "Data Flow Task" object.
> > My question is where to add more SQL to do some processing on the four tables
> > that the package copies? Do i add it to the SQL Statement inside the
> > "Preparation SQL Task", or do I add a new "Execute SQL Task" object. If the
> > later, then what object to i connect it to?
> >
> > A separate question is, when designing a package in the Business Intel Dev
> > Studio, is there a workspace similar to SQL Query Analyzer where I can edit
> > SQL?
> >