Ok. first let me ask. How can we write condition in conditional split where State in (us ,asia)?

TABLE ATABLEB

STATUS STATUS

ABCD ABCD If the value are same No insert

BCDG ...

Yes..i am deploying from Visual studio 2013. I chnaged property from " encrpyt sensitive data with USer key " to "Dont save sensitive data"....and deployed , i thought that fixed...

This is development enviornment and since data is not current need to enforce the data for my testing. Anyways i inserted data without enabling or disabling , just by adding...

I think to be more specific, i am deploying the solution from visual studio. the other solution has no issues. only the solution which I am working has this.

Why do...

You can write stored procedure and execute it in executesql task and pass value to result set (variables).

or In dataflow task , " query from variable" can be used.

Thanks everyone for taking time and replying , this export to excel is not direct , i have check other tables and do lot of stuff to get this point...

the column is missing in "preview" of the report in ssrs .

the columns are overlapped in excel. so is there a way taht it is not overlapped while exporting to excel through ssis?

the one with date and int. I am using dataconversion task and chanhing everything to dt_wstr ...

overlapped columns. is there a way they do not overlap?

Source

[ItemID] [bigint] NULL

[State] [nvarchar](255)

[Trade Date] [date] NULL,

[invoice_id] [bigint] NULL,

FirstnameLast NameItemIDE-mail AddressAddress 2CityStateZipinvoice_idTrade DateKit Type Required

komal jawal3200011564abcd@gmail.com1234 berookdtAPT 123friscdc7534522343554444442016-09-29TGSAPmT01

[Derived Column [24]] Error: An error occurred while attempting to perform data conversion. The source type could not be converted to the destination type.

I keep getting this error again and...

how can i do that?

Yes..there is data of date type , numeric too

i want everything to string , so it just prints the columns to excel. I am using data conversion task , DT_str? or DT_WSTR?

little confused which to use.