I have created a DTS package to import a text file that I receive from an external source on a weekly basis. The text file is delimited by a verticle bar with no text qualifier. The package runs great up until a certain record which contains a " as the first character after the delimeter...
I am trying to import a text file into SQL with DTS and I am having trouble transforming the date field. In the text file they look like 11-Jan-2005 and they are going to 1/11/05 in SQL. SO in the source date format I have dd-MMM-yyyy and in the Destination I have M/d/yy. But it is still not...
I have a trigger in my database to update a project ID in two different tables if it changes in the Project table. My issue now is that I may have the same project ID for two different Employees so the only distinguishing factor is a combination of the Project ID and the Employee ID. How do I...
I am trying to enter a trigger via the Database Diagram in SQL.HELP!
When I right click on my Projects table, I have the trigger option available under the task menu. But in my Hours Worked table all of those options are grayed out. Why does this happen?
I try to use a picture as background.<br>I completely filled the layer at the bottom with this picture and I use this picture as HTML-background. Nevertheless, there's a white area round the movie when publishing.<br>Could you please help me?
I've got two films. I want to use the first one as an intro,<br>the second one as the main film. <br>I want the intro to be played as long as the main film is not loaded.<br>Using an intro by creating two scenes is no problem, but how can i check up if all the frames in another film are loaded?
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.