Viewing 15 posts - 151 through 165 (of 681 total)
I agree that the current certification infrastructure has an immense chasm between the "common" certs (MCTS, MCITP) and the MCM. I too would have a hard time justifying spending...
March 25, 2010 at 6:39 am
Is the script that you're running located on a remote machine, and if so, are you accessing via a mapped drive? If so, try changing to a UNC path...
March 1, 2010 at 6:44 am
Excellent, glad it worked out for you. Thanks for the follow-up.
March 1, 2010 at 6:43 am
This is likely an issue with the return value of xcopy - the default success return value is 0 but it appears that xcopy is returning a nonzero value.
To...
February 26, 2010 at 8:37 pm
This should get you started:
February 26, 2010 at 7:50 pm
Vijay,
Just curious, is there a reason you can't use the native SSIS FTP task rather than the script task? If you can, it will probably save you time and...
February 26, 2010 at 7:31 pm
I would suspect that the problem is most likely in the command line params you are passing to your executable are incorrect. Try putting the same comand line params...
February 26, 2010 at 7:27 pm
Scott Smith health care consultant (2/25/2010)
... You should work in HR.
In that case, I retract the entire article :hehe:
February 25, 2010 at 6:43 am
As always, It Depends. For some systems, I keep only the most recent full backup and the log backups since. Other more critical systems have several days worth...
February 14, 2010 at 3:05 pm
Chris,
Yes, it's probably a version difference - my dev system is SQL Server 2008. Do you have access to a SQL Server 2008 installation? If not, I can...
February 8, 2010 at 6:56 pm
What are the data types you are trying to convert from/to? The SSIS derived column transformation allows you to convert data types quite well.
February 6, 2010 at 11:04 pm
You could do this using a script task. If you include a Row Count Transformation in your error output, and use it to count the rows sent to that...
February 6, 2010 at 10:54 pm
I'd heard of the benefit at Google that allows employees to work on outside projects on company time. It's an investment for them to do so, but it's an...
February 2, 2010 at 8:32 am
Great, I'm glad it worked out for you. Thanks for the follow-up.
December 28, 2009 at 12:23 pm
Looks like I left off a string conversion. Add the ToString() method to both of the .Value objects, as such:
dts.Variables("OldFile").Value
becomes
dts.Variables("OldFile").Value.ToString()
... and so forth.
hth,
Tim
December 11, 2009 at 9:57 am
Viewing 15 posts - 151 through 165 (of 681 total)