Viewing 15 posts - 91 through 105 (of 109 total)
Here's a good starting point for you
select p.name,c.text from sys.syscomments c
inner join sys.procedures p
on p.object_id = c.id
June 2, 2009 at 5:37 pm
I don't think that will work because if its failing in the pre-execute phase, then its not executing (logically), therefore there will be no event triggered because of the failure.
I'd...
May 27, 2009 at 4:17 pm
Not sure if this will help but my failing memory is pointing towards something that I heard in a SQL Server 7 course many years ago, that when you do...
May 27, 2009 at 4:09 pm
Sorry - I don't know the answer to that - perhaps someone else on here can help?
March 25, 2009 at 8:44 pm
What do you have in the Event handler? I would've thought that the on error event would fire if the connection did not exist/not found/whatever?
March 25, 2009 at 7:59 pm
Create an execute sql task to retrieve the values and stuff them into variables.
Using the 'expressions' in the Sendmail task, assign the values for From etc to the variables you've...
March 25, 2009 at 4:02 pm
How did you go Sherri?
March 25, 2009 at 3:43 pm
Click in the main window, then on the menu bar SSIS->Package Configurations. Tick the box "Enable Package Configurations", click Add, give the config file a name etc etc.
Word...
March 23, 2009 at 4:23 pm
It sort of depends on why the package is hanging. If its waiting for a file, you could use something like this (obviously alter it for your requirements).
Imports System
Imports...
March 23, 2009 at 3:28 pm
Switch package configurations on, then when you deploy, change the connection string to the production server.
March 23, 2009 at 3:23 pm
Hmmm....I see your problem.
You could probably create a script task to add the relevant commas if this is an ongoing issue, but that seems a bit like overkill.
March 17, 2009 at 7:34 pm
Hi Peter,
If I understand you correctly, you have an excel file filled with a number of worksheets, and you would like to import each worksheet into 1 or more tables...
March 17, 2009 at 6:52 pm
Why is this so difficult?
1. Save excel file as CSV
2. Create flat file connection in SSIS
3. Click on Advanced tab
4. Set the value for the required column to STRING (12)
5....
March 17, 2009 at 3:57 pm
We've recently upgraded from sql 2k to 2k5 (64 bit) and have noticed up to a 9000% improvement (speed) in some scheduled jobs and stored procs. Users have...
March 17, 2009 at 3:22 pm
Viewing 15 posts - 91 through 105 (of 109 total)