These two blogs are giving better understanding to me about the issue

http://www.sqlservercentral.com/blogs/jamesserra/2011/08/29/when-to-use-t_2D00_sql-or-ssis-for-etl/

https://derekdb.wordpress.com/2012/03/13/ssis-lookup-or-t-sql-join/

I have validated the variable . At run time NULL shows as just blank . This causing the issue here as this try to validate " as hbSCDType2DestCol" instead of...

I did not understand properly , but let me know did you tried using for each loop to iterate your result set , then execute sql task does the insert...

Thanks for your suggestion . 🙂

At this point issue is resolved . I have taken out the lookup transformation , instead used join at source . But still curious to know if this situation can...

Thanks you ..

I got the issue now . In the configuration file , connection string was defined for Windows authentication . Since I am logged in and running through the...

I maynot be clear the scenarios . But let ask you why don't you convert into INT instead of Money . Any way you don't need decimal places.

My code looks like this ...

Even i passed these parameters process LOAD_DDA.dtsx take only those values which sets on design time .

DTExec.exe /F "D:\SSIS\Packages\LOAD_DDA.dtsx" > "\\Packages\log\output.txt"

/SET \package.variables[User::IN_FileConnString].Value;"\\Files\DDA_TARS_012014.txt"

/SET \package.variables[User::IN_fiscal_year_nbr].Value;2014

...

Phil Parkin (1/12/2014)

Thanks for getting into deeper

Few of the rows , first column coming as empty . But do you think in SSIS or Excel this will be a issue...

Phil Parkin (1/12/2014)

Great, that helps.

Now my question is: why in the above is there a...

Phil Parkin (1/12/2014)

sql crazy kid (1/12/2014)

Phil Parkin (1/12/2014)

Columns are not missing here . I have 5 column here ,looks like this.

[Just a sample data ,but this is the format...

Phil Parkin (1/12/2014)

Columns are not missing here . I have 5 column here ,looks like this.

[Just a sample data ,but this is the format we load]

col1 col2 col3 col4...

Phil Parkin (1/12/2014)

Here is few more details

Backend - SQL server 2008 R2,SSIS installed

OS - Unix Env

We have many process running on unix ,connecting to sql server , BCP into sql...

Phil Parkin (1/12/2014)

sql crazy kid (1/12/2014)

Phil Parkin (1/12/2014)

To do what, precisely?

As you have given no examples of the data which is giving...

Phil Parkin (1/12/2014)

To do what, precisely?

As you have given no examples of the data which is giving you problems, providing any sort...