JWColby
jwcolby at colbyconsulting.com
Fri Mar 30 11:50:48 CDT 2007
I need to import 50+ text files into SQL Server. These are fixed width files with 150 fields. I tried to run the wizard and save an SSIS package, and in fact I do have an SSIS package however I cannot execute it. So that is my first issue, how is it that I can create a SSIS package and then not have it function when immediately re-executed? In fact I am not sure that this will help anyway since I would need to either specify a different file name or play stupid games renaming the source file. Is there an editor for SSIS packages to allow going into them and making modifications once created? 1) Is there ANY way to do this via the wizard, so that I can graphically define the column positions, and then save that definition and run it again later? 2) Can the wizard run this "something" that I saved. It seems rather silly that the wizard cannot simply look for something that it saved just moments before, load that something, and execute it. 3) It seems rather silly that after executing the wizard, you no longer have the ability to "go back", you have no choice but to continue, whereupon you have to go back through the whole rather painful process of setting up 150 fields. 4) Is there any way to set up the column NAMES in the destination table inside of the import wizard? With fixed with data there is no header row of field names as there might be in CSV format. SQL Server is simultaneously so powerful and so stupid sometimes! I just want to get work done! John W. Colby Colby Consulting www.ColbyConsulting.com