Viewing 15 posts - 9,661 through 9,675 (of 11,678 total)
Can you connect to the instance using SSMS?
Do you have multiple instances installed on that server?
March 28, 2011 at 11:31 pm
I went went the logic commonly used in boolean systems, where everything that isn't 0 equals to 1. Luckily I was correct. 🙂
Thanks for the question.
March 28, 2011 at 11:29 pm
GilaMonster (3/28/2011)
Not trying to start any bashing or pile-ons, but this has to rate high on the list of most useless replies: http://www.sqlservercentral.com/Forums/FindPost1084783.aspx
:blink:
Someone should step in before people get hurt...
March 28, 2011 at 5:17 am
MarvinTheAndriod (3/28/2011)
Thanks. Ticked the option for 32bit execution. I now get this error:Option "/X86" is not valid. The command line parameters are invalid. The step failed.
You are running...
March 28, 2011 at 5:15 am
DerbyNeal (3/28/2011)
Can anyone else explain how I can achieve this within SSIS? (other than Dan Humphries)Unfortunately, I can't find anything on the net to help.
Use the Execute Process Task.
March 28, 2011 at 4:52 am
MarvinTheAndriod (3/28/2011)
It runs on 64-bit. So how do I import from excel then ?
By executing the package in 32-bit mode. If SQLServer 2005, run the package with the dtexec utility...
March 28, 2011 at 4:50 am
Are you running the package on a 64-bit machine? If yes, the JET OLE DB provider, used to connect to Excel files, can only run in 32-bit.
March 28, 2011 at 4:34 am
It should work with SQL Server Authentication. But, quoting directly from BOL:
Users who execute packages that include the SQL Server destination require the "Create global objects" permission. You can grant...
March 28, 2011 at 4:23 am
Assuming there is a small mistake in the dateformats in your question, I think the formatting in the Excel file is wrong. You can select the column, go to Format...
March 28, 2011 at 4:05 am
Maybe this blog post can get you in the right direction:
March 28, 2011 at 3:46 am
CirquedeSQLeil (3/25/2011)
Koen Verbeeck (3/25/2011)
my SSIS Denali session is selected for the Belgian Community Day! :w00t:
The Community Day is a joint venture of different Microsoft...
March 28, 2011 at 12:30 am
A positive note to end the (work)week:
my SSIS Denali session is selected for the Belgian Community Day! :w00t:
The Community Day is a joint venture of different Microsoft User Groups. My...
March 25, 2011 at 6:10 am
Fal (3/25/2011)
Koen Verbeeck (3/25/2011)
GilaMonster (3/25/2011)
That's cause I cheated. Hit quote and post, then went back and added something meaningful. 😀
That plan is so cunning you can put a tail on...
March 25, 2011 at 6:07 am
scottichrosaviakosmos (3/24/2011)
col1,col2 and col3 . col2 is column of address but this column has commas for example: 11,down street, London. now because...
March 25, 2011 at 3:17 am
Viewing 15 posts - 9,661 through 9,675 (of 11,678 total)