SSIS-Derived Column Text File Help

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

SSIS-Derived Column Text File Help

Author

Topic

nickjb16
Starting Member

6 Posts

Posted - 2009-07-21 : 09:50:06

Hi,

Trying to setup an SSIS task to import text files in a non-standard format directly into an SQL database. I am stuck at creating a derived column. Can anyone help with the expressions that should be used to import this text file? Basically, I need to pull out the information contained inside the quotations.

Thanks very much

System Name="ABCDEFG-XP1";
Serial Number="L39392SD";
Machine Model="28393JKD";
System Type="ThinkPad T400";
Hardware Type="Notebook";
Wired MAC Address="00:00:00:00:00:00";
Wireless MAC Address="00:00:00:00:00:00";
BIOS Version="7UET46WW (1.16 )";
Warranty Information="2011-10-27";
Region="North America";
Location="San Jose";
Organizational Unit="Productivity";
Engineering="No";
Productivity="Yes";
Serviced Business Desktop (SBD)="Yes";
Full Name="John Q Test";
Personal Login="jqtest";
Image Build Version="Version 2.2.5";
Image Deploy Date="Mon 05/11/2009";
Company Asset Number="6022112";
Technician="nbkdkwe";
DeployDuration="150";
BIOS Update="No";
Repository="newyork.corp.com";

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources