There is no dynamic import of data....

I was struggled the same for Siebel to SFDC of one of Data Migration Project.

But you can try with SQL Commands..

Use coalesce for (after applying SUM() and Groupy by) as A

Please try the below one for your requirement

---------------------------------------------------------------------------

Selectid,

SumAmt,

Typ,

code ,

createdDt,

CCY,

AppNo

from (

select S.Id,

S.SumAmt,

M.typ,

M.code ,

M.createdDt,

M.CCY,

M.AppNo,

ROW_NUMBER() over (Partition by M.Id Order by M.Typ Asc) Rn...

Step1:Load SQL to AS400

Step2: Update SOurce table flag with Destination data for matched as 1 and mismatched with 0

It means that some LF of CRLF or some text code is missed in your Flat file...Check your flat file is with correct format or not...

Change CR , LF ,...

Correct if you are looking for the below one

The select is of a.* not b.*

if this is one you are at...

Delete the matched records from source table(Second) with First...

get info from SQLSchool.com

For huge amount of data :-

Load Excel data into Intermediate table (create this) and then do MERGE with primary table if they( Primary & Intermediate) have any joining Columns...

For...

CONCAT is the System function..no need to specify as dbo.CONCAT, if you specify like this ...the SQL will go search an object exists with CONCAT in your User Objects....

plz...

Below is for your information..... It may be depends on Server Envioronmrnt also....

1. In-place upgrade

Easy to implement

...

Use CHARINDEX and SUBSTRING functions...

The query executing successfully in Query window?

If yes... then Security permission issues are there ..

The problem with the SQL Agent is that it runs under an account which does not...

Use below query on your DB

select name,modify_date from sys.objects where type='P' order by modify_date desc

Use ANSI files only for extraction...

Once all files are extrcted then do Conversion using script task.....

Dont use Code page as 65001 in advance editor or in Flat file manager

Thanks to all for your inputs.....

Even though we followed the 65001 in OLEDB data source & Connectin Manager...i came to know some data ( pound symbol & euro symbole )...