You can use below table script and can insert any test value for test
cREATE TABLE TAB1
(

URN    bigint,
eno    varchar(MAX),
Schoolname    varchar(MAX),
phase    varchar(MAX),
)

cREATE TABLE TAB2
(

Please suggest the way by which I can get the solution

Sorry for that

Hope you understand the issue.

I want to pass the filtr value in conditional split by variable so that in future if I want to add...

By changing the scale value of column data coming correctly

Thanks

It is having Numeric data type

Ok,

Can I get the error line number in my error output file.

Regards,

Vipin

Yes sir

Hi Used below query to get the desired output.

;with cte AS (SELECT [ProgramId]

,[ProgramVersionId]

,[WRINPrefix]

...

I created 1 variabel with string data type.

and on expression I tried to convert zonevalue variable to string using (WST_D18) but not getting

Actually I want to pass the connection string from outside.

I have same package which will run for multiple location

i have 2 parameter 1 for constring and another for password

How to...

Hi ,

Yes it exist and I am able to connect using SSMS.

I have below permission on SSISDB Catalog folder

1.Read

2.Modify

3.Manage Permissions

4.Create Objects

5.Modify Objects

6.Execute Objects

7.Read Objects

8.Manage Object Permissions

But also I am not...

It is working properly when removing Transaction setting from container.

Hi When I am trying to execute below command I am getting error

BULK INSERT ##MD_GEOGRAPHYLEVELTYPE

FROM 'H:\Spectrum_V2_ETL\Loading_Geography_Table_Data\Loading_Geography_Table_Data\MD_GEOGRAPHYLEVELTYPE_US.txt'

WITH ( FIELDTERMINATOR =',', FIRSTROW = 9 )

error

Msg 4861, Level 16, State 1, Line...

Do you have similar example of ssis packages

Hi Becouse As I explained earlier I am having 2 source connection for US .

Out of 3 DFT 2 DFT have sourceA and Last DFT have difrent source.

For each loop...