September 30, 2008 at 3:40 pm
Did you try a case statement?
Ben Sullins
bensullins.com
Beer is my primary key...
October 1, 2008 at 2:27 am
yip i've tried a case statement, it did feel a little silly because I was trying to set something to 0 or 1 when it was already that. SSIS knows that it is a bit and a bit is boolean so it trys to be clever and name it appropriately, I just want SSIS to do what its told! Does anyone have any other suggestions? 🙂
October 1, 2008 at 2:39 am
How about creating a temp table to store the info that you want to export to the .csv file? In the temp table you make the column type of the boolean field integer. After you have inserted all the values into the temp table export the temp table to .csv.
Hope it helps.
October 1, 2008 at 3:05 am
I could do, but I would prefer not to have to create yet another table. SSIS is supposed to be this flashy ETL tool, surely it must be able to handle it
Viewing 4 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply