skjoldtc (12/2/2008)

---

I have a question for the frequent posters? Do you spend you employer's time answering questions here or are you doing it on your own time. If on your...

I don't see an issue with using schemas this way as long as the documentation notes how schemas are being used. I wouldn't recommend combining organization with security. ...

Assuming you are using 2005 what do you get when you open up the Report Server Configuration Tool?

What error do you get when you try to connect from...

If you are just talking about setting up security for Reporting Services reports you can start with BOL. Reporting Services uses Active Directory so you just need to deploy...

You need to install SSRS on your PC if that is where you want to deploy reports. If you have SSRS installed elsewhere you just need to set your...

Do you mean you have a set of Reporting Services reports that you want to use a custom permissions solution for instead of setting up the groups in AD and...

Mark,

I think I misread your original post. Were you trying to redirect errors from the Source Component or at the Destination?

I've never had an issue with the a truncation...

An SSIS destination will redirect error rows. I use it all the time. There can be an issue if you use Fast Load though.

I would if...

Lynn Pettis (12/2/2008)

---

Jack Corbett (12/2/2008)

---

You can use a script to check the properties of the file to see if it is in use and then skip it. Whenever anyone is...

You should be able to just use substring against the variable containing the file name in a derived column task in the dataflow. It should be available in the...

You can use a script to check the properties of the file to see if it is in use and then skip it. Whenever anyone is dealing with files I...

Sounds like there is a typo somewhere. Double check the group name.

Is this a one-time thing or on-going? You should look into SSIS as that is what it is for.

Well, based on the data you have provided, you could do a couple of things:

1. Use Substring like this:

Product_Code: substring(Product, 1, Findstring(Product, " - ", 1) -...