Topics
Started by
Posts
Last post
We have a straight-forward package: Text File to Table DTS. Problem is Text file is 200mb and takes…
5 replies
Is there a function or stored procedure where I can capture the name & id of a DTS package?
1 replies
Hello, I have a flat file that I am importing into Sql server and would like to transform the data …
3 replies
Am trying to a reverse look up to retrieve a value from the source DB which is FoxPro. When i try t…
1 replies
I'm trying to copy an Access table to a new SQl 2000 database using the import data function within…
4 replies
Hi, What happens to the discarded records in a bulk insert operation ? (discarded: constraint viol…
2 replies
I'm using MS SQL Server 7.0 and I've been looking for answers in several newsgroups about how to ex…
8 replies
Is there any way in DTS to export data in vertical text format. for example There are three fields …
4 replies
Hello-- I have a DTS package which has 4 tasks. The 3rd task is an import via query from a Sybase …
2 replies
hi all, need to brake up a single date column into multiple columns..i am new into using DTS i woul…
5 replies
for transforming date such as 01-jan-03 into month,day ,year ,quarter.. when i use the follwing co…
2 replies
hi there everyone, i want to add a column to the target table after Dts transformation ..and i want…
1 replies
I'm using a SQL 7 DTS that takes too much time (over 2 hours). We'd like to pin down exactly where…
11 replies
In my DTS pkg, I am using FSO to check if the file exist and if it does I want to save it with dif…
2 replies
We are calling T-SQLs from Execute SQL Task. The logic in T-SQLs is as follows: OPEN CURSOR .. FET…
2 replies
Viewing 15 topics - 3,151 through 3,165 (of 4,030 total)
You must be logged in to create new topics.