Viewing 15 posts - 9,631 through 9,645 (of 13,880 total)
Will the tables all have the same DDL?
If not, this is practically impossible to do without C#/VB.NET coding. Unless you decide not to use data flows and instead code the...
September 25, 2013 at 10:59 pm
Koen Verbeeck (9/23/2013)
There is a poll option somewhere 🙂
Indeed there is. The 'Add Poll' button is there for precisely this reason :hehe:
September 23, 2013 at 11:50 pm
Koen Verbeeck (9/23/2013)
In the project deployment model, configurations as you know them are gone and they are replaced with parameters and environment, which are superior in my opinion.
And in mine....
September 23, 2013 at 11:49 pm
etl.laptop (9/20/2013)
Phil Parkin (9/20/2013)
etl.laptop (9/20/2013)
September 21, 2013 at 12:00 am
basic 79842 (9/20/2013)
September 20, 2013 at 11:42 pm
etl.laptop (9/20/2013)
Also, I have...
September 20, 2013 at 12:08 pm
kocamisu (9/20/2013)
I'm new using SSIS.But as i said at topic,had many success tests for these kind of things :
flat file to db or opposite db to flat file.For...
September 20, 2013 at 8:30 am
NOTE the code below has not been checked, it is symantec rather than syntactic.
I think you meant 'semantic', unless your solution is proposing an unorthodox anti-virus methodology 🙂
September 20, 2013 at 12:10 am
BowlOfCereal (9/17/2013)
September 18, 2013 at 2:03 am
Have you tried using a data conversion task?
September 16, 2013 at 1:03 pm
..back to SSIS.
If you want to update a row in SQL Server for every row that is transferred to Oracle, I'm not sure about this method. Are you trapping error...
September 16, 2013 at 7:04 am
...the performance of your package will plummet
Nice alliteration!
September 16, 2013 at 6:56 am
Or this maybe:
with MaxDates as (select id, MaxMod = max([Modified on]) from @Audit a group by id)
select a.id,a.Owner, a.[Modified on],a.Value
from @Audit a
join MaxDates m on a.id = m.id and a.[Modified...
September 13, 2013 at 5:09 am
nishav2 (9/11/2013)
So why is it saying 'Cannot open the data file" ?
Many servers have an additional layer of security which prevents file creation at the root of the c: drive...
September 12, 2013 at 12:23 am
nishav2 (9/11/2013)
Also the filename is stored in a variable and evaluated as expression:
Variable name...
September 11, 2013 at 11:38 pm
Viewing 15 posts - 9,631 through 9,645 (of 13,880 total)