Viewing 15 posts - 16 through 30 (of 66 total)
We are assuming you do not want to cleanse the offending rows for proper data. In other words, the rows will either be exact duplicates or meaninglessly different. Assuming...
July 12, 2006 at 12:16 pm
Assuming that you get the file name into a global variable, you do the following:
1. Before the transform, insert a dynamic properties task. Make sure the workflow is adjusted...
July 12, 2006 at 11:59 am
jp:
You can use the Dynamic Properties task to accomplish this assuming the data layout in the files do not change. Here's an article for your research:
http://qa.sqlservercentral.com/columnists/bknight/dynamicpropertiestask.asp
July 12, 2006 at 9:50 am
How many clients are we talking about?
July 11, 2006 at 12:23 pm
Use ON ERROR instead on date casts.
Function Main()
On Error Resume Next
DTSDestination("DOB") = DTSSource("DOB")
If err then
err.clear
DTSDestination("DOB") = NULL
end if
Main = DTSTransformStat_OK
End Function
It's...
July 11, 2006 at 10:39 am
That a good enough solution for a table that will be populated by your DTS only, but what happens when you use that table in an application that can write/update...
July 11, 2006 at 10:12 am
Declare @X varchar(10); -- Use the amperstand (@)
Select @X = 'test' -- don't forget to set the variable
Select * from table where table.id = @X -- Use the amperstand...
June 15, 2006 at 6:53 am
In the future...
There is a program called DTSBackup 2000. You should really check it out. It's free.
I use it in conjunction with SyncBack, which is also free. ...
June 13, 2006 at 7:24 am
As Luke says, it depends on what you are trying to do. I recommend turning on the just in time debugger.
On the server console pane (the left...
June 13, 2006 at 7:11 am
Function Main()
IF ISNULL(DTSSource("ACCT MGR AREA CODE").Value) _
OR _
ISNULL(DTSSource("ACCT.MANAGER PHONE").Value) _
THEN
DTSDestination("Account Manager Phone") = ""
ELSE
DTSDestination("Account...
June 5, 2006 at 6:58 am
My 2 cents:
The description never said the doors, when shut, are "light" tight. In other words, you should be able to see the light through the cracks of the...
May 12, 2006 at 7:35 am
Copied From Microsoft's site and editted to your request:
Sub FolderPlay()
Dim fso, fldr, s
' Get instance of FileSystemObject.
Set fso = CreateObject("Scripting.FileSystemObject")
...
February 23, 2006 at 9:07 am
Here's one I know all too well. Make sure if you have any ActiveX scripts, that all MSGBOX and INPUTBOX statements have been commented out.
February 23, 2006 at 8:55 am
I agree with Jonathan. I've never had issues with "lost" data. DTS will definitely inform you of any errors. It's worst than my 9th grade English teacher.
February 17, 2006 at 7:43 am
Viewing 15 posts - 16 through 30 (of 66 total)