Avatar of RichNH
RichNH
 asked on

SSIS - Executing SQL code modules

I am brand new to SSIS.  I am using MS Visual Studio 2008 Professional Edition. I understand from my few exposures to it that you can set it up to execute several SQL code modules in turn, one after another (not all at the same time).  I have 7 such code files (Pass1.sql, Pass2.sql, ..., Pass7.sql).  

I created an SSIS project and in the control flow section I put in 7 instances of the Control Flow Item "Execute SQL Task".  I tied these together with Precedence constraints.  In each item I set the SQLStatementSourceType property to "FileConnection" and in the SQLStatementSource property I put the full file spec.

When I try to execute this mess SSIS tells me it can't find the source code.  Yet if I copy the entire filespec and paste it into Windows Explorer, SQL Server Mgt Studio fires up and loads my source file correctly (so I know there isn't a mistake in the file spec I put into the property).

I must be missing something.   What is it?  See attached Word Doc with 3 screen shots in it.

Thanks
DocError.docx
Microsoft SQL Server

Avatar of undefined
Last Comment
RichNH

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
EugeneZ

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
EugeneZ

also make sure you can access to your \\shared folder\file
RichNH

ASKER
I didn't want to use a loop but your link provided me with enough that within a few minutes I figured it out.  She's executing now.   I appreciate the push in the right direction.   Thank you!!!!
Experts Exchange is like having an extremely knowledgeable team sitting and waiting for your call. Couldn't do my job half as well as I do without it!
James Murphy