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 Strange error when running as SQL Agent Expand / Collapse
Author
Message
Posted Wednesday, June 4, 2014 3:00 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:42 AM
Points: 13,295, Visits: 11,086
viresh29 (6/4/2014)
As with My data I created one file and table Here I am attaching both.

If you create package and It will throw you error at row 2.



Well, first of all, the data in your example are not empty strings, but a single space.
Secondly, if you configure the last column to be an integer in the flat file connection manager and you import actual empty strings (instead of a space), the flat file loads just fine.




How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1577574
Posted Monday, June 9, 2014 7:33 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, October 7, 2014 9:50 AM
Points: 135, Visits: 92
All of the responses are much appreciated and I thought I would just provide an update on my particular situation. After messing with the file's contents, I found the row delimiter (LF) to be causing an issue for some reason. If I update the file manually to have row delimiters of CR+LF I am able to get it to import, so I will just be asking the provider of the file to update the process on their end. None of this solves why it doesn't work from the server and does work in BIDS, but I will take it as a moral victory
Post #1578803
Posted Monday, June 9, 2014 1:37 PM


SSChampion

SSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampionSSChampion

Group: General Forum Members
Last Login: Today @ 11:42 AM
Points: 13,295, Visits: 11,086
Glad you got it resolved (sort of ) and thanks for posting back!



How to post forum questions.
Need an answer? No, you need a question.
What’s the deal with Excel & SSIS?

Member of LinkedIn. My blog at LessThanDot.

MCSA SQL Server 2012 - MCSE Business Intelligence
Post #1578956
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse