Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.
One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.
Course Of The Month
8 days, 23 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
SSIS - Executing SQL code modules
Posted on 2012-12-31
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
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
3 Comments
Active 2 days ago
try this example:
Execute .SQL files by using SSIS
http://sqlage.blogspot.com/2012/10/execute-sql-files-by-using-ssis.html
Execute .SQL files by using SSIS
http://sqlage.blogspot.com/2012/10/execute-sql-files-by-using-ssis.html
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Everyone has problem when going to load data into Data warehouse (EDW). They all need to confirm that data quality is good but they don't no how to proceed.
Microsoft has provided new task within SSIS 2008 called "Data Profiler Task". It solve th…
JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month8 days, 23 hours left to enroll
617 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.