Viewing 15 posts - 2,536 through 2,550 (of 4,272 total)
I'm sorry, that question is WAY too open.
One of the most common issues affecting all programming is not thinking through what you want to accomplish and then looking at the...
March 9, 2010 at 12:39 pm
Hold on, you want to take a variable add one to it and update the table? Have you looked at using an EXEC SQL task and pass the variable...
March 9, 2010 at 12:34 pm
Where is the log file located?
CEWII
March 9, 2010 at 12:31 pm
Ah Lynn you are just about 30 seconds faster than me..
CEWII
March 9, 2010 at 10:20 am
You might execute this:
SELECT * FROM msdb.dbo.sysjobsteps WHERE subsystem = 'SSIS'
And look in the command field and see if there are multiple references to the config files. If not...
March 9, 2010 at 10:13 am
I have done something similar in the past only on the input collection. The problem was and is that there is no enumeration of the column list available directly...
March 9, 2010 at 10:04 am
I think your domain user needs to be either in the local administrators group or in the domain admins group. Most remote WMI queries require a fairly high level...
March 9, 2010 at 9:59 am
You might check the errorlog and see if there are any failed logins for that user. Something is causing a lockout condition. You might also run a trace...
March 9, 2010 at 9:54 am
I don't believe your clarification really makes any difference, you still need to have the underlying framework available.
CEWII
March 9, 2010 at 9:50 am
If you have enterprise edition then you can use Data Driven Subscriptions. I believe you can do it by hand where you will have to configure each report seperately...
March 9, 2010 at 9:49 am
I'm wondering if the string it is refering to in "error CS0029: Cannot implicitly convert type 'string' to 'string[]'" is incorrectly defined. I *think* you need to define the...
March 9, 2010 at 9:47 am
Nor me, it has been a while..
CEWII
March 8, 2010 at 9:27 pm
Really, IIRC, it required you to load a bunch of assemblies into SQL before you could reference the required assembly due to dependencies. I could be wrong though..
Either way,...
March 8, 2010 at 9:05 pm
Yes, you should, even if it is just being able to read it and understand what is happening. There are several languages I don't even have basic coding skills...
March 8, 2010 at 8:41 pm
I agree with Barry, I have done EXACTLY what he is describing several times when working with Excel files and SSIS.
CEWII
March 8, 2010 at 8:37 pm
Viewing 15 posts - 2,536 through 2,550 (of 4,272 total)