Viewing 15 posts - 31 through 45 (of 162 total)
Check your file version of the DTS Task UI Provider
(dtsui.dll ) SP4 version = '2000.80.801.0'
make sure you don't have multiple versions in your path... DTS is COM+ based and cannot...
March 9, 2006 at 8:51 am
I've had to conduct similar documentation exercises myself... I have written a .net utility that will document all selected packages from a server and export a documented version of the...
March 3, 2006 at 9:37 am
Vishal,
Send me a personal message with your email address than can accept an attachment. I have written a utility that will compare as well as transfer dts packages between two different servers. ...
March 1, 2006 at 12:44 pm
not sure about this, but give this a try...
enclose your current SQL string within
sp_executesql( ... )
-Mike Gercevich
February 28, 2006 at 6:49 pm
What error message/level is being returned to the conection that is issuing the xp_cmdshell? A better way is to have a stored procedure create and execute the package as a job......
February 28, 2006 at 6:43 pm
it's usually a permissions problem... is the email being sent correctly from both your development and production environment? Does the account have correct access to your mapi profile?
-Mike Gercevich
February 28, 2006 at 6:38 pm
I'm no expert when it comes to temporary stored procedures, but are you certain that you are executing it within the localization of the procedure? You would have to create...
February 28, 2006 at 6:35 pm
Either your process is not returning an errorlevel value that is the standard value of 0 (zero) on successful completion, or it is throwing an error. If you are scheduling...
February 28, 2006 at 6:24 pm
Each task writes to the log on its completion. what you are seeing is the order in that they have completed. the tasks must be connected by way of constraints. ...
February 28, 2006 at 6:19 pm
With the IsNumeric function you do not have any control over what will be returned. It often returns way too may 'true' results than you would wish for.
One thing you...
February 25, 2006 at 6:05 pm
since this is a valid scientific notation number as well as a valid hex number. you will have to write your own function to test for non numeric values. IsNumeric...
February 23, 2006 at 6:18 am
Check your permissions of the account that it is executing under during the non-interactive executions. In Ent. Mgr. it is executing under your personal login. During the other ones it is...
February 22, 2006 at 5:07 am
It is not hung... it is waiting for your response to the msgbox that is not able to be displayed because it is running in a non-interactive mode.
To put this...
February 22, 2006 at 5:03 am
Are you casting your value to an integer either implicitly or explicitly? Post your source table and destination table definitions and i'm sure someone here can figure it out for...
February 22, 2006 at 4:50 am
sDestinationFile = "C:\activant\bkup\test.dash" & "-" & Year & Right( "0" & Month(Now), 2) & Right( "0" & Day(Now), 2)
This would give you the following result
test.dash-20060222
-Mike Gercevich
February 22, 2006 at 4:40 am
Viewing 15 posts - 31 through 45 (of 162 total)