Viewing 15 posts - 9,796 through 9,810 (of 11,678 total)
I second the suggestions from opc.three, but there's another alternative:
the protection level Server Storage.
It's there for a reason 😀
March 11, 2011 at 8:29 am
What is the error that you get?
What value did you specify for the index in the variable mappings pane?
March 11, 2011 at 8:26 am
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...
March 11, 2011 at 8:24 am
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...
March 11, 2011 at 8:19 am
Grant Fritchey (3/11/2011)
Koen Verbeeck (3/11/2011)
I see what you did there 😛 :hehe:
You set 'em up, I'll...
March 11, 2011 at 8:13 am
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...
March 11, 2011 at 8:09 am
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...
March 11, 2011 at 7:57 am
Read the section about Truncated Text in the following article:
March 11, 2011 at 7:54 am
Duplicate post, no replies please.
Original thread can be found here:
http://www.sqlservercentral.com/Forums/Topic1076342-391-1.aspx
March 11, 2011 at 7:52 am
Duplicate post, no replies please.
Original thread can be found here:
http://www.sqlservercentral.com/Forums/Topic1076342-391-1.aspx
March 11, 2011 at 7:50 am
Louie.Velez (3/10/2011)
Moving each flat file to an archive folder, maintaining the original file name, file structure and format
Check out the SSIS FileSystem Task.
Louie.Velez (3/10/2011)
March 11, 2011 at 7:47 am
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)...
March 11, 2011 at 7:39 am
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.
March 11, 2011 at 7:36 am
Phil Parkin (3/11/2011)
Thanks mate. Nearly beer time.
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...
March 11, 2011 at 5:52 am
Viewing 15 posts - 9,796 through 9,810 (of 11,678 total)