SSIS: Two issues while import excel data into three db tables

Posted by vspsantu-21529 under Sql Server on 4/3/2013 | Points: 10 | Views : 1437 | Status : [Member] | Replies : 3
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


Responses

Posted by: Jayakumars on: 4/3/2013 [Member] [MVP] Bronze | Points: 25

Up
0
Down
count ur datatable ROWcount is Record not equal to null

Mark as Answer if its helpful to you

vspsantu-21529, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 4/3/2013 [Member] [MVP] Bronze | Points: 25

Up
0
Down
refer this

http://www.mssqltips.com/sqlservertip/1393/import-excel-unicode-data-with-sql-server-integration-services/
http://www.sqlservercentral.com/Forums/Topic637794-148-1.aspx

Mark as Answer if its helpful to you

vspsantu-21529, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Jayakumars on: 4/3/2013 [Member] [MVP] Bronze | Points: 25

Up
0
Down
hi
also refer this

http://www.techrepublic.com/blog/datacenter/how-to-import-an-excel-file-into-sql-server-2005-using-integration-services/205

Mark as Answer if its helpful to you

vspsantu-21529, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response