multiple transformations in 1 dts

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

From: kdabda (anonymous_at_discussions.microsoft.com)
Date: 04/13/04 

Date: Tue, 13 Apr 2004 09:36:05 -0700

What about having like 20 transformations in 1 dts?

Should I check for each file up front and if not there then disable the individual transformation?

Any ideas how to check for multiple files and then turn on or off multiple transformations in one dts? I don't mind using the exact names of the files in check and or transformation.

thanks!

Relevant Pages

  • Re: Help importing from text file via DTS
    ... right click on the package whitespace | Package Properties | Global ... www.SQLDTS.com - The site for all your DTS needs. ... >> when you look at the transformations unmap the column that goes from the ... >> Allan Mitchell MCSE,MCDBA, (Microsoft SQL Server MVP) ...
    (microsoft.public.sqlserver.dts)
  • Re: Help importing from text file via DTS
    ... > when you look at the transformations unmap the column that goes from the ... > Allan Mitchell MCSE,MCDBA, ... > www.SQLDTS.com - The site for all your DTS needs. ... >> DTS package I have a text file object and OLEDB connection object ...
    (microsoft.public.sqlserver.dts)
  • Re: Help importing from text file via DTS
    ... I did and its is executing fine when run from dts, ... Now when I try to execute the package from query analyzer I get the ... > when you look at the transformations unmap the column that goes from the ...
    (microsoft.public.sqlserver.dts)
  • Re: Help importing from text file via DTS
    ... In your transformations again highlight the destination column NO source ... www.SQLDTS.com - The site for all your DTS needs. ... > DTS package I have a text file object and OLEDB connection object ...
    (microsoft.public.sqlserver.dts)
  • Parameters in DTS
    ... I want to run a custom stored procedure and ... They are connected by a Transform Data Task. ... The Transformations for my Transform Data Task are simple ... but now I want to use DTS ...
    (microsoft.public.sqlserver.dts)