Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««12

SSIS Importing issue with EXCEL Expand / Collapse
Author
Message
Posted Thursday, March 4, 2010 1:34 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 27, 2010 12:01 PM
Points: 12, Visits: 48
Avinash,

Please look at the attached documents. First document shows step by step instructions how this is happening. Second attachement is the source file that i am using to import.

To answer your question, i am using numeric(7,4) datatype.

Please let me know if you need anything else.

Thanks
Suri


  Post Attachments 
SSIS_EXCEL_Importing_Issuet.doc (18 views, 181.00 KB)
L10_SEFL_ALL_LTL_Template(2).xls (8 views, 475.50 KB)
Post #877139
Posted Thursday, March 4, 2010 1:54 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 4, 2014 4:19 AM
Points: 43, Visits: 325
Ok just looking at this now. Is there any reason you do the conversion. Sorry it might be obvious but im trying to help
Post #877151
Posted Thursday, March 4, 2010 2:12 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 4, 2014 4:19 AM
Points: 43, Visits: 325
Hi,

Please take a look at my output. I may not be able to get in contact shortly. But i will endeavour to further help in the next few days if you like.


  Post Attachments 
Exactly the same spreadsheet as you sent me.docx (12 views, 199.87 KB)
Post #877165
Posted Thursday, March 4, 2010 2:37 PM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, July 27, 2010 12:01 PM
Points: 12, Visits: 48
Attachement you sent me is in 2007 format, can you send me in .doc format if you don't mind otherwise i need to download conversion software

Suri
Post #877188
Posted Friday, March 5, 2010 11:19 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Thursday, September 4, 2014 4:19 AM
Points: 43, Visits: 325
Hi,
Sure. Please find enclosed


  Post Attachments 
Exactly the same spreadsheet as you sent me.doc (6 views, 213.00 KB)
Post #877834
Posted Friday, April 9, 2010 1:17 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, October 22, 2013 11:22 AM
Points: 8, Visits: 108
hey lost track whose porblem was it but it is a simple fix right click on the Excel Source and choose Advanced Editor and then Sselect INPUT OUTPUT PROPERTIES TAB you will find Excel Source output and then click output column and then slect the column for which you have the problem and then on th eright hand side there will be common properties and then in that under the data type properties change it to your requirement this should fix you problem let me know it does or if it doesnt... and most important use SQL in the data access method and then TRIM the Column
Post #900795
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse