[dba-SQLServer] SSIS packages

John,

I don't know how to solve the re-execute part of your problem...and I'm not 
sure if this will help with 50+ text files...but...

I had 45 SQL statements to run against a number of different fields in a 
single table.  I didn't want to have to sit there and push the button 45 
times so I took all of the WHERE clauses and put them in a table...1 row 
per...I then looped through that table with the query analyzer.  Each record 
was passed to a stored procedure that built and executed a SQL insert 
statement.

With that in mind...could a SP be used to pass your file names to SSIS if 
you had them listed in a table?

Not sure if its possible...I myself am still a newbie to SQL server.

Good Luck,

Mark A. Matte


>From: "JWColby" <jwcolby at colbyconsulting.com>
>Reply-To: dba-sqlserver at databaseadvisors.com
>To: <dba-sqlserver at databaseadvisors.com>
>Subject: [dba-SQLServer] SSIS packages
>Date: Fri, 30 Mar 2007 12:50:48 -0400
>
>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
>


>_______________________________________________
>dba-SQLServer mailing list
>dba-SQLServer at databaseadvisors.com
>http://databaseadvisors.com/mailman/listinfo/dba-sqlserver
>http://www.databaseadvisors.com
>

_________________________________________________________________
Mortgage refinance is hot 1) Rates near 30-yr lows 2) Good credit get 
intro-rate 4.625%* 
https://www2.nextag.com/goto.jsp?product=100000035&url=%2fst.jsp&tm=y&search=mortgage_text_links_88_h2a5f&s=4056&p=5117&disc=y&vers=743