Category: SQL Server Integration Services (SSIS)

Temp Tables in SSIS

I’ve been strugglig quite a bit this last week to get my temp tables up and running in SSIS.But after alot of struggling i finally managed to get it going.But it took alot of seaching around. Well in this video i explain the settings that need to change in SSIS to make it work. I found these 2 links very […]

Scrambled Column values in destination csv file

You have a simple database table (UserNames) as below You want to get this table and it’s contents into a csv file. You create a simple dataflow package (OLEDB = Source &  CSV Flat File = Destination) You run the data flow task and feel happy that everything was soooo easy. You take a little peek inside the created CSV […]