Gents,

many thanks for the comments. I am a developer rather than DBA so the whole transaction log file thing is out of my area of knowledge. Are there any good...

Many thanks Paresh,

that is exactly what I have been doing, however I was very concerned that ther may be an issue with doing this. Just wondered if there was a...

why not use shrink (shrink file rather than shrink db) to shrink the log files? what are the downsides?

Sorry to hijack the thread but I have started to use shrink...

If you are asked how they are run, then you may find that they are scheduled as jobs.

Open Enterprise Manager, select the SQL Server Instance, and expand. You will then...

Or Even a scritp task to copy from one directory to another.

Ells.

🙂

Just one question In the Execute SQL Task Editor, go to the Result Set Tab.

Result Name should be 0 and variable name User::GetName

Is this true?

( I am assuming your sql...

Edit the foreach loop container.

On the TAB for Variable Mappings there shoul be a variable to hold the fully qualified file name is set. By fully qualified i.e. “C:\FEL\file.csv”

Now add...

There is a really good tutorial page here ->

As have been said above

1. check there is a result from the SQL

2. check the result set is set to single...

Need a little bit more info. In your data flow the OLEDB Souurce are you selecting Data Access Mode 'Table or View' for the source.

If so could you use...

Just one other note. If the data wuality is poor it may be 'ABC' in the fact table and 'ABC ' in the dimension table.

I sometimes...

I am in agreement with Dan, as part of my SSIS package for loading data I use the Row Count task in the data flow to capture the number of...

I have used temp tables on bids. Created in one task in SSIS and used in another.

ie to check that the dimension product includes all the product_codes in the fact...