Hi All,
I have created an SSIS Package that runs a Stored Procedure then exports the data to a .csv file. When I Debug the SSIS Package it runs fine. I have set up a job in SQL 2008 to run the package because I would like this done on a daily basis. The job runs and the package delivers the csv file to the location, but the problem is it adds things to the data that shouldn't be there. Sorry about the formatting, but you get the gist. I have no idea where _x003C_none_x003E_ is coming from. Has anyone encountered this before? What am I doing wrong? In my job step I have the type as SQL Server Integration Services Package and Run As: SQL Server Agent Service Account. Should I change that to Transact SQL? Thanks for your help
Tino
Example:
person_nbr pat_name date_requested date_processed
311815 Test, Baby 20120516
238970 Test, Bonnie 20120608
238970 Test, Bonnie 20120619
238970 Test, Bonnie 20120620
238970 Test, Bonnie 20120620
311815 Test, Baby 20121003
238970 Test, Bonnie 20130329
238970 Test, Bonnie 20130415
238970 Test, Bonnie 20130501
_x003C_none_x003E_person_nbr_x003C_none_x003E_ _x003C_none_x003E_pat_name_x003C_none_x003E_ _x003C_none_x003E_date_requested_x003C_none_x003E_ _x003C_none_x003E_date_processed_x003C_none_x003E_
_x003C_none_x003E_ 311815_x003C_none_x003E_ _x003C_none_x003E_Test, Baby_x003C_none_x003E_ _x003C_none_x003E_20120516_x003C_none_x003E_ _x003C_none_x003E__x003C_none_x003E_
_x003C_none_x003E_ 238970_x003C_none_x003E_ _x003C_none_x003E_Test, Bonnie_x003C_none_x003E_ _x003C_none_x003E_20120608_x003C_none_x003E_ _x003C_none_x003E__x003C_none_x003E_
_x003C_none_x003E_ 238970_x003C_none_x003E_ _x003C_none_x003E_Test, Bonnie_x003C_none_x003E_ _x003C_none_x003E_20120619_x003C_none_x003E_ _x003C_none_x003E__x003C_none_x003E_
_x003C_none_x003E_ 238970_x003C_none_x003E_ _x003C_none_x003E_Test, Bonnie_x003C_none_x003E_ _x003C_none_x003E_20120620_x003C_none_x003E_ _x003C_none_x003E__x003C_none_x003E_
_x003C_none_x003E_ 238970_x003C_none_x003E_ _x003C_none_x003E_Test, Bonnie_x003C_none_x003E_ _x003C_none_x003E_20120620_x003C_none_x003E_ _x003C_none_x003E__x003C_none_x003E_
_x003C_none_x003E_ 311815_x003C_none_x003E_ _x003C_none_x003E_Test, Baby_x003C_none_x003E_ _x003C_none_x003E_20121003_x003C_none_x003E_ _x003C_none_x003E__x003C_none_x003E_
_x003C_none_x003E_ 238970_x003C_none_x003E_ _x003C_none_x003E_Test, Bonnie_x003C_none_x003E_ _x003C_none_x003E_20130329_x003C_none_x003E_ _x003C_none_x003E__x003C_none_x003E_
_x003C_none_x003E_ 238970_x003C_none_x003E_ _x003C_none_x003E_Test, Bonnie_x003C_none_x003E_ _x003C_none_x003E_20130415_x003C_none_x003E_ _x003C_none_x003E__x003C_none_x003E_
_x003C_none_x003E_ 238970_x003C_none_x003E_ _x003C_none_x003E_Test, Bonnie_x003C_none_x003E_ _x003C_none_x003E_20130501_x003C_none_x003E_ _x003C_none_x003E__x003C_none_x003E_