Ya that's correct for each loop wil work,

But my question is that within US zone I have 2 different source

out of 3 DFT 2 DFT have same source and 3rd...

Hi ,

I am unable to start to create the script for 3rd table, it has multiple foreign key.

kindly review the script of first 2 table and help me create the...

CREATE TABLE [dbo].[md_geographylevel](

[type_key] [int] NOT NULL,

[geog_key] [int] NOT NULL,

[Type_description] [nvarchar](50) NULL,

[Store_flag] [nvarchar](10) NULL,

[Type_short_desciption] [nvarchar](50) NULL,

[Type_long_desciption] [nvarchar](100) NULL,

PRIMARY KEY CLUSTERED

(

[type_key] ASC,

[geog_key] ASC

)

CREATE TABLE [dbo].[md_geographyleveltype](

[type_key] [int] NOT NULL,

[Type_description] [nvarchar](50) NULL,

[Store_flag] [nvarchar](10)...

Using SQL Qury.

What if out form both statement comes from 2 different table.

Regards,

Vipin jha

Hi ,

I have used below expression betting getting issue with that

(DT_STR, 4, 1252) DATEPART("yyyy" , @[User::migration_start]) + "-" + RIGHT("0" + (DT_STR, 2, 1252) DATEPART("mm" , @[User::migration_start]),...

Hi ,

You can simple load your data into temp table

tempo table must have only 3 column.

loadid,col001 and load_date

then process your data from temp table to main table by the...

Hi ,

Sample data are below :-

06/06/63

09/17/61

06/03/69

11/23/64

07/10/90

02/02/69

09/30/70

12/05/49

01/04/67

Regards,

Vipin jha

Hi According to me Checkpoint is used to restart the package from the point point where it fail.

so u can seee that when your package failed one files are getting...

Hi ,

It was a problem with the length of column.

i increased the length of column and now running fine.

regards,

Vipin jha

I think you dropping an creating the table at every run , and you probably missing the table creation step

Ok,

Is there any alternate of merge where i should not get issue with duplicate record in source if found.

yes true, but if in case we duplicate bbxkey come in source then how to avoid this .

Got the answer

issue with the exec

correct one is Exec (@sSQL)

Hi,

I want below Output from above command

insert into staging_temp_1

select dbo.fnGetFirstOcurrences(col001, '¯',@Columns),LoadDate from staging_temp