Text File source to OLE DB Destination
-
I know most of people think very simple question, I create very simple package, i am trying to transfer my text file to OLE DB through SSIS. Here what i am doing, 1) Source File (Text File) and Destination (OLE DB), every time i run this package i m seeing Red Color. Flat file is comma delimited, Please help me out. What should i do. Thanks in advance.
-
I just tried to Bulk Insert Task" and i m getting below error.
Progress: Preparing the following SQL statement: BULK INSERT]]
[Yolo_Source].[dbo].[test] FROM 'C:\_GIS.txt' WITH(CHECK_CONSTRAINTS,CODEPAGE='RAW',DATAFILETYPE='char',FIELERMINATOR='\t',ROWTERMINATOR='') - 100 percent complete
-
Can you go to the package execution log view and tell us what is the complete error? You can right-click on the line of error and copy the complete text to your clipboard.
---
SSIS Tasks Components Scripts Services | http://www.cozyroc.com/
-
Red Color comes on Flat File Source or in OLEDB Destination? Send the error description along with.
If it is in Flat File Source, then check the followings.
1. Check the Columns in Flat File Connection Manager. Are you getting all the expected rows in the Grid?
2. Check the delimiters.
If it is in OLEDB, then Check the table name and its Mapping columns.
-
As other have already pointed out, you really need a question if you want an answer to your problem.
Please read the following blog post:
Need an answer? No, you need a question
My blog at https://sqlkover.com.
MCSE Business Intelligence - Microsoft Data Platform MVP
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply