Take Flat File source with Fixed width Format and then in advance tab divide your data by giving length of each column next in column tab set your width exactly.

But...

Its my suggestion ,In case of using two Derived Column and one Data Conversion in between source and Destination, it is performance Factor .When we are aware of length of...

The sample data is only one column data or total one row and my suggestion is try to use LTRIM and RTRIM when populating data to file...

Transform it self says that Slowly Changing Dimension so my Opinion is not to us SCD in SQL server 2012 use lookup and merge statement which is available from sql...

Thank you

I understand but can you please share me with example its my request...

PLEASE SHARE YOUR NUMBER PLEASE SO THAT I CAN EXPLAIN YOU CLEARLY WHAT THE ISSUE I WAS FACING PLZ PLEASE PLEASE

iTS URGENT ITS URGENT

ARE YOU CAN CONTACT ME...

Databases we have created in D Drive not in C Drive and we have problem at ssis DB Catalog folder and main problem is transaction log files truncation..

how...

iam using recovery Mode is simple and i have done shrinking also for databases i am using also but no use..

if we try following query i am able to see

DBCC...

As per Error Message you mentioned it is saying you don't have permission on Database your trying to connect...

connect with different Databases and check it once....

it may work.....

Check for Max concurrent executable property from the Sequence container properties and change it accordingly then this problem can be solved and its default is -1

Transaction should be changed package...

i am able to get total number of rows from source first line to last line .

when we are working with files we have to look over with data and...

Place Excel source for Reading Excel file and give column names as per requirement and then place condition split Transformation and in condition split place following expression IS NULL(Column...

My opinion is also same as earlier post check the length of column COL1 in Data base ..... there is mismatch in length and may be data type.

As you mentioned there is no Foreign Keys so truncate and load is better.

1. If you drop the table again you have to create the table and load.

2....

While importing the Data from Files check for the Length and data type of the Columns and better to use LTRIM and RTRIM Functions it gives you performance wise good...