Yes, but most sites offer them for a fee.

You can take a look around YouTube to see if you can find interesting ones.

There are also sample databases available for earlier versions of SQL Server.

You can use UNION ALL to string the resultsets together in one resultset.

This resultset you can use as a subquery for another query which counts the Yes answers.

WITH CTE_Results AS

(

result1

UNION...

Seems to me you need to play around with subreports and passing parameters to these subreports so that you only get information for one agent.

The error window is for errors/warnings when you are designing the package. (for example: you did not specify a connection manager for the Execute SQL Task)

For runtime information, you need...

Use a for each loop.

There you can use wildcards to find the correct files, for example source_*.csv.

A small tutorial:

How to loop through files in a specified folder, load one by...

The set-up seems to be OK.

You can use breakpoints to stop the loop at every iteration, so you can inspect the variables.

On a sidenote: this set-up takes only a few...

George M Parker (9/26/2013)

---

Read Koen's blog in its entirety and that will answer your questions. SSIS needs to be installed (the binaries) in order to run SSIS packages. The service...

Another option is to use source control on your development environment.

For example TFS integrated in BIDS.

Maybe the quickest way to get some overview of the 3 different tools is to read the training kit for the 2008 exam:

MCTS Self-Paced Training Kit (Exam 70-448): Microsoft SQL...

It might be a track worth pursuing, but to me it seems like you're adding an extra step.

How do you load the data now? If you sort the data according...

etl.laptop (9/26/2013)

---

I made a practice problem for myself - Using SSIS, make a package to load data from text files located on a Server P, load these files into a...

Didn't even have to think for this one. Which is nice for a Friday 😀

CptCrusty1 (9/25/2013)

---

I have a file that comes from a vendor who can't seem to spell. The file has a Prefix of D,E, or P. 95% of the time...

To be short: you need to install SSIS on the server where you want to run the packages. This isn't necessarily the machine where they are designed of course, but...