The field clears...

But I just remembered that I had a perfectly well working project with same kind of situation and with Excel sources you must have the ConnectionString expression in...

OK, now I got the difference myself as well. Maybe I'll just ask the guy to experiment with the 64 bit setting..

v

Ok, sounds reasonable. SSDT is 32 bit... but what does the project setting 'Run64BitRuntime' do then...? It affects somehow because Excel loads does not work if that is set to...

I must ask the guy where the time is spent if possible to pinpoint that.

And the difference is two hours against one minute in this case...

v

"Except for the fact that you are using the F table in the source as well as in the destination in your SSIS package."

But isn't the Sql in the Where...

Hi,

this is not one of my packages but the dude is very experienced with SSIS - a standard data load. And yes SSIS and Sql2012, in the same Win server...

Hello,

OK, even though the GUI shows 'x' Enabled the create script has like below...

EXEC @ReturnCode = msdb.dbo.sp_add_jobschedule @job_id=@jobId, @name=N'LiDW_ETL_Paivittain_2045',

@enabled=0,

@freq_type=4,

@freq_interval=1,

@freq_subday_type=1,

@freq_subday_interval=0,

@freq_relative_interval=0,

@freq_recurrence_factor=0,

@active_start_date=20091106,

@active_end_date=99991231,

@active_start_time=204500,

@active_end_time=235959,...

Hi,

after uninstalling everything again and cleaning the register 00> ok

v

Hi,

I'm sorry if I missed the solution here but I need to export SEVERAL projects (folders) with tens of SSIS packages from Sql Server 2008 MSDB to Sql Server 2012...

Sorry, I've never heard of "servername@dbname" being a connection string for the native SQL Server connections. So I'm still blank on this.

==> this works anyway

Let me ask this, where are...

Hi,

via native sql server connectivity: servername@dbname and now, in new server, there is Sql 2012 client installed by a third party and it does not read one of the...

OK,

thank you for the info. I'll just let it run then and hope it finishes in time before the normal JOB routines start

ville

Hi,

the wait_type is 'PAGEIOLATCH_EX' and the reads, writes, logical_reads are changing all the time...

so does this meant that it is actually deleting but it just takes a long time...?

v

Hi,

just adding more info here

Like I said my Windows account have complete rights to the remote share, where the DTSX and CSV reside

1. I cannot even run the package from...

FYI

The name of the DBF file must be of old dos 8.3 format....

v