[dba-SQLServer] SSIS packages

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
 


More information about the dba-SQLServer mailing list