Viewing 15 posts - 1,966 through 1,980 (of 7,164 total)
The info you provided about bitness sounds OK.
From the error I am wondering about the existence of the destination Excel file. Does it exist in the prod environment at...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 13, 2013 at 3:37 pm
I think that is up to the program being called not PowerShell. If the program wants to accept input interactively and does not provide an input parameter for the information...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 13, 2013 at 3:34 pm
They will only be able to retrieve data from tables to which you grant them SELECT permissions.
If you are asking if there is a way to allow their database user...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 13, 2013 at 2:41 pm
As was stated READ COMMITTED is the default iso level and the default iso level cannot be changed to something else. Once connected anyone can explicitly change the iso level...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 13, 2013 at 1:30 pm
That looks familiar 😉
If you're happy I say send it to prod!
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 13, 2013 at 12:47 pm
I like option 2 and that can be achieved dyanmically using a DDL TRIGGER such that every time a database is created a new Database User is add for the...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 13, 2013 at 12:45 pm
A unique index where all key columns are non-null will achieve effectively the same thing as having a nonclustered PK on those same key columns plus you can add your...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 13, 2013 at 12:42 pm
Agreed if you only have one drive. I got the impression more drives were available or were being introduced.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 13, 2013 at 12:33 pm
OK. I should have confirmed that from the start. My bad.
Get a command line working first, then move over to configure the Execute Process Task.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 13, 2013 at 12:31 pm
andrew 82282 (2/13/2013)
I'm importing a number of tables with SSIS. I have a variable Filename used to select each individual file.
I want to copy the value of this variable...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 13, 2013 at 12:30 pm
You're welcome. Thanks for the feedback.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 13, 2013 at 12:21 pm
You said in the original post:
I tried to go onto the Location of Zipfile and tried unzipping it manually and it all works good.
Was that just double-clicking on the file...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 13, 2013 at 12:21 pm
Get-WMIObject Win32_Volume -Computer COMPUTERNAME | Select-Object -Property Volume,Capacity,FreeSpace,Name,@{Name="FreeSpace(GB)";Expression={"{0:N1}" -f($_.FreeSpace/1gb)}},@{Name="Capacity(GB)";Expression={"{0:N1}" -f($_.Capacity/1gb)}},@{Name="freespace(%)";Expression={"{0:N1}" -f(($_.FreeSpace/$_.Capacity)*100)}}
You changed COMPUTERNAME in the command line, right? Namespace is not explicitly set (should be using root\cimv2 under the covers...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 13, 2013 at 12:18 pm
balasach82 (2/13/2013)
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 13, 2013 at 12:12 pm
Kevin Drysdale (2/13/2013)
I have a rather large table (122M records) and I need to add a new column - not just to the end, but nestle...
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
February 13, 2013 at 12:10 pm
Viewing 15 posts - 1,966 through 1,980 (of 7,164 total)