Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by paskuda

  1. paskuda

    Reconnecting network drive on wireless connection

    Hi, We're having a painful problem here. There is a network drive on the workstation mapped to a share on a server, say, \\server\myShare. The connection between workstation and server is wireless - workstation connects to a Linksys AP. The drive is set to reconnect after windows restart. The...
  2. paskuda

    Control .AVI playback in the movie

    OK, I found some suggestions to use .wmv instead, I converted my clip and now everything's working great. Still I wondr - why isn't it possible to control divx in the same way? Or is it? Mike
  3. paskuda

    Control .AVI playback in the movie

    Hello, I'm a total beginner, so sorry if I'm asking a stupid question, but I've been googling for two hours now on and can't find the answer. My problem is: I imported a movie into the cast, it's a DivX movie. I placed it on the Stage and it's playing fine, as soon as I start the movie. What...
  4. paskuda

    A little different table rotation ...

    ESquared, Yeah, I tried doing that, whatever. That was not what I meant, try creating the table I posted and rotate it with PIVOT the way I want - if you can, that's great, give me the code and make me happy :) I couldn't achieve that with PIVOT. Anyway, I solved the problem by writing a custom...
  5. paskuda

    A little different table rotation ...

    Pivot needs some aggregation. I do NOT want to aggregate anything. I just want to rotate the table, so values in column one become column names, and values in column2 create ONE single row. I don't think I can achieve that with pivot ...
  6. paskuda

    A little different table rotation ...

    Suppose I have a table like this: ID NAME 1 John 2 Ann 3 Mike etc, etc ... ID column is unique I need a query to return a table like this: 1 2 3 John Ann Mike The IDs become the column names and there is only one row of data. Any ideas? I...
  7. paskuda

    Requirements for dtsx execution

    Thanks :)
  8. paskuda

    Requirements for dtsx execution

    Thank you for the answer. Than means, that if I have a package which is prepared on a machine with SSIS installed and all I want to do is run it on another computer - no modifications - SQL GUI is enough. The package will be fully functional, but I will not be able to redesign it. Did I get it...
  9. paskuda

    Requirements for dtsx execution

    Hi, recently I had an opportunity to talk to MS trainer about SSIS, he told me that an advantage of .dtsx packages is that it's possible to run them from any computer - I just have to prepare a package and then I can distribute it to other computers and run it. Some things are a mystery to me...
  10. paskuda

    how can i allow domain users to acces ms sql server 2005?

    First, create the login for a user. CREATE LOGIN [Domain\User] FROM WINDOWS If you want to give that user a fixed server role use: EXECUTE sp_addsrvrolemember loginname, rolename If you want to give access to database you have to create user in the database for the login and grant him a role...
  11. paskuda

    Deleting File on FTP Server after DTS Pull

    Read Priyank Gajera's post at the end of this thread. He wrote a script task to remove the files. The problem you have is well known issue with non-windows ftp servers and is not fixed yet.
  12. paskuda

    Login to an FTP site, Retrieve and then remove a file

    You can use a ftp task to delete remote files, just set the operation to DeleteRemote. There's only one problem - if the remote machine is non-windows then you will probably get an error "FTP Task: Unable to delete remote files", which is a known issue and should be fixed in next major release...
  13. paskuda

    SQL Server 2008 and Security

    I have SQL Server 2008 CTP installed but haven't tested any of the new features yet.Some of them are, or at least seem to be, pretty interesting. Transparent data encryption is one of them, MS states that it will be possible to encrypt whole database, data files or log files transparently to...
  14. paskuda

    Error setting up Distributor

    As far as I remember, that happens when the network name of the machine SQL Server is working on is different from the value of @@SERVERNAME global variable. I found that script: USE master DECLARE @network_name varchar(100), @sql_server_name varchar(100) SELECT @network_name =...
  15. paskuda

    Line drawing problem - pen changing color

    Chip, Thank you for your reply. 1. It's an LCD display, I'm working on IBM R50e laptop 2. I didn't have it on, now it's o, no change I uploaded a screenshot of my form - it's here. I know it's large, but I didn't want any compression, I wanted the image to be exactly the same as in my program...
See more

Part and Inventory Search

Back
Top