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

348 questions
20
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,039
  • 5
  • 12
  • 22
19
votes
0 answers

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
  • 321
  • 2
  • 10
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
16
votes
3 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,206
  • 8
  • 34
  • 53
15
votes
1 answer

Device tree compiler not recognizes C syntax for include files

I want to compile my board device tree manually. I have downloaded the latest version of dtc from its official source, but when I try to run the following command, I get an error advising me to change all #include directives to /include/ and so on…
Saleh
  • 1,246
  • 12
  • 32
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
  • 14,356
  • 8
  • 77
  • 106
11
votes
2 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,546
  • 17
  • 58
  • 95
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
9
votes
4 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
  • 311
  • 1
  • 3
  • 17
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
  • 58,244
  • 14
  • 113
  • 132
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,181
  • 8
  • 28
  • 35
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
  • 2
  • 8
7
votes
2 answers

Running DTS packages on SQL Server 2012

I read that DTS packages aren't supported in SQL Server 2012. I know there's a Backward Compatibility package/option out there that we used for SQL Server 2008R2 to run DTS packages. Will that Backwards compatibility package not work for SQL Server…
Gabe
  • 3,490
  • 9
  • 41
  • 72
7
votes
4 answers

Unit Testing for VBScript, ASP Code and SQL Server 2000

I have a very old project implemented in (classic) ASP and SQL Server 2000. Because of quality concerns, I've been considering the possibility of implementing some form of automated quality testing. Though, the web pages are ASP the project is…
Frank V
  • 23,732
  • 32
  • 98
  • 142
1
2 3
…
23 24