Hi ,

I have created the second part of the package and its working fine

I want to know how can i load the file information one by one and go to...

I have conditional split

one output is new which will insert into target table directly using OEDB Destination

another output is Updated which will update the existing record, I am using oledb...

What is CLR ?

Clients having 100 of ssis package for every table they are having separate ssis package.

Now they wanted to have single package with single DFT which can load all the...

Yes you are correct.

Because initially It was implemented by SSIS on production.

now I have to do using SQL , in development we are getting the data like HjGrRZvXy/kMQE+NKwfXNA==.

if i used another method i...

in my source all the columns are varchar.

I want to convert into ToBase64String value to get output like HjGrRZvXy/kMQE+NKwfXNA== ,

470xf2ZinGTq0PoQtPGiWQ==

regards,

Vipin jha

In this case I will not get output like fghxvsUd3nuO6Zvmhv1t/w==

Suppose I have 3 column in department table like

Select Deptid,Dept_name,location from department.

in same query I want to derive checlksum ToBase64String value .

My output shild be look like...

Ok sir

then whats the alternate of this .

becaue I have to chive in sql ,

regards,

Vipin jha

Hi Thanks for your update.

Is there any way where I can have the history with version 0 and new with version 1

Regards,

Vipin jha

Hi ,

I want to have chcecksum value of all the column in my table. In ssis pacakge I used script component MD5 , but now I have converted ssis to...

Thanks sir ,

its working now

Hi I have created a BIML SCript using script component.

if you want i can share with you.

regards,

Vipin jha

Hi all, I am trying to automate a data flow with BIML. I am using an expression to build my SQL dynamically based on input parameter. Sparing details of the...