Greetings,
I have a lot with DTS time under my belt, but I don't have much SSIS. The DTS setup was a lot easier with mapping but I seem to be missing something with SSIS.
I'm trying to import data from a pipe delimited file into a SQL Table.
Pipe File Format
1234567|abcd|hello
1234568|efgh|goodbye
The real pipe file contains 52 piped fields, but I only want to get the first "Value" ie 1234567 and 1234568 and put the data into a single column char(12) field.
I have a DTS package that did this without any problems, but SSIS doesn't build the package the same way. Migrating the package didn't work, so I'm trying to build it from scratch.
I haven't seen any Internet info on Pipe delimited files where only one column is needed (Column 0). The answer is out there, I just haven't found it. I have my flat file source (and connection manager) and the SQL server destination (and connection manager for that), but I get errors when I run it. I've been trying many different setups, so the errors can come up differently.
Thanks in advance.
Update: I finally gave up on trying to get this to work from my notebook and went to another system and I had this process working in less than 5 minutes. The next task is to move anything worth while from the notebook and slam it.
Welcome to [BI] Resort!
Sorry for the delay! Do you still need some support?
Regards,
Pedro