Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

DTS wizard freezes

Status
Not open for further replies.
Jan 23, 2003
10
US
SQL2000 XP client

The process I use works except for one DTS package. I am pumping the results of several views into flat files. For on view (70 columns defined) the wizard refuses to create the destination columns and I can not map the transformations, When I click on the define column button the hourglass appears and I am forced to end the process with task manager, I had let it run as long as 1+ hour. What is going on here? All columns are quotable except the two timestamp columns.

IS there a way to manually define columns for transformations?
 

It appears that there is a limit of 30 transformations, is this true?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top