My guess is the variable DeleteFileName is currently empty and the File System Task can't handle that.

Try giving the variable a dummy value and see if that helps.

You only need IIS for SSRS 2005, not 2008.

Launch Internet Explorer as an Administrator (right click on the icon and choose Run As Administrator). That might fix the issue.

Jeff Moden - a TSQL guru on this site - swears by TSQL (and thus SSMS) and never uses SSIS for anything.

Reading text files --> bcp or bulk insert

Reading Excel...

Lokesh Vij (10/22/2012)

---

kapil_kk (10/22/2012)

---

in this case the max ident value would be 101 as with first insert statement the value of ident was 100 and with another insert statement the...

What's an unclustered index? On BOL I only see clustered and nonclustered 😛

Great question, but a wee bit too much for in one single question actually.

No, that's not possible.

You can access the data and manipulate it with a script component, but the easiest way would be to write the data to a staging table, run...

Can you be a bit more specific?

Are you working with SSIS?

You can use the SSIS Export Column transformation:

Export Column Transformation

Thanks for the question. Never used the STR function before, and probably never will.

kalpanaganeshm (10/19/2012)

---

Data cleansing is the process of uncovering and correcting inconsistent records from a table, a set, or database. This is used mainly in databases to identify imperfect, incorrect, erroneous...

Nice question, thanks!

Great question. Had to read it a few times to figure out in what order the functions were called.

Hugo Kornelis (10/15/2012)

---

At first sight, I thought this was a question to check whether indexed views can have their own statistics. I did not know that, so I set out...

By creating 42 dataflows.

If they all have the same structure, you can use a for each loop to loop over the files and use only a single dataflow. You need...

As it's dynamic, you can't use the dataflow, so you are stuck with the script task.

Regarding the column name, how do you create it?

The column name is just a cell...