Viewing 15 posts - 31 through 45 (of 56 total)
How do i use a trusted connection ?
Because when the SQL Server login prompt pops up, I check 'trusted connection' and Im able to run my query...but the next time...
July 22, 2008 at 1:47 pm
Look for me at the next PASS conference, as primary speaker on 'icons'
😉
May 9, 2008 at 9:10 am
Thank you.
Do you know if there is some sort of explanation for other graphic icons in SQL Server 2005....I would think somewhere in BOL, but havent found anything yet
May 9, 2008 at 8:54 am
Looks like I solved it by using a OLEDB destination connection instead of a SQL Server destination, even though both point to the same location.
I'd still be interested, if anyone...
April 16, 2008 at 4:23 pm
In the meantime, I tried to detach and attach db without success...now when I run the syntax of
'RESTORE DATABASE [customer] WITH RECOVERY' I get the message of
Could not...
March 17, 2008 at 11:48 am
Agreed !..great insights and gives me a better perspective in our DBA world.
January 16, 2008 at 9:12 am
Thank you for your responses !
January 14, 2008 at 9:49 am
Great responses, thank you all for your input.
Lets say I now know how the tables talk to each other, but what about when an application sits on top of a...
January 14, 2008 at 9:44 am
ok, I FINALLY Got it...I had to add an argument syntax....(whew)....lets re-convene tomrrow, is that ok ?...and again, if you'd like to take this offline, we could email back and...
July 5, 2007 at 5:49 pm
At this point, I think I just want to be sure that I have the zip process down..could we take baby steps and only create a zip process that zips...
July 5, 2007 at 4:19 pm
Here are some of the messages:
Error: The wrapper was unable to set the value of the variable specified in the ExecutionValueVariable property.
Warning: SSIS Warning Code DTS_W_MAXIMUMERRORCOUNTREACHED. The Execution method...
July 5, 2007 at 2:02 pm
When you wrote:
"On the server, I made sure that the path environment variable for the system included the path to where gzip.exe was installed."
Where on the server did you...
July 5, 2007 at 1:34 pm
The Executable property is: C\Program Files\7-Zip\7z.exe
Working diretory is: \\networkdrive\SSIS\
I understand that the working directory should be where the zip file will be created, but where do I tell the...
July 5, 2007 at 11:56 am
Well, when I run the zip process task, it excecutes fine (turns green)...but the file I want zipped, doesnt get zipped...where in the zip task do I specify the location...
July 5, 2007 at 9:43 am
ok, that sounds good...thank you so much for your time and providing me with some hope...I'll look forward to hearing from you on Thursday.
July 3, 2007 at 4:56 pm
Viewing 15 posts - 31 through 45 (of 56 total)