August 16, 2006 at 6:19 pm
Guys,
I'm trying to DTS a table (50 columns and 5 of them have a bit datatype) to a text file. Instead of transfering the entire table I use a query to convert a bit datatype to an integer (otherwise designer gives an error - environment is SQL Server 2000 SP3). When I list all 50 columns a designer ignores them,
listing fewer colums (10 including 2 converted bit columns ) is no problem. BTW the entire query is parsed correctly, I even put the query on a single command line (trying to trick the situation), but a designer ignores it and doesn't allow to transform data. Clicking on define columns gives a memory problem (???). Any ideas ? Thank you, Mike.
August 21, 2006 at 8:00 am
This was removed by the editor as SPAM
August 23, 2006 at 3:18 am
Without knowing exactly what sort of problems you were having which prompted you to do the conversion at SQL level, I would suggest that you return to tackling this initial problem - perhaps using an ActiveX Transformation for the bit columns.
Failing that, it would be helpful if you could provide more detail - something we could reproduce.
Regards,
David McKinney.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply