Stack Overflow
Stack Overflow

Questions tagged [dts]

Data Transformation Services, or DTS, is a set of objects and utilities to allow the automation of extract, transform and load operations to or from a database. The objects are DTS packages and their components, and the utilities are called DTS tools. DTS was included with earlier versions of Microsoft SQL Server, and was almost always used with SQL Server databases, although it could be used independently with other databases.

Data Transformation Services, or DTS, is a set of objects and utilities to allow the automation of extract, transform and load operations to or from a database. The objects are DTS packages and their components, and the utilities are called DTS tools. DTS was included with earlier versions of Microsoft SQL Server, and was almost always used with SQL Server databases, although it could be used independently with other databases.

More information: http://en.wikipedia.org/wiki/Data_Transformation_Services

342 questions
26
votes
1 answer

FFmpeg - What does non monotonically increasing dts mean?

Observations - Part - I I saw a suggestion elsewhere to run the following command to see if there's something wrong with my .mp4. ffmpeg -v error -i ~/Desktop/5_minute_sync_output_15mn.mp4 -f null - 2>error.log When I run the above command, I see…
Mukund Manikarnike
  • 387
  • 1
  • 4
  • 10
23
votes
6 answers

How to create an SQL table and and populate it with Excel spreadsheet data?

Is there an easy way to create a table in SQL Server (2005) from an Excel spreadsheet. I'm thinking maybe some tool? Thanks in advance.
Alonso
  • 1,069
  • 5
  • 12
  • 22
18
votes
4 answers

SSIS 2005: "Append rows to the destination table" is greyed out. Why?

In SQL Server 2005, Import Data (SSIS), my desire is to import a text file and have it append to an existing table. The first time through the wizard on the Column Mappings step I swear the Append rows to the destination table radio button was…
Pete Alvin
  • 4,646
  • 9
  • 39
  • 56
16
votes
1 answer

Audio/video synchronization, TS MPEG2;H264/AVC, understanding PTS in Handbrake

Synchronization has always fascinated me, or to be precise: why a .ts can be viewed in sync by media players, while the demuxed audio+video reassembled is out of sync. So I'm trying to understand this, and what can be done to prevent it. I've read…
Josh
  • 311
  • 1
  • 3
  • 11
13
votes
6 answers

SSIS Element cannot be found in a collection (but I have them all listed!)

I'm getting a persistent error: The element cannot be found in a collection. This error happens when you try to retrieve an element from a collection on a container during execution of the package and the element is not there. I've checked,…
Isaac
  • 351
  • 1
  • 4
  • 21
13
votes
4 answers

DTS_E_OLEDBERROR. Error code: 0x80004005.Difference between SQl Native client and oledb provider for sql server

There was a communication link error while I was using SQL Server Native Client 10 in an SSIS Data Flow component. Error: SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005. An OLE DB record is available. …
user1254579
  • 3,901
  • 21
  • 65
  • 104
11
votes
3 answers

PHP's DateTime::Diff gets it wrong?

DateTime::Diff should calculate a proper interval and take into account Daylight Savings Time (DST) and leap years. Although apparently it isn't so. Code of horror: $d1 = new DateTime("2011-10-30 01:05:00", new DateTimeZone("Europe/Stockholm")); $d2…
Martin Andersson
  • 18,072
  • 9
  • 87
  • 115
10
votes
1 answer

How to migrate DTS packages to SSIS 2012?

I need to migrate all the DTS packages created in SQL Server 2000 to SSIS 2012. What are the differences between SQL Server 2000 and SQL Server 2012. Are there any differences in SQL statements like Insert, Update, Delete etc. What are the things I…
user1806751
  • 101
  • 1
  • 1
  • 3
8
votes
3 answers

Can the ffmpeg av libs return an accurate PTS?

I'm working with an mpeg stream that uses a IBBP... GOP sequence. The (DTS,PTS) values returned for the first 4 AVPackets are as follows: I=(0,3) B=(1,1) B=(2,2) P=(3,6) The PTS on the I frame looks like it is legit, but then the PTS on the B frames…
hobb0001
  • 191
  • 1
  • 2
  • 7
8
votes
2 answers

Assembling SSIS Packages in PowerShell

I should preface by saying my experience with scripting or programming in OOP languages is limited. I'm working on a method for programatically creating and executing SSIS packages using PowerShell. Unfortunately, most of the resources available…
JNK
  • 63,321
  • 15
  • 122
  • 138
8
votes
4 answers

How can I run sql server stored procedures in parallel?

I want to do something like: exec sproc1 and sproc2 at the same time when they are both finished exec sproc3 I can do this in dts. Is there a way to do it in transact sql? Or is there a way to do it with a batch script (eg vbs or powershell)?
cindi
  • 4,571
  • 8
  • 31
  • 38
8
votes
2 answers

SSIS importing datetime column into SQL Server 2008

I am trying to import a PSV file into SQL Server 2008 using SSIS. All is working fine apart from one field that contains a datatime. The contents of the file being imported contains datetime in the format of 2012-08-08T13:31:28.170 The file…
Paul Ellaway
  • 101
  • 1
  • 3
  • 8
8
votes
5 answers

SSIS Transfer Database task cryptic error message 0x80131500

I am using SSIS with VS2010 (shell) and databases going from SQL Server 2005 (32 bit)to SQL Server 2012 (64 bit). I am developing directly on the destination server (not optimal, but it works). When I try to use the Transfer database task, it gives…
Watki02
  • 4,696
  • 7
  • 34
  • 36
7
votes
2 answers

What is the purpose of the fireAgain parameter in the Dts.Events.FireInformation method?

When firing Integration Services events from a script, I stumble a little on the FireInformation method from Microsoft.SqlServer.Dts.Tasks.ScriptTask.EventsObjectWrapper Dts property on…
sean woodward
  • 1,750
  • 1
  • 24
  • 36
7
votes
1 answer

FFmpeg DTS out of order

I'm having this problem when I want to concat and record two mp4 vids with ffmpeg. The output I get is: [concat @ 0x2566e80] DTS 4079 < 8156 out of order0:02:43.12 bitrate= 291.3kbits/s Complete output: /opt/ffmpeg/ffmpeg -f concat -i liste.txt…
Tim's
  • 93
  • 1
  • 5
1
2 3
…
22 23