Viewing 15 posts - 16 through 30 (of 84 total)
Anyone ideas on this solution?
I am trying to import the following row from a CSV file into 5 seperate columns.
APP1XH6JXY3SBC201509010920152015090109201505127651
My Flat File Connection Manager Editor Column is called AuoScore...
October 26, 2015 at 4:49 am
Hello,
I wanted to test with the first column. Tested, but all the rows seem to be importing into Record_ID.
In my package, my external column name is Autoscore. My Output Column...
October 23, 2015 at 8:25 am
Hi Can anyone point me to some examples of these solutions?
October 22, 2015 at 2:49 pm
Thanks Guys. Can anyone point me to any specific examples. Much appreciated.
July 21, 2014 at 3:53 pm
I actually found the solution to this on Google. Here is the solution:
SUBSTRING([OrderReceived],1,4) + "-" + SUBSTRING([OrderReceived],5,2) + "-" + SUBSTRING([OrderReceieved],7,2)
November 14, 2013 at 7:28 am
Thanks for the reply. I have changed my datatype to Nvarchar (50) I am still getting the warning sign on the ADO NET task: The data type system.object found on...
October 7, 2013 at 4:56 am
Any ideas anyone?
October 6, 2013 at 3:00 pm
How did you configure report server to be its own smtp server? Was this a case of altering your config file?
October 4, 2013 at 7:44 am
Thanks for your reply. I am trying to import a flat file into an SQL Server table.
The file structure is as follows:
3178593|M120|010|3206304|AF-01566|20130917|1123|3
0007|900548|00002|||00000.000|TOS
0013|3043213|00001|||00000.000|EOE
0014|270652|00001|75-104||00000.000|TOS
I am only interested in importing the first...
September 23, 2013 at 7:11 am
Any idea? I believe i can use the conditional Split. But I am struggling to find a way to use this.
September 23, 2013 at 6:27 am
Hello,
I have solved this problem now. I used one table rather than two tables to use both datasets.
Regards
September 20, 2013 at 7:20 am
Totally lost!
My Header row delimeter is set to: Vertical bar |
Header rows to skip is 0.
When i go to the preview the import i can see the top row from...
June 20, 2013 at 8:17 am
Hi Thanks for your suggestion. I carried that out and I have even developed a new package, however I am still missing the one row on import.Very Strange.
June 20, 2013 at 7:07 am
Viewing 15 posts - 16 through 30 (of 84 total)