hii i have a problem reading a CSV file I have used bothe delimited data reader as well as universal data reader but i cant preview or crate a metadata on the file. the same file opened perfectly on another ETL tool(SQL Server Integration Services)what cud be the problem?how can i solve it
email,uniqueid,datercvd,remoteip,language,submissionkey,“First Name”,“Last Name”,“Email Address”,“What level are you?”,“Which group are you in?”,“If you are in the Marketing group, which department? (Please select NA if you are in the Online group)”,“If you are in the Online group, which department? (Please select NA if you are in the Marketing group)”,“Directions: Please rate the following questions using the following scale: Always, Usually, Sometimes, Rarely or Never to describe how frequently the activity in the question occurs. If you don’t have an opinion, or the activity is unfamiliar to you, check “Not Applicable” or “NA.”&CR; Metrics have agreed definitions and are consistently applied across the organization and across communication programs”,“Employees have the tools, information, and processes they need to succeed in their jobs”,"Key marketing processes are documented, understood and consistently followed ",“We have a strategy for organization knowledge and asset management”,“Robust and reliable business cases are created for marketing initiatives”,"Accountability and ownership for individual marketing processes is clear ",“Technology or services are incorporated to increase sales or become more cost effective”,“Marketing and Technology groups have an effective partnership”,“Technology is viewed as an enabler for marketing strategies”,“The necessary skill sets exist to support reporting and analytics activity”,“Reporting is relevant and delivered in a timely fashion”,“Training is considered an essential part of the culture”,“Employees understand their roles and feel a shared sense of purpose “,“Employees are recognized for their contributions”,“Morale is high”,“It’s acceptable for people to ask for help if they have too much work”,” &CR;Directions: Please rate the following questions using the following scale: Always, Usually, Sometimes, Rarely or Never to describe how frequently the activity in the question occurs. If you don’t have an opinion, or the activity is unfamiliar to you, check “Not Applicable” or “NA.”&CR;&CR; &CR;Marketing delivers value to its partners”,“Online delivers value to its partners”,“Marketing planning involves all employees who will have a stake in the success of the marketing plan”,“Marketing programs are aligned with a coherent customer strategy”,“A comprehensive annual marketing plan is developed across all channels”,“Marketing is a thought leader on customer strategy”,“Online is a thought leader on customer strategy”,"Marketing is a thought leader in product strategy and planning ",“Online is a thought leader in product strategy and planning “,“Marketing is a customer centric organization”,“Online is a customer centric organization”,“Overall REI Marketing strategy is clear”,“I have confidence that Marketing is building the necessary capabilities to support partner needs”,“I have confidence that Online is building the necessary capabilities to support partner needs”,“Marketing and Online’s measurements accurately reflect their contribution to business performance”,“Marketing and Online draw definitive conclusions from every test it executes and acts on them.”,“Marketing and Online have the tools to make the right investment decisions”,“There is a consistent framework to measure the success of marketing campaigns”,“Marketing is good at capacity planning and resource estimation”,“Online is good at capacity planning and resource estimation”,” &CR;Directions: Please rate the following questions using the following scale: Always, Usually, Sometimes, Rarely or Never to describe how frequently the activity in the question occurs. If you don’t have an opinion, or the activity is unfamiliar to you, check “Not Applicable” or “NA.”&CR;&CR;Marketing and Online personnel are deployed where the need is greatest”,“If something is not working, Marketing stops doing it”,“If something is not working, Online stops doing it”,“Planning, execution and analytics processes are fully integrated”,“There is open communication with Marketing and its partners”,“There is open communication with Online and its partners”,“Marketing is disciplined in the way it manages its work”,“Online is disciplined in the way it manages its work”,"Increased productivity is evident through decreased cycle times executing marketing campaigns ",“Existing processes focus mainly on decreasing time to market and minimization of cost”,“The current marketing process minimizes duplication of effort”,“Resource and financial constraints are factored into the campaign planning process”,“Marketing and Online maintains a focus on the most important priorities”,“Marketing and Online effectively lead cross-channel media integration”,“Centralized and easy access to marketing reporting exists, highlighting prioritized metrics”,"Marketing roles and responsibilities are well defined and broadly understood ","Online roles and responsibilities are well defined and broadly understood ","Decision-making authority processes are well defined and broadly understood ",“Marketing has sufficient resources to meet its commitments”,“Online has sufficient resources to meet its commitments”,“Share your thoughts on some of the factors that you think drive improvements or change in our marketing activities. Please list the top 5. For example, a factor might be the emergence of a new competitor’s marketing strategy or increased focus on testing marketing activities. Factor # A-1”,“Factor # A-2”,“Factor # A-3”,“Factor # A-4”,“Factor # A-5”,“Share your thoughts on some of the factors that you think prevent or constrain change in our marketing activities. Please list the top 5. For example, one factor might be limited customer information, or inadequate technology support.&CR;Factor # B-1”,“Factor # B-2”,“Factor # B-3”,“Factor # B-4”,“Factor # B-5”,“Please feel free to provide any other comments. For example, strengths / weaknesses, future opportunities or needed capabilities.”
,20061113120949,68.223.165.191,eng,3,Scott,Kaufman,sco,Management,Marketing,“Marketing Creative Services”,“Business Analysis”,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Usually,
,20061113121901,68.223.165.191,eng,4,Scott,Scott,Sco,Management,Online,NA,“Business Analysis”,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,Never,
,20061113122442,68.223.165.191,eng,6,scott,scot,sco,Management,“Gear and Apparel”,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,Always,
,20061113122554,68.223.165.191,eng,7,
,20061113135815,72.144.66.60,eng,8,Scott,Scott,Sco,Management,Merchandising,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,“Scott good”,“Scott good”,“Scott good”,“Scott good”,“Scott good”,“Scott bad”,“Scott bad”,“Scott bad”,“Scott bad”,“Scott bad”,“scott extra”
,20061113142343,71.116.121.29,eng,12,Jenny,Belser,belserj@quaero.com,“Individual Contributor”,Marketing,“Marketing Planning & Research”,NA,Rarely,Sometimes,Sometimes,Rarely,Usually,Usually,Usually,Sometimes,Usually,Rarely,Sometimes,Sometimes,Sometimes,Usually,Sometimes,Rarely,Sometimes,Sometimes,Rarely,Rarely,Usually,Always,Sometimes,Sometimes,Usually,Rarely,Sometimes,Always,Rarely,Sometimes,Usually,Rarely,Sometimes,Rarely,Usually,Usually,Sometimes,Sometimes,Rarely,Usually,Sometimes,Always,Never,Sometimes,Never,Sometimes,Sometimes,Usually,Rarely,Usually,Never,Sometimes,Rarely,Rarely,Usually,Sometimes,
,20061113143100,10.6.0.250,eng,13,test,test2,test@quaero.com,“Individual Contributor”,“Human Resources”,Usually,Usually,Usually,Usually,Rarely,Rarely,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Usually,Sometimes,Sometimes,Usually,Usually,Rarely,Rarely,Sometimes,Always,Usually,Usually,Sometimes,Usually,Usually,Sometimes,Sometimes,Sometimes,Sometimes,Usually,Usually,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Rarely,Rarely,
,20061113143648,10.6.0.250,eng,14,fdf,fdfs,fdsfs,“Individual Contributor”,Finance,Sometimes,Sometimes,Usually,Sometimes,Always,Usually,Sometimes,Usually,Sometimes,Sometimes,Sometimes,Sometimes,Usually,Usually,Sometimes,Usually,Usually,Rarely,Rarely,Sometimes,Always,Usually,Usually,Sometimes,Usually,Always,Usually,Sometimes,Usually,Usually,Sometimes,Sometimes,Sometimes,Sometimes,Usually,Usually,Sometimes,Sometimes,Rarely,Rarely,
,20061113152012,10.6.0.250,eng,21,fdf,fdsfs,fsdfsd,Management,Finance,Usually,Usually,Sometimes,Sometimes,Sometimes,Usually,Usually,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Usually,Usually,Sometimes,Rarely,Rarely,Rarely,Always,Usually,Usually,Usually,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Rarely,Sometimes,Sometimes,Sometimes,Sometimes,Usually,Usually,Usually,
,20061113155016,10.6.0.250,eng,26,fsf,fdsf,fdsaf,Management,Online,“Marketing Creative Services”,“Online Site Production (Copy/PI, Design and Production)”,Usually,Usually,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Usually,Usually,Sometimes,Rarely,Rarely,Rarely,Sometimes,Sometimes,Rarely,Always,Usually,Usually,Always,Usually,Usually,Sometimes,Sometimes,Sometimes,Usually,Sometimes,Sometimes,Usually,Sometimes,Sometimes,Usually,Usually,Sometimes,Usually,Sometimes,Usually,Usually,Sometimes,Sometimes,Sometimes,Usually,Usually,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Usually,Usually,Sometimes,Sometimes,Rarely,Sometimes,Sometimes,
,20061113155153,10.6.0.250,eng,27,fdsf,fdsaf,fsdaf,Management,Online,“Marketing & Modeling”,“Online Site Production (Copy/PI, Design and Production)”,Usually,Usually,Sometimes,Usually,Sometimes,Sometimes,Sometimes,Sometimes,Usually,Usually,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Always,Usually,Usually,Usually,Usually,Usually,Sometimes,Sometimes,Sometimes,Sometimes,Usually,Usually,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Always,Always,Always,Always,Always,Usually,Usually,Usually,Usually,Usually,Usually,Usually,Usually,Sometimes,Rarely,Rarely,Rarely,Sometimes,Sometimes,Sometimes,
,20061113160124,10.6.0.250,eng,28,fdsaf,fdsaf,fdsaf,“Individual Contributor”,Online,“Marketing Creative Services”,“Business Analysis”,Usually,Usually,Usually,Usually,Sometimes,Sometimes,Sometimes,Usually,Usually,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,Sometimes,
,20061113170616,70.156.217.123,eng,30,aa,aask,aa,Management,“Retail Ops”,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,NA,