I second the suggestions from opc.three, but there's another alternative:

the protection level Server Storage.

It's there for a reason 😀

What is the error that you get?

What value did you specify for the index in the variable mappings pane?

When you build your project, the packages are copied to the bin\Deployment folder, where also the manifest file is created. Are the newly created packages also present in the bin\Deployment...

If I'm not mistaken, you just need to store the filenames of the PDF file into a table, not the actual data.

In your for each loop, you can set it...

Grant Fritchey (3/11/2011)

---

You set 'em up, I'll...

What I usually do:

* script out a "deployment script" using dtutil

* place the script into a folder that contains the to be deployed SSIS packages

* only the DBA has the...

Why on earth would you want a report with 90000 rows? That is not a report, that is a data dump.

Check out the bcp utility to dump data from SQL...

Read the section about Truncated Text in the following article:

http://msdn.microsoft.com/en-us/library/ms141683.aspx

Duplicate post, no replies please.

Original thread can be found here:

http://www.sqlservercentral.com/Forums/Topic1076342-391-1.aspx

Duplicate post, no replies please.

Original thread can be found here:

http://www.sqlservercentral.com/Forums/Topic1076342-391-1.aspx

I see what you did there 😛 :hehe:

Check out the SSIS FileSystem Task.

Louie.Velez (3/10/2011)

---

Create a report which provides detailed information...

What do you mean with "the" tool? Do you already have a tool in mind?

You can use SQL Server Profiler to monitor what is going on a SQL Server (http://msdn.microsoft.com/en-us/library/ms187929.aspx)...

As far as I know, you can only build hierarchies inside a dimension, so you'll probably need to join the dimensions into one single dimension.

Hmmmm, that's right. I got a cold Jupiler Tauro waiting for me.

(a bit the same like a Duvel, but not as good. I got...