Hi,
I am importing excel data into three tables using SSIS Package.
I used DataflowTask, Excel Source, Multicast, OLEDB DESTINATION three times.
After debugging, my issues are
1. I tried this SELECT First_Name + Last_name AS Full_Name Now name is working. But Street is not working. It showing NULL, I wrote like as below Street_Address + Street_Address_2 + Street_Address_3 AS Street
2. And in excel sheet total records are 10225. After i debugged the package its showing 10225 rows correctly, but in tables showing only 1000 records.
And i wrote query in ExcelSource
SELECT DISTINCT
Id, Name, Sales_Stage, Primary_Sales_Rep_Login, Product, Description, First_Name + Last_Name AS Full_Name,
Street_Address + Street_Address_2 + Street_Address_3 AS Street, City, State,
Postal_Code, Country, Territory, Account_Id, Account, Main_Phone_Number,
Main_Fax_Number, Record_State, HP_Customer_Agreement_, Legacy_opportunity_ID, LegacyAccount_ID, LegacyProduct
FROM [SiebelIndigoData$]
Santhosh P