Browse by Tags
All Tags »
SQL Server (
RSS)
Sorry, but there are no more tags available to filter with.
-
|
I recently came across a problem while installing SQL Server 2005 with Windows Installer 3.1. I tried with Windows Installer 3.1 and v2 of 3.1. But it always kept failing. I resolved the problem by uninstalling Windows Installer 3.1 ( it will give a protest...
|
-
|
Sometimes, when the excel column contains numeric and text data, and you try to import the excel data using say DTS, it will give you either the text values or the numeric values and return NULLs for the other. This is a known problem in excel as it scans...
|
-
|
I was stuck at finding a solution to if a DTS Package is executing or not. It could have been started with the scheduler, or started manually. The only solution to this problem which I could come up with without any code changes to the package itself...
|
-
|
SQL Server 2000 DTS has a nice little Dynamic Properties task. But its usefulness for INI files is limited by some stupid limitations ( bugs/ features ) of the size of data in the INI files. To overcome it, the only possible solution I found was to write...
|
-
|
If you would like to write custom error messages to the DTS log files thru your ActiveX scripts, the DTSPackageLog.WriteStringToLog method can be of help. Just call it as DTSPackageLog.WriteStringToLog “Custom Error Message” and it will appear as a Task...
|
-
|
Very often there are cases when we want to have our DTS package to log error at a different path or file. This can very easily be achieved in the following way... Read the log file path from a config file and store it to a global variable called ErrorLogFile...
|
-
|
While working on an assignment involving some complex data loading using DTS Packages, I came across the need to loop through all the files present in a directory and perform a set of tasks for each file and also handle errors on a per file basis. I found...
|