Viewing 15 posts - 31 through 45 (of 57 total)
Excellent. Thanks again for your help, I really appreciate it. 🙂
November 4, 2009 at 12:35 pm
Yes, 64 Bit. Currently I have the Agent Job step configured to run the package in a command line with the following for it uses the correct jet engine: "C:\Program...
November 4, 2009 at 10:46 am
Ah, ok. Nice. How about Excel Destination connections? How should those be handled?
November 4, 2009 at 9:59 am
Thanks, Elliott! This helps big time. In the example you provided :
\Package.Variables[Test1].Value
Lets say I wanted to use the above to set my source connection. In my SSIS package do...
November 4, 2009 at 9:51 am
If you run your results to text, does the following get you what you're after?
SET NOCOUNT ON
SELECT
'Loanref Notice1 Notice2 Notice3'
SELECT
[Loanref] + ' ' + [Notice1] + ' ' +...
October 12, 2009 at 11:41 am
Thanks guys. It's standard practice for our programmers to set the job owner as SA before deploying to production for the reasons you just mentioned, so unfortunately I'm still in...
June 24, 2009 at 4:32 pm
Take a look at the dynamic script I posted above last week. For testing purposes I modified it so it executes against ONE database, not all of them. I can...
April 27, 2009 at 10:28 am
There are different amounts of data in each database, but for my testing I executed both scripts against the same database for comparison.
April 27, 2009 at 10:02 am
Florian Reischl (4/25/2009)
Code (4/23/2009)
Flo, I LOVE YOU MAN! If anyone ever says you're not cool, I want names!!THANKS! 😀
Code
:hehe:
... the names and maybe the country 😀
To your problem:
How many...
April 27, 2009 at 9:45 am
I've got a quick question about execution times. It seems that when I run the script that has the code for the loop, even if it's against just one database...
April 23, 2009 at 11:53 am
Flo, I LOVE YOU MAN! If anyone ever says you're not cool, I want names!!
THANKS! 😀
Code
April 23, 2009 at 10:42 am
Flo,
I'm having trouble integrating the code for the variables that you posted into my script. Is there any way you could show me how it would be done...
April 22, 2009 at 4:20 pm
Thanks, Flo! I got it working, but I cant use variables otherwise I get the following message
"Variable names must be unique within a query batch or stored procedure"
Any idea how...
April 22, 2009 at 11:43 am
Thanks Flo! How do I incorporate that into the code I posted above? I've been messing with what you posted but I can seem to get it to work.
April 21, 2009 at 3:54 pm
Viewing 15 posts - 31 through 45 (of 57 total)