SSIS is still not clicking in my head. Example...
I want to transfer data (select columns) from SQL1 to SQL2...
SQL1.Tbla -----> SQL2.Tabla
SQL1.Tblb -----> SQL2.Tablb
SQL1.Tblc -----> SQL2.Tablc
In the Data Flow designer, is the above 1 task or 3 tasks? In the old DTS
designer, I'd link them all together with "On Success" lines and run them
all in sequence. But in SSIS, I don't see where I can link them to run in
succession. All I see is a source and destination. Nothing to keep the work
path flowing.
thanks
[quoted text, click to view] "Gouti" <Gouti@discussions.microsoft.com> wrote in message
news:49B66A79-B007-4BA0-A48D-E1C8A9C4382C@microsoft.com...
> Check the dataflow task. You can use many data flow tasks within one SSIS
> package.
> All the data grooming tasks can be a part of workflow within a same
> package.
> As typical with microsoft, there are many ways to do the same task, i have
> used dts but never used wizards, so iam not sure how it created when using
> wizards.
>
>
> "shank" wrote:
>
>> I have access to a shared SQL 2005 server. So far, I cannot save my first
>> SSIS package due to an execute permisison error. I'm assuming it's a
>> rights
>> issue and will get resolved.
>>
>> In the interim, I'm trying to get up to speed with the differences
>> between
>> DTS and SSIS. In DTS, I used the wizards and created a bunch of tasks.
>> And
>> all those tasks were linked and part of one DTS package that I could
>> execute.
>>
>> However, using MS SQL Server Management Studio, I created one task of
>> transferring 5 tables from one server to the new server. And that task
>> appears to be one SSIS package. Now I need to do a lot of data grooming
>> tasks. Are each of those tasks also going to be an SSIS Package?
>>
>> In the end, it looks like I will have a bunch of SSIS packages. Do I
>> create
>> one last SSIS package to run all these smaller packages? Or do I have to
>> run
>> each package individualy?
>>
>> thanks
>>
>>
>>
