csv load exact format using ssis

• asrinu13

  Say Hey Kid

  Points: 709

  More actions

  July 18, 2020 at 4:37 pm

  #3771082

  i have one doube in ssis how to load double codes data from sql server to csv filesusing ssis pacakge . source : emp table

  CREATE TABLE [dbo].[empcsvfile](

  [eid] [varchar](50) NULL,

  [empstring] [varchar](8000) NULL,

  [details] [varchar](500) NULL

  )

  GO

  INSERT [dbo].[empcsvfile] ([eid], [empstring], [details]) VALUES (N'1', N'''1'',''yt'',''1te'',''1d''', N'{"test":"ed","eDate":"1990-01-16","isflag":null,"Type":"te","Number":null,"std":null,"mark":null,"Code":"22","cty":"r","state":"tn","country":"IN","isPermanent":null,"Lines":{"Street2":"street2","Street1":"street2","Taluka":"street2","District":"street2"},"Proof":null},{"Type":"PHONE","Date":"2017-05-28","Verified":null,"Type":"BSNSS","Code":null,"Code":null,"Number":"954457565","ette')

  destination : Test.csv file eid |empstring |details

  I tried like below but in csv files its create extra columns emp table have 3 coumns when i tried to load data into csv that fileds its create more than 3 fileds.

  

  can you please me how to load empcsvfiles(sql server ) 3 fileds data load into destination csv exact 3 fields in csv

  GO

   

• Site Owners

  SSC Guru

  Points: 80342

  More actions

  July 19, 2020 at 5:10 pm

  #3771157

  Thanks for posting your issue and hopefully someone will answer soon.

  This is an automated bump to increase visibility of your question.