Search results for query: *

Check the user account you are testing has an account in the database. Try using SQL Query analyser first. When you get the user and passord, select sql server authentication and test the login and password. Check if you can access, then try seting DSN anil

DTS is Data Transformation services in sql server. you can automate repetitive tasks like loading data from sources like excel etc Anil

Thanks this was useful anil

I have a asp page which sits on one server and SQL Server is on another machine. So how to run a DTS package from that asp page Is it possibe, or the asp page and the SQL Server should sit on the same page? Anil

Hi I wanted to pass multiple prompts using a macro to a report, whats the syntax for it? I have tries Set objImpRep = objImpApp.OpenReport ("D:\imr\test.imr","200212","005") it doesnt work? anil

sorry wont copy the DTS for copying DTS you need to copy msdb database, but this will copy all the tables and stored procedures anil

You can copy the .mdf file and .ldf file AND Then do EXEC sp_attach_db @dbname = dbname, @filename1 = path\pubs.mdf', @filename2 = path\pubs_log.ldf' it will create the whole copy of database including stored procedures and DTS

try this Select name as '1', Addr1 as '2',addr2 as '3' from Table

select Loginid from table1 where Loginid not in (select Loginid from table2)

Check if a file called FPD_12-15-2002.lDB' exists. If so delete that and try. Also check under whose account the Job is running

try this right click the webpage and click permissions.Add users to that whom u wish to give access. Go to IIS. select Basic Authentication and then try ogon = Request.ServerVariables("LOGON_USER")

Ima having a strange problem. When scheduling Impromtu files to save as excel file, works fine is the machine is not locked. However if the machine is locked the report hangs till the machine is unlocked. Once unlocke dthe report runs properly

Hi I was trying to import a table from progress database to sql server Using DTS. select "Tablename"."Name","Tablename"."Address", "Tablename"."Date" from "Tablename" where "Tablename"."date"=Date...

Hi I wanted to pass filter values into a Impromtu report from a file. For e.g I have a imr file which uses date filter what I want to do is pick these date from a text file. Is it possible, as I have a number of reports which will use the same date filter. Is it possible. Also is it possible i...