dts Questions
6
Solved
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).
Wh...
Vaticide asked 5/6, 2012 at 21:11
4
Solved
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 ...
Bifocal asked 6/8, 2010 at 16:45
4
Solved
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 c...
Photodisintegration asked 6/2, 2014 at 13:7
6
Solved
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 pack...
1
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 nul...
Outclass asked 15/9, 2017 at 3:43
6
Solved
I am trying to export a large Access .mdb database to an SQL Server database and have been running into a problem where Microsoft DTS does not recognise the data type of a particular type of field ...
Chaunceychaunt asked 19/5, 2011 at 16:54
4
Solved
Using SQL Server 2005, but still using DTS. I need to add a step to check if a table is empty, and somehow fail the step if it is. It's easy checking if the table is empty:
Select count(*) from so...
Froude asked 2/9, 2009 at 16:6
2
Solved
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 Back...
Coccyx asked 7/6, 2013 at 14:26
1
Solved
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
Compl...
Electrolysis asked 12/9, 2014 at 10:26
2
Solved
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 Microsoft.S...
Spode asked 22/10, 2014 at 14:52
6
Solved
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.
Viscosity asked 7/10, 2008 at 15:56
2
Solved
I get an "Index was outside the bounds of the array." error when I do the following.
1) I launch the Import and Export Data Wizard (32 bit).
2) Data source: .Net Framework Data Provider for Odbc....
Cory asked 8/2, 2010 at 19:40
1
Solved
1
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 lik...
2
Solved
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 t...
3
Solved
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 ...
1
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 ...
Cowardly asked 18/1, 2011 at 20:12
2
Solved
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 PowerShel...
Phototube asked 2/2, 2011 at 19:9
4
Solved
In the past, I have used Informatica for some ETL (Extraction Transformation Loading) but found it rather slow and usually replaced it with some PL/SQL scripts (was using Oracle at the time).
(que...
Apocarp asked 24/12, 2009 at 2:56
1
I'm sure that this is a pretty vague question that is difficult to answer but I would be grateful for any general thoughts on the subject.
Let me give you a quick background.
A decade ago, we use...
Commination asked 12/9, 2010 at 5:54
6
Solved
I need to convert data that already exists in a MySQL database, to a SQL Server database.
The caveat here is that the old database was poorly designed, but the new one is in a proper 3N form. Doe...
Source asked 2/12, 2009 at 20:7
4
Our office uses SQL Server 2000, and by and large it has served our needs well. I'm looking into the possibility of upgrading to SQL 2005 or 2008 because of the new features not found in 2000 (when...
Plastid asked 23/4, 2009 at 0:14
4
Solved
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 d...
Jumna asked 10/11, 2008 at 13:53
3
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 loo...
1
© 2022 - 2024 — McMap. All rights reserved.