Is it possible to send the complete SQL string from my ASP.NET form to the ReportViewer component? Just passing the parameters does not solve my...
Hi. I have been struggling with this problem for some time and it appears to be a bug with DTS. I am calling a package from another package. I have...
I don't think it is anything to do with permissions on COM component, because I can call other methods on the same component, they work OK.But the...
Derrick, First of all thanks for your interest. The COM component is running under an 'adminitrative' account, that has full rights on the machine....
Argyle, I am using UNC path '\LDNFS5PROGSDOSAPPSirfedataSbPrdStsBin'. Is that what you mean? Jaswinder Singh A K ITech Limited London, UK
Hi, I have written a vb script to map a drive to one of our Novell Servers. This code works fine if I execute with in a DTS package. But if I put...
Guys, I am trying to assign values to some global variables from stored procedure output variables. If I declare sp like: DECLARE @RC int DECLARE...
Sorry Guys, I made a mistake here. Actually It never works on the SQL Server box. As DTS package is trying to import a file from a Novell Server....
No, It does not work from command prompt on the server. I tried it with /E switch. I was logged in using the same domain account that I SQL Server...
here is the path: \vs1-60ve-cr21CR_GROUP11GROUPSBankOneIRDMigrationDevelopmentJasjasTestFilesjasUser.txt Jaswinder Singh A K ITech Limited London,...
Argyle, here is the line EXEC master.dbo.xp_cmdshell 'dtsrun /S sldn057 /U sa /P password/N jasDTSUser' The above line, it does not matter if I...
Argyle, It does work on the server as well, but only when I log on to the server and execute the package manually (right click Package name and...
Satya, I know it looks like a silly question but where do I need to check to check this register key, On SQL Server box or on Novell machine. (I...
No, It did not work, got same error message 'Network name can not be found'. It is failing because I am importing from a Novell Share drive. It...
Argyle, Thanks for your immense interest. I will try that. I will be 1. Registering SQL Server on my PC using my Windows Credentials 2. Connect...
Guys, Its nothing to do with SQLAgent or scheduled job. The problem is - if I run the dts package manually it works fine, but if run it...
Twan, Probably I didn't make myself very clear. It works OK as long the files are on a NT share, problem is only with being files on a Novell...
Thanks for the quick response Satya. I was very delighted to see your quick reply. But my problem is still not solved. unfortunatly I am trying to...
Guys,<br /><br />I thought I new how to run DTS packages on server that requires files from the network, but I have been constantly running into this...
Separate names with a comma.
