Hello Everybody!
Im trying to migrate my SQL 2000 packages that’s currently working in the company production enviroment to SSIS packages. So, in the 2000 version i got the flat file from Mainframe and i had to do a trick to transform all the columns to match the same size as the example above:
1432 1138734217 1144256628<CRLF>
1432 1138734217<CRLF>
1433 1136657788 1122441177<CRLF>
1433 1125554545 1122441177<CRLF>
1433 1192925544 1122441177<CRLF>
So, when i import the file, first of all i have to transform the Text file to another texfile file fixing the size to 32..... but you can see that in the second row im receiving a CRLF and if i try to import without the trick, the preview of the ragged file show me the columns desorganized...
Someone knows how to import it without transform to another text file with fixed length
Thanks
Cleber
Cannot import file from Mainframe
Hot Topic
- Can you Cache a SSIS Lookup component to Foxpro v7 with parameterized query?
- About Members and Ordinal function
- Datafields in report header
- SQL Server Express fails to install
- SQL installation Error...
- How to Reuse functions in script tasks ?
- Conditional Split to send top 10, top20, and top 30 in three different flows ?
- Windows Authentication and WebServices.
- Reporting Services 2000 broke by installing .NET 2.0 redistributable runtime files
- Error during Loading Data form a falt file into DB2 database??s
SQL Server
- Any full-text gurus - Help writing a query
- Missing data with SSAS cube as a report data source
- Maximum Conversation timer interval
- Using CC and BCC in Notification Services
- Is it possible to create a bar code in SQL reporting?
- Send Muti-Values to Stored Proc?
- Trying to Configure For Loop Container
- SUM is summing like values
- Restore to a previous version
- ActiveX script to grab all users in Active Directory and tranfer to SQL Server.
Cannot import file from Mainframe
humair
Hi
Have you already tried with a Flat File Connection Manager using the Ragged Right format and the {CR}{LF} Header Row delimiter
I've quickly tried and it seems to be ok.
Cheers,
wls1973
I tried this way but the mainframe did not send a header :(
Thanks for the help!