Category: SSIS
DTS SQL Statement / Stored procedure / Function to check for existence of file.
Important things to remember Existence of the file will be checked on the server in which it is created. If you are running this stored procedure on remote machine, it will check for file on remote machine and not on local machine. To call a function, you should write Here “dbo.” must be appended to…
|
How to Split Single Record into Multiple Records Using DTS?
There are many times a situation arises when we have to upload data from excel datasheet to SQL Server and the data in the sheet is not normalized. At that time, we need to make more than one record from a single record. Suppose you have a sheet in which each row in spreadsheet shows…
|
Why Do We Need DTS (Data Transformation Service?)
Lets say you have data in one format(It can be a database/file/excel spreadsheet also). You want to convert it into another format. You will have a thought of writing a VB program and convert the source file into the format of destination file. But wait a minute. If you have lots of files in the…
|